VMWare vSphere database maintenance

I recently did a VMWare/SAN assessment for a client.  The expressed reason, or the reason relayed to me (not always...

Converting Dates to Integers

While working on a project recently, I came across a conversion that was trying to convert a date to an...

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

It’s Implied

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

MongoDB

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

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