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

Exam Prep 70-463: SSIS Expressions

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Excel Tip #21: Hiding Scrollbars in Excel Services Web Part

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...