Upcoming SQL Saturdays - June 2016

I am speaking at two different SQL Saturdays in June!
--

First up on June 4th is SQL Saturday #517 Philadelphia (#SQLSAT517)...

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

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

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

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

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

Minimum Memory Grant Query Hint

This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog...

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

Power BI Takeover–Webinar Recording and Q&A

Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm.  Instead of our traditional 1...

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