Officially disguised as a Canadian
Microsoft SQL Server (all versions)
The latest version of sp_WhoIsActive (and apparently last for SQL Server 2005/2008, according to Adam Machanic), was released a week ago. Yesterday, out of curiosity piqued by my recent three-week SQLskills training, I decided to run sp_WhoIsActive while doing a DBCC CHECKDB on a moderately large database (mainly because it takes longer, so it’s easierContinue reading Adventures in @BlobEater, sp_WhoIsActive and DBCC CHECKDB
I’ve finally got all four virtual machines required (per Jonathan’s blog series), up and running on my laptop, and it is taking serious strain. I’m inclined, in fact, to change all the machines from 2 vCPUs to a single vCPU each, because that’s what’s killing the machine. Then again, I never considered until February 2012Continue reading My laptop is crying
A week ago, I had just returned from a three-week sojourn in sunny Tampa, where I spent most of the time indoors, far away from the sun, relearning everything about SQL Server. Those three weeks are best summarised in my previous blog entry, where I described Immersion Event 1. The result was that I wantedContinue reading And he’s back …
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index finder to SQL Server 2000. I am fortunate in many respects, in that SQL Server 2000 does not support included columns, nor disabled indexes, so the scripts themselves were straightforward.Continue reading Remove duplicate indexes in SQL Server 2000
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because they are based on DMVs and catalog views built into SQL Server 2005 and higher. With her permission, I haveContinue reading My brain hurts
Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six. His blog has a walkthrough in SQL Server Management Studio if you prefer the GUI. [Note: If you copy and paste this code, please be sure to check the quotation marks. WordPress may changeContinue reading Increasing SQL Server Error Logs
Today at the clinic, we did the second of three phases of network reorganisation. In the first phase, which we completed a week ago, our new server was set up with the EMR software, all data was migrated from the old server, and the vendor remoted in to make sure everything was up and running.Continue reading What I did today
In February and March 2012 I’m taking a trip to Tampa FL to attend three weeks of in-depth SQL Server training, provided by Paul Randal and Kimberly Tripp, those legends of the SQL world. I cannot wait.
My boss convinced me this week to demo the new features in Microsoft SQL Server 2008 R2 to our team, so that they can get a basic handle on why I think SQL Server 2000 should be buried. The big day is on 27 January, and I have 45 minutes in which to make theContinue reading SQL Server 2008 R2 demo
“Thank you again for agreeing to participate in the upcoming in-depth telephone interview. I want to emphasize the importance of your opinions to our client, Microsoft. “You are one of only a few participants invited to take part in this research and your participation is extremely important. “You have been specially screened and qualified. IfContinue reading Microsoft Telephonic Interview