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 […]
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 […]
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 […]
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 […]
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 […]
