Database Administration - Category Archive
The following is a list of all entries from the Database Administration category.
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
Do You Use “Forced Parameterization”?
Database Administration,Performance Tuning | November 14, 2011 | 3:14 pmIn SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it overrides the default “simple parameterization” normally used by SQL Server. It does this by forcing most SELECT, INSERT, UPDATE, and DELETE statements to be parameterized, potentially boosting performance of databases by reducing the number of ...read more
SQL Server MVP Deep Dives: Volume II
Books,Database Administration | September 30, 2011 | 3:37 amTwo years ago when SQL Server MVP Deep Dives: Volume 1 was released, I had the opportunity to contribute two chapters. In SQL Server MVP Deep Dives Volume 2, I not only had the opportunity to contribute a chapter, but the privilege of being the section editor of the “Performance Tuning and Optimization” section of ...read more
Database Properties Health Check
Database Administration | September 26, 2011 | 6:07 amFor some time now, I have been working on a new book called How to Perform a SQL Server Health Check. I have written over 300 pages of it, and I am only about half way done. In the meantime, I have published a short except from the book on Simple-Talk.com. The article focuses specifically ...read more
Learning From the Mistakes of Other DBAs
Database Administration | July 8, 2011 | 11:24 amI have been a judge for the Exceptional DBA of the Year Awards ever since its inception, and one of the questions that is asked on the application form is “What is the biggest mistake you have made as a DBA, and how did you deal with it”. This question produces some interesting answers, many ...read more
Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?
Database Administration,Database Maintenance,Performance Tuning | June 1, 2011 | 12:44 pmEvery since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a problem. Essentially, when the OS writes a file to a disk subsystem, and if contiguous clusters are not available, they are written elsewhere on disk. So when a file is stored on disk in a ...read more
Do You Enable “Optimize for Ad Hoc Workloads”?
Database Administration,Performance Tuning | April 25, 2011 | 1:52 pmMost of the time when I run a poll on my blog, I run it for at least a month so that I can get enough results in order for the data to be more or less representative of the SQL Server community. What has been odd about this poll, is that even though I ...read more
SQLServerCentral.com Track at Orlando SQL Server Connections
Database Administration | April 1, 2011 | 4:30 pmThis past week, about 1,200 developers, IT professionals, and DBAs spent three days attending DevConnections at the J.W. Marriott Resort and Conference Center in Orlando, FL. While the above photo depicts a perfect Florida spring day, most of the time the weather was terrible with storms and rain. It really didn’t matter much for the ...read more
Twitter
Linked In