Just a quick post to say that the February CTP of SQL Server 2008 has been released. You can download it from http://technet.microsoft.com/en-us/bb851664.aspx . You will need to subscribe to Microsoft Connect - if you haven't already. Have fun! I know I will. Chuck
I've been seriously ramping up on the SQL Server 2008 feature set over the past few weeks, and I'm noticing that there are a ton of new features in the database engine that not a lot of people are talking about. Everyone hears about the biggies - Resource Governor, new Date data types, Spatial...
Have you had a chance to check out the resource governor in SQL Server 2008 yet? If not, you should take a look. The resource governor allows you to categorize a connection (at the time of login) into a workload group. That group exists as part of a resource pool. At the pool level, you can set minimums...