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

Show AutoGrowth Events with Powershell to CSV

This week I was reading Pinal Daves post about Autogrowth Events
http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/
as it happened I had a requirement to make use...

Using sp_DBPermissions and sp_SrvPermissions v6.0

It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....

Book Review – SQL Server Internals: In-Memory OLTP

In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to...