Welcome to the third day of DBA week at SQL University. On day one, I kicked off the “back to basics” journey I’ve chosen for fellow students with my post reminding you that you’re only as good as your ability to restore. Microsoft Certified Master Robert Davis brought us a good reminder on Day 2 […]
I spoke today at the SQL Server 2008 R2 Load Fest put on by Andy Novick of Novick Software. Great turnout, and it is always fun to see so many folks working together on the task of figuring out the nuances of SQL Server installations together. Also good to see that you were able to […]
Psst. Hey Vendor – DBAs are secretly plotting against you! We hate what your products do to our environments. Sometimes we even work to get you replaced by someone else who makes a product in the same space but is “DBA-Approved”…. What’s that? You want the DBA stamp of approval? I write this blog to […]
Why would anyone hire a DBA? Isn’t SQL Set-It-And-Forget-It?
So you have a plan to apply service packs to your SQL instances. You test them out and try to keep a regular schedule to ensure they are up to date. That is great. What About SQL Server Management Studio? What about the copy of SSMS that a developer is using to create scripts? This […]
It’s spring and in addition to our usual vegetable garden and some existing fruit crops, we are putting in a row of 15 blueberry bushes. Well the past two nights I’ve been outside for 3-4 hours digging a trench (about 40′ long by 2.5′ wide and 1′ deep. right, I said feet.) by hand and […]
Welcome to part 3 in this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Part 2 discussed security, playing around before doing a first install and smoke testing afterwards. Today […]