SQL Server 2008

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

By: narender_as (51 month(s) ago)

thnx...nice ppt

By: atul.lakhanpal (51 month(s) ago)

yeah.....thnx

 

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