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

Wait Types and Latch Classes Library

Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...

Common uses of stored Procedure sp_MSforeachtable

We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.

sp_MSforeachtable can be used to loop through all...

Events I Wish PASS Organized

I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought...

Interview with Warwick Rudd

Part of traveling to various events and being a part of the SQL Community means one can meet some pretty...