Backup Deployed Sessions

Having just completed several segments on the metadata for deployed sessions, it is time to bring all of that information together and see how it can be used -...

Deployed Session Settings

You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

on 10th oct 01.30 pm pst, i will be speaking on “detect worst performing sql queries during peak hour” @ sqlsaturday,...

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

Implementation of Data Compression – SQL Server

Data Compression
Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of...

SQL Source Control and Git–Getting Started

It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS...

SSMS Connection Information

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...