Category Archives: SQL Server

I’ve used DMVs in PowerShell and SQL Server demos a few times but hadn’t really dug into them.  There isn’t a lot of information available on DMVs but that will change early next year when SQL Server DMVs in Action … Continue reading →

I went on to the Microsoft site looking for books on SQL Server 2008.  What you get is an incomprehensible jumble of stuff.  Don’t tell me about everything there is – let me get to the information I want. I … Continue reading →

I decided to experiment with SQL Server 2005 installing on Windows 2008 RC0.  For the most part everything seems to be OK.  You will be prompted that SP2 of SQL Server 2005 is required. The Visual Studio 2005 components are … Continue reading →

I’ve been experimenting with Reporting Services for various reasons and I have discovered that RS seems to get very upset if you rename the server after installation.  A fact that it is better to discover in a VM than in … Continue reading →

Sat 70-443 this afternoon – Designing Database Server Infrastructure using SQL Server 2005.  Its the usual design exam format with a number of testlets each of which presents a scenario and then asks a number of questions. The exam is … Continue reading →