tailieunhanh - SQL Server 2008: What To Expect

Are you ready for Microsoft SQL Server 2008? The truth is, many of us are still coming to grips with the great new features of SQL Server 2005 so, when I ask this question to other database professionals, the response is usually a polite answer, something of the order: “We may wait for the first service pack .” SQL Server 2005, being a five-year release, included many architecture changes across the board and famously had so many new features that, in order to fit them all on one PowerPoint slide, Microsoft had to use a 10-point font! Well, in the words of David Campbell, General Manager. | Global Knowledge Expert Reference Series ofWhite Papers SQL Server 2008 What To Expect 1-800-COURSES SQL Server 2008 What To Expect Brian D. Egler Global Knowledge Course Director MCITP-DBA MCSE MCT 2008 Introduction Are you ready for Microsoft SQL Server 2008 The truth is many of us are still coming to grips with the great new features of SQL Server 2005 so when I ask this question to other database professionals the response is usually a polite answer something of the order We may wait for the first service pack. SQL Server 2005 being a five-year release included many architecture changes across the board and famously had so many new features that in order to fit them all on one PowerPoint slide Microsoft had to use a 10-point font Well in the words of David Campbell General Manager of SQL Server at Microsoft the SQL Server 2008 release nicknamed Katmai is a 14-point font release The saving grace is that with this release the new features build on the existing architecture of SQL Server 2005 so Katmai is largely an evolutionary release as opposed to a revolutionary one allowing us to apply our existing skills while learning the new features. In this white paper we ll explore some of these impressive new features so you can start planning your future upgrade strategy. Microsoft SQL Server 2008 Table Parallelism Perspectives . and many more SQL Server Change Tracking Synchronized Programming Model Visual Studio Support SOL Server Conflict Detection FILESTREAM datatype Integrated Full Text Search Sparse Columns Large User Defined Types Date Time Data Type LOCATION data type SPATIAL data type Enterprise Reporting Engine Internet Report Deployment Block Computations Scale out Analysis Bl Platform Management Export to Word and Excel Author reports in Word and Excel Report Builder Query Optimizations Persistent Lookups Change Data Capture Backup Compression MERGE SQL Statement Data Profiling Star Join - l-ansparent Data Encryption External Key .