SQL Server 2008 – Resource Governor Questions
The engineers from Microsoft PSS have posted some excellent information on thier blog about SQL Server 2008’s Resource Governor.
New Article: Determining SQL Server database storage requirements
I’ve published a new tip over on SearchSQLServer.com entitled “Determining SQL Server database storage requirements“.
SQL CLR: The What, When, Why and How.
There are two camps when it comes to SQL CLR. The DBA camp, which says don’t use it, it’ll kill your SQL Server and the Developer camp which says that it will save you loads of time and that you should use it for everything.
XML in the database. What’s the big deal any way?
So, we’ve had the ability to use XML within the SQL Server databases since SQL 2000 came out. What’s the big deal? How can I use it to make my life easier? …