Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS

TweetG’day,
As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open...

Amazing SQL Saturday #197 in Omaha

Today I had the privilege of working with a great bunch of folks to help coordinate and host Omaha’s second...

SQL Saturday 203 Boston, Deck and Demos Live!

Hello Dear Reader!

A quick note I'm presenting today at 1:30 pm for SQL Saturday Boston #203.

I'll be giving my...

Multiple ALTER DATABASE SET options

TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...

Remembering Alan Weber, @Aauugold

We lost someone this week. We lost a fellow SQL-ite, a Twitterer, a DBAs@Midnight chatroom live chatter. We lost someone...

Use delegated session configuration in Powershell 3.0

Powershell 3.0 has many new feature, and they are useful in some circumstance.

let's say User A log in server A,...

Weekly Links – 05/04/2013

I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...

Don't Alienate Your Customer

This should go without saying, because most of us have been on the receiving end of poor customer support. However,...

Time Based Power Settings

Just recently I was part of an online presentation in which the intended audience was unable to install any of...

The PUBLIC role – Do not use it for database access!

As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges...