Cumulative Update #8 available for SQL Server 2005 SP3

Last week, Microsoft released Cumulative Update #8 for SQL Server 2005 SP3.  The build # is 9.00.4285.  You can read the blog post from the Release Services team here: http://blogs.msdn.com/sqlreleaseservices/archive/2010/02/15/cumulative-update-8-for-sql-server-2005-service-pack-3.aspx And the Knowledge Base article, #978915, is available here: http://support.microsoft.com/kb/978915 There is a noticeable omission here, as pointed out by […]

Bad habits to kick : using ancient copies of Books Online

In my last post in this series, I talked about inconsistent table aliasing.  Today I was reminded of another behavior that DBAs and developers alike can be lazy about: keeping Books Online current. There are always going to be mistakes in any set of documentation, and this is especially true […]

Speaking at SQLSaturday #33 in Charlotte, NC : 2010-03-06

I've been invited to speak at SQLSaturday #33 in Charlotte at the beginning of next month.  There are 9 tracks and a total of 54 sessions, with a great variety of sessions and a superb speaker lineup.  You can check out the schedule here: http://www.sqlsaturday.com/33/schedule.aspx And more details about the […]

MacGyver Moments

I was tagged by David Stein, a.k.a. Made2Mentor [ blog | twitter ], to talk about "MacGyver Moments" in my career – times when I've turned nothing into something.  One clearly comes to mind, though it was more like keeping a dying server on life support than building something fantastic […]

Connect Digest : 2010-02-16

Simon Sabin has asked for better usability in the SQL Server Agent log viewer: specifically, to allow you to get to job / step properties directly from the history viewer. #531889 : Allow access to job details from the log file viewer to improve manageability Guru Itzik Ben-Gan asks for […]

Bad habits to kick : inconsistent table aliasing

In my last post in this series, I wrote about ignoring the principle of least privilege, since a lot of people fall into the trap of following the path of least resistance.  This time I wanted to touch on a topic I've touched on before: aliasing. Over the weekend, there […]

[OT] : Headed to the Olympics

Just wanted to drop a quick note to let people know that I will probably be pretty quiet on here for the next two weeks.  We leave tomorrow for Vancouver to spectate at several events at the Olympics, and won't be back until the end of the month. This means […]

Bad habits to kick : blind SQL Server installs

In my last post in this series, I talked about some problems associated with relying on undocumented behaviors and commands.  This time I wanted to touch on SQL Server configuration, and some of the items I see where more thought should have been put into the process when SQL Server […]

Bad habits to kick : relying on undocumented behavior

In my last post in this series, I talked about the common habit of creating an IDENTITY column on every single table.  Today I want to talk about a more broad concept: relying on undocumented (and therefore probably undefined, and certainly far from guaranteed) behavior and objects. ORDER BY in […]

Injection is not always about SQL

I think anybody even remotely involved with databases these days has seen the xkcd comic about Bobby Tables : http://xkcd.com/327/  Basically, the comic warns against SQL injection, and reminds you to sanitize your database inputs rather than blindly append incoming data to queries.  There are more elaborate discussions about this […]