sql server 2008
Download
Skip this Video
Download Presentation
SQL Server 2008

Loading in 2 Seconds...

play fullscreen
1 / 15

SQL Server 2008 - PowerPoint PPT Presentation


  • 382 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' - 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

SQL Server 2008

By

Sam Nasr

March 25, 2008

agenda
Agenda
  • SQL Server 2008 Features
  • Break
  • Business Intelligence(BI) Features
  • Certification
  • Q&A
  • Surveys/Raffle
  • Networking at Winking Lizard (Rockside)
sql server 20083
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
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
What’s New?
  • Platform Features (DBA)
  • T-SQL Features
  • Data Types
  • Reporting Services
platform features
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
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
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
Date/Time Variables

SQL Server 2005:

SQL Server 2008:

filestream
Filestream
  • Filestream storage attribute on varbinary(max) column
  • Includes transactional access through Win32 API
    • PathName()
    • Get_Filestream_Transaction_context()
    • OpenSqlFileStream()
slide11
Demo

Table Value Parameters

Grouping Sets

HierarchyID

New Date/Time variables , & datetimeoffset

business intelligence
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
CTP Gotchas (installation)
  • Services had to be set to Local System
  • Client tools failed to install initially
ctp gotchas rs
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
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