1 / 15

SQL Server 2008

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

gabrielj
Download Presentation

SQL Server 2008

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server 2008 By Sam Nasr March 25, 2008

  2. Agenda • SQL Server 2008 Features • Break • Business Intelligence(BI) Features • Certification • Q&A • Surveys/Raffle • Networking at Winking Lizard (Rockside)

  3. SQL Server 2008 • Code name “katmai” • Currently in Beta • CTP available for free download • CTP contains working features end-end • RTM in Q3 2008

  4. 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

  5. What’s New? • Platform Features (DBA) • T-SQL Features • Data Types • Reporting Services

  6. Platform Features • Transparent Data Encryption • External Key Management • Data Auditing (change tracking) • Hot Add CPU • Transparent Failover • Policy Implementation • Auto Synchronization (conflict detection)

  7. 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)

  8. T-SQL Data Types • Geometery (for planar shapes, i.e. whse layout) • Geography (for GPS coordinates) • HierarchyID • date • time • datetime2 • Datetimeoffset (timezone )

  9. Date/Time Variables SQL Server 2005: SQL Server 2008:

  10. Filestream • Filestream storage attribute on varbinary(max) column • Includes transactional access through Win32 API • PathName() • Get_Filestream_Transaction_context() • OpenSqlFileStream()

  11. Demo Table Value Parameters Grouping Sets HierarchyID New Date/Time variables , & datetimeoffset

  12. 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

  13. CTP Gotchas (installation) • Services had to be set to Local System • Client tools failed to install initially

  14. 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.

  15. 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

More Related