SQL Server : Usage of OVER Clause

Over  clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...

SQLSaturday #160 – Get your SQL learn on in Kalamazoo

If you’re planning on being in the Kalamazoo, MI area this weekend, or just feel like taking a road trip,...

Why I dislike Third Party Database Monitoring Tools

I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...

SQL Server 2012 Diagnostic Information Queries (September 2012)

Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...

SQLSaturday #171, Pittsburgh

Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...

Attendant’s checklist to a SQL Saturday event

Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...

After Seven Years, Time for Something New

Earlier this month, I passed the seven year mark at Digineer.  It was a weird feeling, since the last time...

Book Review: SQL Server 2012 Integration Services Design Patterns

This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...

Certificates of Completion for SQL Seminars

Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...

Change file logical name for mirror database

Today I encountered a interesting issue when rename logical name for mirror database.

We have a database which has been setup...