Brad M McGehee | SQL Server DBA

Popular pages

• Brad M McGehee | SQL Server DBA

  SQL Server DBA

• How to Use SQL Backup Inside a Maintenance Plan | Brad M McGehee

  When you create a SQL Server Maintenance Plan using the Maintenance Plan Wizard or the Maintenance Plan Designer, the SQL Server native backup command is used to perform full, differential, and transa...

• Do You Ever Physically Defragment Your SQL Server MDF & LDF Files? | Brad M McGehee

  Every 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 c...

• Instant File Initialization Speeds SQL Server | Brad M McGehee

  Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see the end of this posting for a description), I created a new 50GB database. The databas...

• SQL Server Security Checklist | Brad M McGehee

  In this post, I continue my checklist series that will eventually become a new book. The focus of this checklist is SQL Server security, a very important topic that is often neglected because many DBA...

• SQL Server Operating System Checklist | Brad M McGehee

  As a part of a new book project, I am putting together a series of checklists that DBAs can use to inventory and audit their servers. Previously, I blogged about my SQL Server Hardware Checklist, in t...