SQL Schoolhouse! Today’s installment of the Saturday SQL Schoolhouse is brought to you in honor of World Backup Day, a day every DBA should celebrate! However, DBAs know that World Backup Day should be practiced daily! Here are some great backup articles for you to peruse. Enjoy! Introduction to Backup and Restore Strategies in SQL…
Month: March 2012
SQL Server 2012 on VMware vSphere
Microsoft recently released SQL Server 2012 to the wild just a couple of weeks ago. Even though this release is in its infancy, organizations and their database administrators should immediately begin to explore and plan for the adoption of this release into their corporate technology roadmap. Multiple features in this release are individually tremendous, and…
Best Practicing, the Results Part Dos
This week, we have been talking about running the Microsoft Baseline Configuration Analyzer 2.01 with the SQL Server Best Practice Analyzer for 2008 R2. Today I want to talk about one of the errors that occurred on one of the new boxes I just stood up in a new cluster. You may encounter a prerequisite error stating that the…
Best Practicing, the Results Part I
Yesterday, I showed you how to install the Best Practices Analyzer and use it through the Baseline Configuration Analyzer. Even after your servers are setup for best practices, it is good to run the BPA from time to time to look for changes, especially if you have more than one DBA working on your servers. Here…
Whitepaper: Demystify Tempdb Performance & Management
There are many misconceptions and myths about tempdb and purported best practices are inconsistent at best. It’s hard to know which advice to follow when one resource says to always do it one way and another tells you to always do it the opposite way. Many times, both resources are correct in certain situations or…
Best Practicing? Here’s How!
Are you trying to conform your systems to Microsoft standard best practices? Have you used Microsoft’s tools for automating this? The first item you will need is the Microsoft Baseline Configuration Analyzer 2.0 (download). It will help you to maintain optimal system configuration by analyzing against the predefined set of best practices which we will download…
Back In the Saddle Again
After spending a week at Paul Randal’s Immersion Event training, a week dedicated to standing up our new clusters, and then SQL Saturday this past weekend in Tampa, I am glad to get back to my SQL Servers. I missed them. Does anyone else ever feel like Gollum from Lord of the Rings, me neither. Now to…
Refreshing Development Databases
Been a busy week at work and I’ve had to perform multiple dumps of production databases back to a development server. This is something that would normally be pretty quick and easy however a couple of things impacted that and led to having to make some choices about how to perform the task. Here are…
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
I’ve lost count of how many times I’ve heard that phrase. Are you specialized? On something? Or anything at all? Has that been a good or a bad thing? Why? Are you the SQL guy at work? Or the one who does everything? Do you code? And