DBA News & Scripts

SQL server techniques, how-to's and other random ramblings

Query Full Table Scans via the Search Cached Plans DMV

SQL Server Dynamic Management Views (DMVs) are a powerful feature set introduced with SQL 2005 that allows you to pull...

SQL 2005 and 2008 Perfmon Counters

Identifying SQL Server performance bottlenecks can be quite a complicated process. With so many counters required to assess where potential...

DMV Missing Index Report

Dynamic Management Views are a great way to peak under the covers of SQL Server to see what’s going on...

How to Fix Orphaned Users (SQL Server)

Whenever a database is moved from one SQL Server to another, it’s only the database users which are carried across...

How to Find SQL Logins with NO Database Mappings

SQL Server is one of the most common attack surphases for would-be hackers, so it’s important to maintain a good...

How to Grant Read-Only Access to Activity Monitor

Give your clients the ability to view activity monitor, without handing over full sys-admin rights into your managed SQL server...

Deprecated features in SQL Server

It’s important to always be mindful when moving databases between SQL version that implemented features have not been deprecated in...

Recompiling All SQL Server Stored Procedures

Whenever updating statistics, introducing new indexes or removing old indexes, the following script offers a quick and simple way to...

How to find the SQL Server Product Key

For SQL Server 2005 [crayon-5dcf5c6e1009b704208916/] For Sql Server 2008 R2 [crayon-5dcf5c6e1009e505144654/] For SQL Server 2012: USE MASTER GO EXEC XP_REGREAD

How to Resolve an Agent XPs disabled error

The following commands enable Agent XPs within SQL Server, in order to allow you to restart the SQL Agent service;...

How to Setup Mirroring in a WorkGroup using Certificate Authentication

The following guide steps you through the process of setting up a SQL mirroring configuration between two servers on a...

Emulating a SQL Cluster using Mirroring

This was a pre-SQL 2012 solution (where Availability Groups would have been the obvious way to approach this problem) which...

Contact Us

We typically respond within minutes.