The first 24 Hours of PASS event will be starting September 2, 2009, and will feature 24 different SQL Server-related sessions by 24 different speakers, and all for free. So if you haven’t signed up for this event yet, you still can at 24hours.sqlpass.org.
I will be presenting on Using SQLdiag to Troubleshoot SQL Server Problems, during session 5, which starts at 4:00 GMT. Hope to see you at my session.
I am presenting a 3-hour session on the SQL Server 2008 Data Collector.
The devLink Technical Conference, held August 13-15, 2009 in Nashville, TN was the largest devLINK event every held, with over 675 attendees. This once a year event, held at Lipscomb University in Nashville, offered over 96 sessions in 9 different tracks, including 1 database-specific track.
The event, which only cost $100 ($75 for early sign-up) drew attendees not only from Tennessee, but from over 30 states and most of the Canadian provinces. The event not only included three days of training, but all lunches, snacks, and a .NET Rocks event with Carl Franklin and Richard Campbell. Continue reading
I used to work at a multi-billion dollar organization and, like most organizations that big, they kept backups of all their databases offsite in case some major catastrophe destroyed the data center. There was only one problem with their otherwise excellent plan; the offsite location for the backup tapes was the building next door, a mere 50 yards from the data center. Any disaster spectacular enough to take out the data center would most probably have damaged or leveled the building next door. Continue reading
To certify or not to certify? That’s one big question that can easily fire up a room of DBAs. In this article I explore the reasons for and against becoming a certified DBA and cover the certifications out there that are of most interest for us in the industry. Read more…
SQL Server 2008’s Performance Data Collector lets us create a central repository to store performance data and includes three built-in Data Collection sets that can be used to collect and store this data. Three built-in reports can then be used to access the stored data, so we can identify and troubleshoot SQL Server performance problems. Want to find out how the Performance Data Collector works and how it can help you? Read more…
So long as data is inserted, updated and deleted from tables, indexes will become fragmented over time, and performance will suffer. Index maintenance is vital to keeping databases and their users happy. In this article, I go through the key index maintenance tasks and identify more essential areas that are a DBA’s duty to maintain. Read more…
Brad M McGehee 