After creating a few new SQL accounts this morning, I thought I would share how I keep track of minor details like this. We use SharePoint for our department to track documents, procedures, processes, etc. This is a great place to track minute SQL Server details like accounts and databases. For example, we have over…
Tag: General BP
Final Thought from SQL Saturday Pensacola Pre-Con
For my final blog about SQL Saturday #132, I wanted to leave you with one all-encompassing piece of advice that I received from the pre-conference training on Friday prior to the event. The pre-con titled “Demystifying Database Administration Best Practices” was presented by Microsoft Certified Masters Robert Davis (twitter|blog) and Argenis Fernandez (twitter|blog). Of course, I will preface this…
Good Best Practice Advice from the Pensacola Pre-Con
For my first blog about SQL Saturday #132, I wanted to review some of the good advice I received from the pre-conference training on Friday prior to the event. The pre-con titled “Demystifying Database Administration Best Practices” was presented by Microsoft Certified Masters Robert Davis (twitter|blog) and Argenis Fernandez (twitter|blog). Some of these I knew, some…
Vendor Support–The Good And Bad
When you go out and buy yourself new hardware or software you have the option of purchasing maintenance agreements at the same time. For software this generally provides the ability to constantly upgrade to the latest and greatest product. For hardware this tends to provide onsite support for when things go wrong and an SLA…
The Importance Of Good Documentation
Believe it or not I’m not actually talking about server documentation here (for an excellent post on that go read Colleen Morrow’s The Importance of a SQL Server Inventory). I have spent the last 12 days dealing with a single production release. It is being considered a significant release, but to be honest it really…
Something Technical This Way Comes
To quote Ray Bradbury in Something Wicked This Way Comes: “Everything that happens before Death is what counts.” Wow! How simple and profound. Do you live your life as if it counts for something? Do you have a passion? Are you living your life for that passion? My passion is best practices for SQL Server and I am…
I Am Passionate About Best Practices
After writing for the Tribal SQL project, I think I’ve realized just how passionate I am about best practices. For example, the other day I asked my wife if she could change our bed sheets to which she replied that they had only been on there two weeks. My retort was that best practices dictated changing 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…
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…