Why am I being forced to learn PowerShell?

I spent an annoying afternoon with SQL Server 2008 today.  When we installed it on our cluster it created a job called “syspolicy_purge_history”.  I assume it does this in most installations but I haven’t checked.  The job was generating an error every time it ran.  A quick…

Interviewed on RunAs Radio

I was recently interviewed on RunAs Radio.  We spent quite a bit of time talking about performance tuning.  I’m spending quite a bit of time lately looking at how things get into and out of the query cache and we touched on that a bit.  We also spent some…

Test your backups!

The purpose of making a backup is to be able to restore it at some point.  Many of the companies I visit do regular backups but haven't ever restored one of them.  If you really want to be safe, test the process to pull a SQL Server backup from off-site…

Scriptio available on CodePlex

Scriptio is a little utility I wrote when I was unhappy with the scripting features in SQL Server 2005.  The biggest problem I faced was that I couldn't script a DROP and CREATE in the same file.  I'm pretty sure that's finally fixed.  The utility gives you all kind of…

SQL Server 2008 to RTM in Q3 of 2008

Francois Ajenstat posted today that Microsoft expects to release SQL Server 2008 to manufacturing in the third-quarter of 2008. Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to manufacturing…

ReadTrace for SQL Server 2005

Microsoft just released an updated Read80Trace that works on SQL Server 2005.  The name is simplified to just ReadTrace.  ReadTrace is a command-line utility that analyzes a SQL Server trace file and summarizes performance.  The new version has a more graphical interface.  The original was one of the most helpful…