SQL Server 2008 lets you copy database with data: turn on Script Data in the Generate Scripts wizard to get INSERT statements for the rows in your tables.
How to Patch SQL Server Without a Bad Morning
Before you patch SQL Server, check backups, plan replica and cluster sequencing, record builds, and prepare a tested recovery path.
Auditing Who Changed What, and When
Plan SQL Server auditing around the question you need answered, then distinguish security events from row history, change tracking, and CDC.
A Health Check for an Inherited Server
A health check for an inherited server reviews backups, access, configuration, error logs, and jobs before anyone changes the system.
SQL SERVER – Clustered Index on Separate Drive From Table Location
A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.
The Scripts Worth Having on Every Server You Touch
Keep focused DBA scripts for active requests, blocking, table size, index usage, backups, and failed jobs, with clear limits on each result.
SQL SERVER – Questions and Answers with Database Administrators
While hiring Database Administrators and senior developers for a large project, we discussed many interesting questions. Here are some, with my own views.







