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

Getting your Cloud on

One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...

Power BI and the Bing Maps API

This week I was working on a project for a school up North. This customer wanted to use Power BI...

Virtual SQL Servers, Actual Performance – PASS Virtualization VC Presentation

Tomorrow I’ll be presenting a new session for the PASSVirtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at...