Getting Under The Hood

Whenever a piece of software does something that makes me think this is awesome I find myself blocking out the...

Planning a High Availability and Disaster Recovery Plan in Madison, WI

I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster...

SQL Server 2014 Deprecated Features

SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...

Stupid T-SQL Tricks – Part 2: Retrieving Columns Set to the Current DEFAULT CONSTRAINT Value

“Heeeeeere’s Johnny!” – Ed McMahon introducing Johnny Carson for the Tonight Show
If you’re old enough to remember the Tonight Show hosted...

T-SQL – How to get the Financial Quarter details of a date field

declare @table table
(
[Paid Date] date
)

insert into @table
values('20150102'),('20150512'),('20150830'),('20151231'),('20141230')

;WITH Quarters AS (
SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION
SELECT Q = 'Q2',...

24HOP Russian Edition

Spoke at 24HOP Russian edition.
Interesting experience.
It is difficult to determine mood of audience if there is no visible audience  🙂
And...

ALTER SCHEMA TO ADD PERMISSIONS

I’m sure some of you have wanted to do this:
ALTER SCHEMA Steve AUTHORIZATION Steve

You realize this doesn’t work, and you...

Can an EKM Save The World of Data? - WaterOx Consulting

Reading Time: 4 minutesQuis custodiet ipsos custodes? Who will guard the guards themselves? – Latin...
The post Can an EKM Save The...

Why not NOLOCK?

Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at...

Women in Technology

Warning: rant forthcoming.
I don’t get the women in technology problem. Oh, I understand and see the problem. I also understand...