Tag Archives: sql server

Kill a SPID

Posted on July 13, 2012 by way0utwest

This editorial was originally published on Sept 5, 2007. It is being re-run as Steve is traveling. I know some people get a kick out of running the KILL command. Heck, I’m sure all of us enjoy stopping a runaway … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Kill a SPID

Time Zones

Posted on July 10, 2012 by way0utwest

Why don’t we have a function like the one in this article to convert from time zone to time zone? Seems like something SQL Server should have added awhile ago.

Posted in Blog | Tagged , , | Comments Off on Time Zones

Using a Symmetric Key

Posted on June 27, 2012 by way0utwest

In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is a serious subject, and please do your research and education, as well as testing, before you implement it. This post … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment

Documenting the Undocumented

Posted on June 26, 2012 by way0utwest

There are any number of functions in SQL Server that are undocumented. I have no idea how many there are because, well, they’re undocumented. I can’t see the source code, so I’m not sure what’s actually encoded in the platform. … Continue reading →

Posted in Editorial | Tagged | Comments Off on Documenting the Undocumented