T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard

It is April and April Fools has only just begun.  Well, or so Matt Velic (blog | twitter) would have us...

T-SQL Tuesday #53–Why So Serious?

It’s an interesting topic this month for T-SQL Tuesday #53. When I read Matt Velic’s invitation, I became intrigued. I...

Currys having apostrophe trouble

Before I start I just want to say that much of this post is mere speculation on my part and...

Question of the Week -08/04/2014

Suppose we need to find out the name of all the months in a given year (Year will be given...

Answer - Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)

Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?

Options:-

a) 1

b) 2

c) More...

[SQL Snacks Video] SQL Server Table Partitioning 101

I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare...

T-SQL Tuesday #53 Why So Serious

This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long?...

Curation and Performance

I’m trying out a new web site from Microsoft called Curah! that is all about curation. Curation is basically what...

Read Flat File Contents to Variable – Write Variable Value to Flat File

When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable,...

The system_health Extended Event Session

When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...