Archive for March, 2011
A Fairy Tale – Epilogue
When the cheers subsided and the parade was over (oh yes, there was a parade; complete with floats and bagpipes), the DBA found herself dissatisfied. There was a minor detail that was nagging at her. What about those linked servers that used an alias? With her original query, the remote server would be the alias [...]
March 31, 2011
Tags: aliases, linked servers, xp_regread Posted in: General, T-SQL 
No Comments
A Fairy Tale
Once upon a time there was a developer who was concerned about the security of his application’s data. So he decided to change the password for his application’s SQL login. So he logged into the database and used sp_password to change his password and he was happy. On the other end of the hall lived [...]
March 28, 2011
Tags: linked servers, system views Posted in: General, T-SQL No Comments
Using Service Broker to replicate logins
Talking about mirroring and its shortcomings got me thinking: there has to be a reliable way to replicate logins from the primary server to the mirror. Sure, you could do it manually, that would work just fine for those applications with a limited number of logins where there isn’t much turnaround. But then again, if [...]
March 24, 2011
Tags: Event Notifications, Service Broker Posted in: Features, General One Comment
Mirror, Mirror…
So, while I was discussing database snapshots in SQL Server, I kind of glossed over the subject of database mirroring, assuming you already had it set up in your environment. But maybe you don’t. So today I’m going to go through the steps involved in setting up database mirroring in SQL Server 2008. To keep [...]
March 21, 2011
Tags: certificates, high-availability, mirroring Posted in: Features, General No Comments
Database Snapshots – Part 3 – Data Recovery
In this final part of our series on SQL Server database snapshots, I’m going to talk about what, I think, is the most forgotten feature/use of snapshots: data recovery. If you (or ‘a friend’) makes a mistake and deletes data you shouldn’t have, or perhaps accidentally drops a table, if you have a snapshot, you [...]
March 17, 2011
Tags: general dba, recovery, snapshots Posted in: Features, General 2 Comments
