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

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

Trace Flags in Azure SQL Database

One of the ways that you take more direct control over your SQL Server instances is through the use 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...

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

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

Backup Deployed Sessions

There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth...

The powerpoint for my SQL Server Security Basics session

Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned...

Non-Clustered Index

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...