Peter DeBetta's blog about programming in SQL Server 2008, 2005, etc. using technologies such as T-SQL, .NET, CLR, C#, VB, Visual Studio, and SQL Server Management Studio.
With some help from two esteemed colleagues, Greg Low and Mark Whitehorn, the Introducing SQL Server 2008 book is now content complete. Sure, there is still some tech and copy editing that needs to be done, but the core writing is complete. The book, based on the Feburary CTP6 release, will be available free from Microsoft and covers a slew of new features including:
- Policy-Based Management and Auditing
- Transparent Data Encryption and Data and Backup Compression
- Resource Governor
- Performance Data Collection
- New data types including HierarchyID, Filestream, Spatial, Date and Time, and Enhancements to the XML data type
- Table Types (and Table valued parameters)
- T-SQL Enhancements including Merge, Single statement declaration/assignment, Increment Operators, and GROUPING SETS
- Sparse Columns and Filtered Indexes
- High Availability Enhancements for Database Mirroring and Failover Clustering
- Business Intelligence Enhancements for Integration Services, Reporting Services, and Analysis Services
I'll post again when the book is available for download.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Peter DeBetta
Peter DeBetta is an independent consultant specializing in design, development, implementation, and deployment of Microsoft SQL Server, Microsoft SharePoint Server, and .NET solutions. Peter writes courseware, articles, and books – most notably the title Introducing SQL Server 2005 for Developers from Microsoft Press. Peter speaks at conferences around the world, including TechEd, SQL PASS Community Summit, DevTeach, SQL Connections, DevWeek, and VSLive!
Peter is a Microsoft MVP for SQL Server, an MCP, President of the
North Texas SQL Server User Group, and a member of PASS.
When Peter isn’t working, you can find him singing and playing guitar (click
here to hear an original song by Peter), taking pictures, or simply enjoying life with his wife, son, and new daughter.