SQL Server Management Studio in a Multi-Site Cluster

Originally posted on Clustering For Mere Mortals:
If you set up a multisite cluster (nodes in different subnets), you will...

Continuing Series: System Center for the SQL Server DBA (SCOM Data Warehouse)

Originally posted on Blog Home for MSSQLDUDE:
Not really a new part to my multi-part series on System Center for...

System Center for the SQL Server DBA Part I: SCOM

Originally posted on Blog Home for MSSQLDUDE:
I’ll start part 1 of the Microsoft System Center series, focused on what...

System Center for the SQL Server DBA, cont’d SCOM Pack for SQL

Originally posted on Blog Home for MSSQLDUDE:
My original posting on System Center Operations Manager for SQL Server DBAs start...

SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run

Giving away FREE Access to my SQL Server High Availability and Disaster Recovery Deep Dive Course – Round 2

Originally posted on - Microsoft technologies and what I do for fun -:
Last year, as part of launching my very first...

SQL Server proxy account and local policy

Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...

Taking control of the ‘sa’ account for SQL Server 2012

As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath...

A quicker way to know when DBCC CHECKDB last ran in your database.

Problem : Surely you have scheduled jobs to run DBCC CHECKDB across your SQL Servers to check database integrity. But sometimes...

Setting Up Your Custom Data Collector Set

Problem: From my previous post, we learned how to set up Data Collection in SQL Server. This is most suitable...