Word-wrap in SQL Server Management Studio

I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...

Azure Speed Testing

Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...

Possible PARAMETER SNIFFING Scenario in SQL

When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to...

Power BI Is Finally in the Azure Trust Center

With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review...

PowerShell – Backup Specific group of SQL Databases

<#

.SYNOPSIS
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh...

SQL Server – Cleaning Procedure Cache for a particular database

HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...

A Day In The Life of a SQLBits Volunteer

So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...

Azure DocumentDB – Preparing, Loading and Querying Data

[read this post on Mr. Fox SQL blog] Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a variety of application purposes. For those SQL DBA’s...

Columnstore Index Enhancements in SQL Server 2016

One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they...

Data Compression in SQL Server – Pros and Cons

SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...