MSDB Job History Duration Conversion

Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...

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

SQL Lunch: Change of Schedule

There has been a slight change to this weeks SQL Lunch meeting.  Our scheduled speaker cannot present this week, therefore...

SQL Saturday 49 Orlando - Delivery Mechanisms using SQL Server Reporting Services (mini)

It's official! I am presenting a mini session for SQL Saturday in Orlando. My topic and some details are below:

Delivery...

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

SSC Editorial – Great Service

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

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

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

CPU-Z Support For Sandy Bridge Processors

The CPUID website has a screenshot of CPU-Z 1.55.2, showing its support for the upcoming 32nm Sandy Bridge processor, which...