An Introduction to SQL Server

There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be...

No more NebraSQL

After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?)  I have...

How BETWEEN is inclusive

This is a old and simple one, but an important subtlety that TSQL developers must be aware of.

Using the BETWEEN...

OVER() clause two simple ways on two different days

I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...

SQL Server: Part 4 : Approaching Database Server Performance Issue

In the last three parts, we have discussed about different queries that can be used to list the current state...

DBMail on a cluster

I’ve always found clusters a pain in the neck.  For my latest pain I just spent the last 2 days...

T-SQL Window Functions on LessThanDot and at SQL Saturday 149

I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions.  The enhancements to SQL Server 2012...

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...

Participate in the PASS Election Process

Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...

One More Reason for Portable Applications

I bet most of us don’t think about installing software that we need/want to try. We’re either running as local...