Last night at our SQL Server user group meeting the presenter ran into issues with his first demo. The topic was Change Data Capture, and the first step was enabling CDC on a newly created database; the stored procedure sp_cdc_enable_db threw an error on execution. This demo was critical because all the other demos in…
A case of slow performance on Windows 2008 R2
Windows Server 2008 R2 was released in 2009, but we still have many customers on Windows 2003 (and probably some on Windows 2000 I’m sure). I’ve run into an issue with two customers when they upgraded their SQL Server and Windows version at the same time, and thought I would share the details in case…
The Most Important Maintenance Task…
We had a customer lose their entire database this week. The server failed in some manner and they tried to recover the database from the disks, but they could not bring the database online. They engaged our group and we tried everything we could to no avail. Until now, the most data loss I had…
Session News
It’s after 11 PM, I’m sitting in my hotel room, and this is pretty much the expression I’ve had all afternoon: See, emails about PASS Summit sessions went out this afternoon and I was thrilled to learn that two sessions I submitted have been accepted. Woohoo!! I am very honored and want to thank the…
