Database Administration - Category Archive
The following is a list of all entries from the Database Administration category.
At the End of One Chapter and the Beginning of a New Chapter
Database Administration | August 15, 2012 | 11:26 amI have been told by hundreds of DBAs that I have the best DBA job in the world as Director of DBA Education for Red Gate Software. And this has been very true. In the five plus years I have been with Red Gate I have traveled over 500,000 miles (breaking the million mile record ...read more
Do You Document Your SQL Server Instances?
Database Administration | June 5, 2012 | 11:41 amWhen I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced, I realized the importance of having complete, up-to-date documentation for all of the SQL Servers I manage. Some of the benefits of documentation include: 1) It is easier and quicker to find information when needed, ...read more
Favorite DBA Books
Books,Database Administration,DBA Career | May 1, 2012 | 4:38 pmIn the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have compiled the results, and below are the most popular books my blog’s readers picked. If you are looking for a good SQL Server book to learn from, then you might want to consider reading one ...read more
A Quick Introduction to Data Compression in SQL Server 2008
Database Administration,Performance Tuning | March 13, 2012 | 4:29 pmThere is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups grow, and it never stops. The more data we have, the more work SQL Server has to perform in order to deal with it all; whether it’s executing a query on a table with 10 ...read more
March Question: What tool(s) do you use to help you identify and tune slow performing queries?
Database Administration | March 1, 2012 | 1:00 amTuning poorly performing queries is one of the most important jobs of the DBA. With this in mind, this month’s qustion is “What tool(s) do you use to help you identify and tune slow performing queries?” This can include tools that come with SQL Server, your own custom-written scripts, or third-party tools. Tell us about ...read more
Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned
Database Administration,Performance Tuning | February 27, 2012 | 12:48 pmI was very surprised to see the results of my latest poll, which asked “When was the last time you tuned your transaction logs?” According to those DBAs who responded to the poll, about 60% of them said they didn’t know transaction logs could be tuned. And just over 19% said they have never tuned ...read more
Excerpt from Upcoming Book by Grant Fritchey Called Learn “SQL Server in a Month of Lunches”
Database Administration,Database Maintenance | February 15, 2012 | 11:36 amLater this year, a new book by author Grant Fritchey, called Learn SQL Server in a Month of Lunches, will be released by Manning Publications. Below is a preliminary excerpt from the book on “Creating a Full Backup”. The book is geared toward readers new to SQL Server. Creating a Full Backup The full ...read more
What’s Wrong with this Picture: A Database Misconfiguration Well Demonstrated
Database Administration | January 6, 2012 | 3:35 pmRecently, I was doing some testing/playing around on a particular database on my home test servers. After I was done, I checked out the “Data/Log Files Autogrowth/Autoshrink” portion of the “Disk Usage” report for the database, which is shown below. While I might expect to see results like this on a test box, I would ...read more
Twitter
Linked In