SQLSaturday Phoenix

This weekend, I’m flying to Phoenix to be a part of SQLSaturday there. I will present two new sessions on...

tSQLt – SQLCop – Checking Naming Conventions

I’ve been using tSQLt a bit to do some testing and one of the things I’ve tested is standards for...

Dynamic Data Masking

Dynamic Data Masking
FEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last...

Gimme A Break! Taking Mental Health Days - WaterOx Consulting

Reading Time: 3 minutes  Burnout! You have been stressing over the big project you have...
The post Gimme A Break! Taking...

How to do DevOps as a SQL Server DBA

You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support...

My Upcoming Speaking Engagements

March 4 – Charleston PASS, Charleston, SC
What Admins Absolutely Must Know About SQL Server Security
There are so many security tips out...

My Upcoming Speaking Engagements

March 4 – Charleston PASS, Charleston, SC
What Admins Absolutely Must Know About SQL Server Security
There are so many security tips out...

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

Parsing SQL Saturday Data – Getting Titles from the XML document

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database....

PWDCOMPARE–a hidden function of SQL SERVER TIP #88

 
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to...