I received recently an email from a friend asking for my help as he faced a problem. He runs a small business in the healthcare industry and his needs in terms of IT should and are minimalist, if you want. And that's expected. Of course, I asked what was the problem about and he said: … Continue reading Corruption she (the DBCC) wrote….
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
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
Yes, I have another couple of minutes to document this weird message. I was trying to access the database properties for one of our databases. Guess what: I couldn't as there was no owner! Well, the easiest thing to do is to alter the authorization on the database; as you may have guessed it already, … Continue reading Say What? – “Management Studio: must be set in single thread apartment (STA) mode before OLE calls can be made”
This blog post is waiting for me to have some time for the past couple of months by now. It did bite me back then, and so it did yesterday. "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Error source: Microsoft OLE DB Provider for SQL Server" … Continue reading Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Error source: Microsoft OLE DB Provider for SQL Server – revisited
The amazing guys @SQL Sentry (www.sqlsentry.net) are giving away a chance to win a free seat to SQL Skills Internals and Performance training (check out the details: http://www.sqlsentry.net/sqlskillsimmersion.asp).Of course, I decided to give it a try, so I wrote to the guys; you can check it below:"Hello there.Now, last night at around 2:30 AM I … Continue reading My mail to SQL Sentry that will win me (yeah, right) a free seat to SQL Skills training!
First off, apologies to the 3 readers I have (I don't read my blog post, I just write), since all of them are far better than I am when it comes to clustering. To cut it short: how can you move ANY resource from one node to another? Namely, the disk witness in the quorum … Continue reading Move cluster group from one node to another
Another quick one today: how do I create an alias using the registry editor? If you want to want to ask me why would you do such a thing, it means you're reading the wrong blogJ. To cut it short, here are the entries in the registry: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo] – this is for x64 machines who … Continue reading Create SQL Server aliases using registry editor
I recently learned to hate even more the virtualization thing – once your host fails, guess what, everything else goes downJ. Anyway, the topic for today is not related to my personal feelings, but to DBCC failing on one of my servers. Msg 1823, Level 16, State 2, Line 1A database snapshot cannot be created … Continue reading Error message: “A database snapshot cannot be created because it failed to start” when running DBCC
Another quick one for today: When you encounter such an error (see the title and the print screen below), you might want to check this first: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/b0665753-6bb6-48bb-a938-febc6e942d58 For the really lazy ones: it's a clear sign of memory pressure. I hope this helps. Best regards,io