Monthly Archives: July 2011

TSQL Tuesday #20: T-SQL Best Practices

This month’s TSQL Tuesday is hosted by Amit Banerjee ( blog | @banerjeeamit ) and topic is TSQL Best Practices.  Now, I have never taken a T-SQL class, and I am not a database developer.  I have spent minimal time with anyone, one on one, reviewing the “right way” to write T-SQL code.    I understand…

STEM and the Third Culture: A Case for Interdisciplinary Education

Today’s post is courtesy of Claire Willett of softartisans.  You can find Claire’s blog here, or follow her on Twitter ( @softartisans ).  A couple weeks ago Claire posted an interview with my friend Jes Borland ( blog | @grrl_geek ) which sparked an email exchange.  Claire asked if I would participate (of course I…

Presenting with Demos aka Running with Scissors

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…