Interview with SQL Server MVP Glenn Berry
Database Administration,DBA Career,SQL Server Connections | August 31, 2010 | 11:19 amThis is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections in November 2010. This interview is with SQL Server MVP Glenn Berry (blog | Twitter). Tell us a little about yourself Glenn. After high school, I spent four years in the Marine Corps, serving ...read more
Microsoft Offers New Certification Exam Discount
DBA Career,News | August 27, 2010 | 4:07 pmIf you are intending to take any Microsoft Certification tests soon, you are in luck, because Microsoft has recently introduced a discount you will want to take advantage of. If you are willing to purchase a 2-exam or 3-exam certification pack, you will get a 15% discount off the cost of the exam’s regular price. ...read more
SQL Server Monitoring Checklist
Database Administration | | 3:36 pmIt’s been awhile since I have worked on my checklist series of blog posts that will eventually be turned into a book. This time around the checklist focuses on the kinds of things you might want to monitor on your SQL Server instance to ensure that they are working as you expect. Unlike some of ...read more
DBA Tracy Hamlin Wins the 2010 Exceptional DBA of the Year Award
DBA Career,News | August 20, 2010 | 8:49 amTracy Hamlin (Twitter) has been voted as the 2010 Exceptional DBA of the Year by the SQL Server community. The annual awards program, hosted by SQL Server Central and sponsored by Red Gate Software, drew the largest number of community votes in its three-year history. Tracy receives a trophy, full conference registration for the PASS ...read more
Checkout SQLServerIO.com for Useful Information on SQL Server Storage Systems
Database Administration,Hardware,Performance Tuning | August 18, 2010 | 4:45 pmAt the recent SQLSaturday #28 in Baton Rouge, LA, I had the opportunity to meet Wes Brown (Blog | Twitter), and attend his session on “Understanding Storage Systems and SQL Server”. I enjoyed his presentation and also discovered that Wes has a blog where he shares his deep knowledge of SQL Server I/O. If you ...read more
How Do You Defragment Your SQL Server Indexes
Database Administration,Database Maintenance,Performance Tuning | | 11:05 amI give a lot of presentations based on best practices, and in all of them I stress the importance of regularly rebuilding or reorganizing indexes. Both the REBUILD and the REORGANIZE options have their pros and cons, so I thought it would be interesting to do a poll to see which method(s) was preferred by ...read more
Don’t Forget to Sign Up for the 24 Hours of PASS: Summit Preview
Conferences,PASS,Speaking Schedule | August 17, 2010 | 9:47 amLooking for some free SQL Server training? How about 24 hours of free training offered by some of the top SQL Server experts in the world? If so, sign up for the upcoming 24 Hours of PASS live webcasts to be held September 15-16, 2010. It’s your opportunity to continue and broaden your SQL Server ...read more
How to Performance Tune a VLDB on your Desktop
Database Administration,Performance Tuning | August 16, 2010 | 3:17 pmRecently, I wrote a review of Red Gate Software’s new SQL Virtual Restore software. SQL Virtual Restore allows you to quickly turn a compressed backup into a live, virtual database, with the advantage that the virtual database is substantially smaller than the original database, while at the same time acting identically to the production database.
RSS
Twitter
Linked In