Finally Got around to something about SQL Server 2008

I had a chance to attend a talk by Senior SQL Server PM about SQL Server 2008, and following were some of the key takeaways:

 The key tenants in SQL Server 2008 are:

  • Trusted - provide mechanisms to secure data (such as database encryption), ensure business cotinuity (through improvements in mirroring, clustering), predictable response (through the resource governor)

  • Productive - manage by policies, simplify application development (through LINQ), store any information (additional data types such as HirearchyID, seperate time and date, etc)

  • Intelligent - integrate data, deliver relevant information, drive actionable insights

Lots of the new features for SQL Server 2008 will be available in November CTP (CTP4) - so make sure to login to the MS connect site at - to get the latest CTP.

 Resource Governor - a great new feature a lot of my customers have been asking for. It will enable DBAs to assign resources to differnt workloads in SQL Server. So for example with the use of ALTER commands DBAs will be able to assign more CPU resources to OLTP based tasks than say a reporting workload. The changes take in effect real time and upon execution of the alter statements.


 Declartive Management Framework - a feature that enables DBAs to set policies for managing the SQL Server environment. Unfortunatley I dont have more info on this at the I was starting to doze off while the PM was talking about this feature. I will ensure to follow up with more information on this in later blogs.

Spatial Data - ability to store geo spatial data will be made avaiable as part of SQL Server 2008.


Reporting Services - whole lot of new enhancements to this feature of SQL SErver 2008, with the incorporation of Dundas Charting and visualisations and OfficeWriter functionality allowing users to author reports straight out from Excel and Word (Office 12 and later). Another fantastic feature is a new Report Designer tool that has the Office 2007 ribbon and is the new end power user tool to develop reports without requiring to install Business Intelligence Studio (BIDS). BIDS will still be there for managing the entire BI solution, e.g. SSIS, SSAS, SSRS.


For more information on SQL Server 2008 you can visit: and dont forget to download the latest CTP in Nov 2007 to get your hands dirty :).


Happy SQLing


Comments (5)

  1. I wanted to follow-up to an earlier post that may help anyone managing a SQL server.

    Microsoft has released a new 30 day evaluation environment that you can add to your existing network to try Essentials 2007 on up to 10 Servers and 50 Clients. Working with actual servers and clients will give you a first hand experience of how Essentials 2007 can help you manage your networked environment.  Installing the SQL management pack will allow you to monitor and manage your SQL server from a single unified interface

    Read more details at


  2. If you have any other systems you are trying to manage, you can use all of the relevant management packs from one unified interface with Microsoft Systems Center Essentials 2007.  Check out:  

  3. aw says:

Skip to main content