Quick question, who owns your databases? And how about your jobs? Don’t know? Go find out…now find out without using the GUI. Querying sys.databases will give you the owner_sid. The trouble is that you have to relate that owner_sid back to a user. The same with sysjobs, that sid needs to relate to someone. You…
Month: April 2012
The Importance Of Good Documentation
Believe it or not I’m not actually talking about server documentation here (for an excellent post on that go read Colleen Morrow’s The Importance of a SQL Server Inventory). I have spent the last 12 days dealing with a single production release. It is being considered a significant release, but to be honest it really…
Something Technical This Way Comes
To quote Ray Bradbury in Something Wicked This Way Comes: “Everything that happens before Death is what counts.” Wow! How simple and profound. Do you live your life as if it counts for something? Do you have a passion? Are you living your life for that passion? My passion is best practices for SQL Server and I am…
I Am Passionate About Best Practices
After writing for the Tribal SQL project, I think I’ve realized just how passionate I am about best practices. For example, the other day I asked my wife if she could change our bed sheets to which she replied that they had only been on there two weeks. My retort was that best practices dictated changing the…