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 2008 :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()


Slide 11: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