Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries – Part 3

Best way to tune production server is to find out what are the queries executed in a particular duration and...

End-User Microsoft BI Tools – Clearing up the confusion

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there...

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

How to setup a task to delete the old backup files or log files from the server ?

Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...

I’m Going to SQL RALLY!

Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on...

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

Learn Mirroring with me at SQLRally

I just found out that I will be speaking at SQLRally Dallas in May.  I submitted 3 sessions.  As an...

New Article: Exploiting SQL Server via CONTROL SERVER permissions

I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...

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