Test your UPDATEs and DELETEs before you run them

This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...

Tales of a DBA fed up with NOLOCK. Part 1

Nov 12, 2014

Dear Diary,

They asked for help again. Every now and again everything slows down and they see a lot...

TSQL Tuesday #63 – How do you manage security: Rollup

When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was...

TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...

Dealing with layered function calls

T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...

TSQL Tuesday #63 – How do you manage security?

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...

A quick email interview of Pass President Thomas LaRock

Back in December I had the thought that it would be fun to do an email interview with someone. As...

SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...

Constraint names, Say NO to the default

Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it...

Except and Intersect

EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...