Where Do You Go for Authoritative SQL Server Best Practices?
Opinion | June 27, 2011 | 11:36 amReprinted from my editorial in Database Weekly. In early 2000, I started a new DBA job with a large organization, as their first full-time SQL Server DBA. My first job was to clean up the mess left by several accidental DBAs who had gone before me, and who had implemented several SQL Server instances without ...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
June Question: How Do You Monitor Your SQL Servers?
Question of the Month | | 12:30 amAs DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected. So, for this month’s question, “How do you monitor your SQL Servers?”, please share with us how your monitor your SQL Servers. For example, do you monitor them manually using SSMS, use custom-designed T-SQL or ...read more
RSS
Twitter
Linked In