Sql server 2008
Download
1 / 15

SQL Server 2008 - SQL Server 2008 - SQL Server 2008 - PowerPoint PPT Presentation


  • 380 Views
  • Uploaded on

SQL Server 2008. By Sam Nasr March 25, 2008. Agenda. SQL Server 2008 Features Break Business Intelligence(BI) Features Certification Q&A Surveys/Raffle Networking at Winking Lizard (Rockside). SQL Server 2008. Code name “katmai” Currently in Beta CTP available for free download

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SQL Server 2008 - SQL Server 2008 - SQL Server 2008' - Pat_Xavi


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Sql server 2008 l.jpg

SQL Server 2008

By

Sam Nasr

March 25, 2008


Agenda l.jpg
Agenda

  • SQL Server 2008 Features

  • Break

  • Business Intelligence(BI) Features

  • Certification

  • Q&A

  • Surveys/Raffle

  • Networking at Winking Lizard (Rockside)


Sql server 20083 l.jpg
SQL Server 2008

  • Code name “katmai”

  • Currently in Beta

  • CTP available for free download

  • CTP contains working features end-end

  • RTM in Q3 2008


System requirements l.jpg
System Requirements

  • Supported Operating Systems:

    • Windows Server 2003 Service Pack 2

    • Windows Server 2008

    • Windows Vista

    • Windows XP Service Pack 2

  • For all download types:

    • 32-bit systems:

      • Intel compatible Pentium III 600 MHz (1 GHz recommended)

    • 64-bit systems:

      • 1 GHz CPU

      • 512 MB of RAM (1 GB recommended)

      • 675 MB of available hard disk space


What s new l.jpg
What’s New?

  • Platform Features (DBA)

  • T-SQL Features

  • Data Types

  • Reporting Services


Platform features l.jpg
Platform Features

  • Transparent Data Encryption

  • External Key Management

  • Data Auditing (change tracking)

  • Hot Add CPU

  • Transparent Failover

  • Policy Implementation

  • Auto Synchronization (conflict detection)


T sql features l.jpg
T-SQL Features

  • Table Value Parameters

  • FileStream Object Storage

  • Merge

  • Variable initializers

  • Row constructors with >1 row

  • Compound operators (+=)

  • Grouping sets (extension of Group By clause)

  • Intellisense added

  • New Collations

  • CLR UDT 2GB capacity

  • Integrated Full Text Search

  • Sparse Columns (Indexing)


T sql data types l.jpg
T-SQL Data Types

  • Geometery (for planar shapes, i.e. whse layout)

  • Geography (for GPS coordinates)

  • HierarchyID

  • date

  • time

  • datetime2

  • Datetimeoffset (timezone )


Date time variables l.jpg
Date/Time Variables

SQL Server 2005:

SQL Server 2008:


Filestream l.jpg
Filestream

  • Filestream storage attribute on varbinary(max) column

  • Includes transactional access through Win32 API

    • PathName()

    • Get_Filestream_Transaction_context()

    • OpenSqlFileStream()


Slide11 l.jpg

Demo

Table Value Parameters

Grouping Sets

HierarchyID

New Date/Time variables , & datetimeoffset


Business intelligence l.jpg
Business Intelligence

  • SSRS free with SQL Server 2008

  • Incorporates Dundas Controls

  • Render to MS-Word

  • Scale out Analysis (read-only)

  • Subspace computations/aggregations

  • New Cube Design Tools

  • Best Practice Design Alerts

  • IIS Agnostic SSRS


Ctp gotchas installation l.jpg
CTP Gotchas (installation)

  • Services had to be set to Local System

  • Client tools failed to install initially


Ctp gotchas rs l.jpg
CTP Gotchas (RS)

  • Move objects only by dragging the “move” icon

  • “move” icon is not always visible

  • ReportName not populated

  • ReportServer not automatically configured on localhost.


References l.jpg
References

  • Microsoft SQL Server 2008

    http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

  • SQL Server 2008 Web Casts

    http://www.microsoft.com/sqlserver/2008/en/us/events-webcasts.aspx

  • Microsoft SQL Server 2008 CTP, February 2008

    http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en

  • "First to Know“ SQL Server 2008 Exam Offer

    http://www.microsoft.com/learning/mcp/sqlvs/offer/default.mspx


ad