logging in or signing up SQL Server 2008 asrm Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 3370 Category: Education License: Some Rights Reserved Like it (3) Dislike it (1) Added: November 03, 2009 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... By: narender_as (25 month(s) ago) thnx...nice ppt Saving..... Post Reply Close By: atul.lakhanpal (25 month(s) ago) yeah.....thnx Saving..... Edit Comment Close Premium member 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 You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
SQL Server 2008 asrm Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 3370 Category: Education License: Some Rights Reserved Like it (3) Dislike it (1) Added: November 03, 2009 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... By: narender_as (25 month(s) ago) thnx...nice ppt Saving..... Post Reply Close By: atul.lakhanpal (25 month(s) ago) yeah.....thnx Saving..... Edit Comment Close Premium member 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