This is the first of three big script updates this month, so stay tuned! I’ve written before about how my SQL script evolve over time. Well, the script I just published last month has already been updated. I had been deploying the script on all the SQL Servers I manage, rather than just the handful […]
Monitoring the health of your SQL Servers is a standard part of a DBA’s job. One of the most important parts, to tell you the truth. It’s tempting to think of databases as unchanging. You can check them once and, if they are healthy, your job is done. There is no need to check it […]
Lately, I noticed that SSMS was taking longer and longer to start. When I started at my company a couple years ago, SSMS would come up fairly quickly. Now, it was taking about 3 minutes to start up. As the time gradually increased, I initially chalked it up to newer versions of SQL – in […]
We recently upgraded our installation of Great Plains from version 10 to Dynamics GP 2010 and ran into some difficulties with the upgrade hanging. We’re using SQL 2008 R2 as our database back end. Let me first state that I was not involved in this upgrade and it was our vendor who was working with […]
Apparently, there is some controversy on the internet about the value of obtaining a Microsoft certification (and certifications in general, I suppose). I’ve never really followed it or even read anything about it online. I had come to my own conclusions about it and that was that. For the longest time, I felt certifications were […]