Vote for me at SQLBits

SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted...

Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

Last month, I presented a session for Pragmatic WorksTraining on the T’s titled Introduction to Clustered Indexes and Heaps.  I’d meant to...

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

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

Antivirus Exclusion Policy for SQL Server

Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...

Colorado SQL Events for April 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...

Curation and Performance

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

Currys having apostrophe trouble

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

Data Collector in SQLServer 2014 – What’s New !

Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...

Manipulating Dates and Times in T-SQL

In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions....