Well, it's about time I write another blog post (with a promise that I'll do it more than once a year). I'm going to start a series of "bad habits to kick" as for me it is important that we all have a common ground on SQL Programming. 1. Consider the following scenario: SET … Continue reading DATETIME and its surprises
Tag: troubleshooting.
Create certificate from backup fails on SQL Server 2008
This is so going to bite yer ass if you don't pay attention… As usual, a very quick post: I tried to create (ok, restore) a certificate from the production server to our DR server, so that the automated restores would work. When I ran the script (yes, CREATE CERTIFICATE … FROM FILE […]), I … Continue reading Create certificate from backup fails on SQL Server 2008
Cannot shrink the log – now what
Happy New Year anyone (and Gong Xi Fa Cai, since it's rapidly approapching). Now this one really asks for a blog post, since I saw it too many times on various forums and I just got it on one of my production servers. I just got an alert that we're running low on space on … Continue reading Cannot shrink the log – now what
SQL-PLAY 