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...

Security: People Are the Weakest Link

There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...

The Great Laptop Search of 2013

It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a...

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...

Ask the Expert Panel: NJ Special Event

Ever wanted to know all there is to know about SQL Server, and afraid to ask?  Have questions about how...

How I prepared myself for the MCSE certification

Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...

Is BETWEEN faster than GTE and LTE?

I know I have been light on blog posting this year. They always say that life tends to get in...

SQL Server Events in the UK – April 2013

The bank holiday and work have put me a few days behind schedule, but here is the list out all of the...

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...