Free Professional Advice on Setting up Continuous Integration for Sql Server Databases

Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...

Free Professional Advice on Setting up Continuous Integration for Sql Server Databases

Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...

Free Professional Advice on Setting up Continuous Integration for Sql Server Databases

Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous Deployment Do you want to get your databases...

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