The Armor of Transparency

Yesterday I blogged about hosting a daily status meetings and some of the tricks I use to make it work....

Passing BIGINT data to SSRS Sub Report

Few days back one of my team mate complained to me that one particular sub report is failing randomly with
Error:...

I’m speaking at SQL Rally 2012

I’ve learned that my session entitled “Introduction to Data Quality Services” has been selected as one of the community choice...

SSRS 2008 Error – The report definition is not valid

Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and...

Presenting Two Sessions at SQLRally

I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....

A Script A Day - Day 22 - Database Backup

Today’s script follows on from Day 16’s script which was about database restores.  In a backwards way the script is...

A Script A Day - Day 21 - The HAVING Clause

Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...

Trello: An agile style kan-ban web app that really works

I am no different to many others where I am being asked to work on various projects concurrently and expected...

High Availability 9's

This is very important to understand what is high availability 9's, This is a measurement of high availability  where you can tell...

Detect Worst Performing SQL Queries - Part 3