Well, besides the obvious trouble of not getting enough mirror time for myself, of course…no, this is about the model database for SQL Server. The other day I had the need to create a new database. I also had the need to create it for a specific size. What I didn’t have a need for … Read more
I’ve had this script in my toolbox for a few years now. I didn’t create it initially, and I have no idea who did. This script helps you to identify duplicate indexes. Why is that important? I’m glad you asked, mostly because I’m tired of answering my own questions and it’s good to have someone … Read more
When the Cloud breaks, who fixes it?
Less than 24 hours after posting a list of things I am thankful for, where I expressed Thanks for not having to restore master, I found myself awake at 3AM in order to restore master after we had a server lose its data drive. Before I got started I decided to check on the definition … Read more
