PASSMN Board of Directors Nominations

It’s that time of the year again.  Time to get in some nominations for the 2011 PASSMN Board of Directors. ...

Tip: OVER and PARTITION BY

Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…

OVER
OVER allows you...

It’s Implied

This has been on my radar now for a little over a week.  I ran across a  request in the...

SQL Saturday New England: The Date

Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...

How Do I Spot Identity Columns That Are About to Max Out?

Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...

SSWUG Fall 2010 Virtual Conference This Month

Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up.  On October 20-22, you can attend a conference from...

Reminder – Deadline for SQLRally Pre-Con Abstracts is October 15th

See my previous post on the topic,or just go directly to the application.The application has full details, but MVP’s, Summit...

Return of Index Analysis Part 1

Let’s Anaylze An Index!Time for part two of my continued Index Analysis query.  The previous posts in this series are:
Analyze...

SSC Editorial – Great Service

I wrote the editorial about great service after noticing a couple small but interesting customer service experiences during two trips....

MongoDB

I found a comparison of MongoDB and SQL Server recently, from a C# MVP and a person that works with...