PowerShell – SQL Database Refresh -Restore – Multiple Databases

.SYNOPSIS
The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.
.DESCRIPTION
The...

Find Unused Database Objects in SQL Server

Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...

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