Script: Query Full Table Scans via the Search Cached Plans’ DMV
Use SQL Server's plan cache DMVs to surface full table scans, missing indexes, and columns with no statistics without running a trace or waiting for an incident.
Read article →
Identify Performance Bottlenecks with SQL 2005 and 2008 Perfmon Counters
Identify exactly where your SQL Server is struggling using the Perfmon counters experienced DBAs rely on first for memory, disk, locking and CPU diagnostics.
Read article →
Uncover Missing Indexes with DMV
Learn how to use SQL Server's missing index DMVs to identify index gaps that are quietly draining CPU and I/O from your production environment.
Read article →
How to Fix Orphaned Users in SQL Server
Orphaned users are one of the most common issues after SQL Server migrations and restores. Learn how to identify and fix them before they break production access.
Read article →
How to Find SQL Logins with NO Database Mappings
Orphaned SQL Server logins with no database mappings are a hidden security risk. Learn how to find and review them as part of your SQL Server security audit.
Read article →
How to Grant Read-Only Access to Activity Monitors
Learn how to grant read-only Activity Monitor access in SQL Server using VIEW SERVER STATE, without handing over sysadmin rights.
Read article →
Be Mindful of Deprecated Features in SQL Servers
Relying on deprecated SQL Server features is one of the fastest ways to turn a planned migration into an emergency. Learn how to audit and address them before you upgrade.
Read article →
Recompile All SQL Server Stored Procedures with this Script
Recompile all stored procedures in a SQL Server database with a single script. Refresh stale execution plans after schema or statistics changes without dropping any objects.
Read article →
Find the SQL Server Product Key with the Right Script
Retrieve your SQL Server product key directly from the Windows registry using xp_regread. A reliable method for licence audits, migrations and disaster recovery.
Read article →
How to Set Up Mirroring in a Workgroup Using Certificate Authentication
Learn how to set up SQL Server mirroring in a workgroup environment using certificate-based authentication, including optional witness server configuration for automatic failover.
Read article →
How to Set up DB Mirroring using T-SQL
Set up SQL Server database mirroring with T-SQL to bypass GUI edition restrictions and configure synchronous or asynchronous mirroring with a repeatable, scripted process.
Read article →
How to List the Database Name and File Locations
Learn how to quickly list every SQL Server database name and its physical file locations using sp_msforeachdb and sys.sysfiles, essential knowledge for any DBA.
Read article →