Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence. I read everything I could on the topic. I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins. (Perhaps that list of favorites might, in and of itself, make a good blog post). Fast-forward a decade and I’m still mightily interested in operational excellence for IT organizations. It’s just that so much good material is available for free on the web.
Here’s a run-down of several useful documents and downloads to improve overall operation performance for those of you in a Microsoft-centric IT organization:
Microsoft Operations Framework
Microsoft Operations Framework (MOF) version 4.0 guide is practical guidance for IT organizations. With the release of version 4.0, MOF now reflects a single, comprehensive IT service lifecycle—it helps IT professionals connect service management principles to everyday IT tasks and activities and ensures alignment between IT and the business.
Infrastructure Planning and Design
The Infrastructure Planning and Design (IPD) guides are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario.
Microsoft Baseline Security Analyzer 2.2 (for IT Professionals)
The Microsoft Baseline Security Analyzer provides a streamlined method to identify missing security updates and common security misconfigurations. MBSA 2.2 is a minor upgrade correct minor issues and add optional catalog support.
Security Compliance Manager
The Microsoft Security Compliance Manager provides centralized security baseline management features, a baseline portfolio, customization capabilities, and security baseline export flexibility to accelerate your organization’s ability to efficiently manage the security and compliance process for the most widely used Microsoft technologies.
EPIC FAIL! This was supposed to go out last week. But I didn’t schedule it properly, so I’d just like to point out that there are lots of other great webcasts to watch at the Pragmatic Works webcast URL below. Plus, my session will be available via streaming by the end of the week. And thanks the the 1600 folks who registered!
-=-=-=-
Come join me on Tuesday, August 2, 2011 11:00 AM – 12:00 PM EDT for a free webcast covering the internals and architecture of Microsoft SQL Server. It’s not everyday that a dry topic like this is presented in a fun and easy to understand format, so get in while the gettin’ is good. :^)
Registration is free, thanks to the fine folks at Pragmatic Works.
First off – the Pain of the Week webcast series has been renamed. It’s now known as The Expert’s Perspective. Please join us for future webcasts and, if you’re interested in speaking, drop me a note to see if we can get you on the roster!
The bigger your databases get, the longer backups take. That doesn’t really seem like a huge problem — until disaster strikes and you need to restore your databases as fast as possible.
Join my buddy Brent Ozar (blog | twitter), a Microsoft Certified Master of SQL Server and good friend, as he reveals ways to make these critically important maintenance tasks run faster.
You’ll discover:
Why Instant File Initialization is so important for restores
How to use DMVs to check restore progress
How to find the bottleneck while you’re backing up or restoring data
Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE.
You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE.
SSWUG.ORG’s virtual webcasts will prepare the “Accidental DBA” for patterns and practices they will experience in their role as a database administrator. I will provide easy-to-understand insights and realistic examples for professionals who have not had any formal DBA training. By the end of our four-part series, you should have the information needed to get up to speed on database planning, administration and performance tuning basics.
Session Descriptions
In the first session, you will see what is needed to fulfill the role of a (Database Administrator) DBA by learning more about what is typically expected of administrators and where the bulk of the work is done. Regardless if you are a draftee or volunteer to the position, the information applies to anybody wanting to better understand and fully own their title.
Over the course of the second session, you will find out why it is important to grasp some of the tips and tricks that DBAs have practiced for many years. I will emphasize about the need for documentation, testing, automation, sharing experiences and continuing your education.
During the third session, you will understand the reasons why the DBA is the sheriff in town! That’s why it’s important to know what you’re dealing with in your departments and inside your databases. I will explain how to inventory, determine what is not your responsibility, talk to your stakeholders, learn the business cycles and tackle important tasks.
The fourth and final session will emphasize the four essential skills needed to survive and excel in your database administration position – Communication, Troubleshooting, Benchmarking and Automation. I will explain how to leverage these abilities toward increased job security and professional successes.
I would like to make you aware of a recently written paper by Bert Scalzo. The paper focuses on how DBAs can rely on the Toad and Benchmark Factory to perform database workload replays, ensuring that changes to the databases do not degrade the user experience.
I encourage you to read the paper and make workload replay a part of your database change management practices. As I’ve been saying for years, if you don’t have quantitative evidence of what normal is for your database, how can you know what is abnormal?
I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm – now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990′s on SQL Server v6.5 or some such. But I digress…
No, not that kind of script!
Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating statistics, and so forth. One of the script kits came directly from Microsoft’s internal database management team. But, alas, they haven’t published any updates in quite a while. On the other hand, the other set of scripts came from Ola Hallengren, who has done a great job keeping his scripts up to date.
Recently, Ola added support for updating column statistics, both in a generalized update and also updates for only those columns whose statistics have been modified. He’s added some other goodies to the latest release, which you can read about here, http://ola.hallengren.com/Versions.html for all details.
In addition, I’d like to remind you of the white paper I wrote a while back called Automating DBA Processes, which covers many aspects of database automation and cherry picks some of the best practices from many different thought leaders, such as Ola, Michelle Ufford (blog | @sqlfool) who will be speaking at the 24HOP soon, and Allen White (blog | twitter).
Quest Software’s latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse.
The best things about Project Lucy include:
It’s Free – just like our SQLServerPedia website, Project Lucy is free to anyone who wants to upload a trace file
It’s 1oo% web-based – you don’t have to download or maintain anything and updates roll out seamlessly, all the time
It really helps – just generate a SQL Trace on a SQL Server 2000, 2005 or 2008 instance, upload it on www.projectlucy.com, and see for yourself
This initiative empowers DBAs and IT professionals to gain a better understanding of their database performance through automated analyses and collaboration with their peers. Our goal is to allow users to go beyond the benefits of installing and using a commercial product, and tap into an online community to share and compare experiences and results.
Our goal is to test the best ways we can help users learn and understand what their performance data really means, and how they should act upon that data – if at all – in a collaborative, meaningful way. For this debut, Project Lucy will accept SQL Trace files, or zip files containing multiple traces, and will provide a summary of the content and areas where performance can be improved. As y’all use the service, information will become available to help you compare your performance and engage in meaningful discussions with others about the issues you are facing.
Your feedback, your feedback, and participation will drive how Project Lucy evolves. Get involved by participating in the pilot program! And let me know what you think.
I always enjoy spending time with my friends from Atlanta, as well as meeting folks and making new friends. If you live in the Atlanta area, I hope you’ll join me on the evening of Wednesday, February 9th, 2011. Details are at the Atlanta SQL Server user group website.
It’s common knowledge that I have a terrible memory for many things. However, one of the few things that my memory is usually really good at is remember names & faces (and remembering stories, but that is another story as well).
It’s only in the last couple years that I’ve gotten to know Atlanta-area folks like Aaron Nelson (blog | twitter), at left. Aaron likes to tease me because the first time or two we talked after our initial introduction, I kept getting his name wrong. That’s uncharacteristic of me. But, hey, I was distracted because Aaron had brought his 12 year old daughter along and I kept wishing that I’d brought mine! Aaron has really good content on SQL Server and PowerShell on his blog and in his presentations. Don’t miss out!
The Flying Ainsworth Brothers
Another person in the Atlanta area I’ve enjoyed getting to know better is Stuart Ainsworth (blog | twitter). Stuart has really stepped up to the plate these last couple years as a leader and a volunteer. I’m really impressed with his efforts, especially because they’re in very important but rather invisible and thankless tasks. One example is his work in succession governance for PASS. Stuart, I salute you and thank you for your efforts.
I hope to see y’all there! And if I don’t, y’all come up and visit us in Nashville some time.
