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

Increasing ColumnStore compression ratio for archival and “Cold storage”

At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...

Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month

Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...