Cloud Backup - Directly to Azure

Backup is one of the major task for DBAs, it has many different options and ways for each companies to...

Quick Encryption with Always Encrypted

What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted?...

MongoDB – Local and Remote Connections in Mongo Shell

To Install and Getting started with MongoDB refer the below links
Getting Started with MongoDBInstall MongoDB 3.2 on WindowsInstallation Guide
How to...

SSMS Preview Plan Comparison Tool and Plan Viewer Optimizations

With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...

Ben Miller Speaking to oPASS & MagicPASS on April 19, 2016

Register to attend this joint chapter meeting at https://www.eventbrite.com/e/opassmagicpass-joint-april-meeting-w-ben-miller-tickets-24457339561.
OPASS and MagicPASS are proud to present a special joint meeting with Ben...

Name the schema when you create an object (or else)

This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...

SSIS Trick: Adding Multiple Packages to a Project

A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...

TSQL– Search for Strings in Object Definitions

I have been  working nn an environment  that had multiple copies of a database on the same SQL server instance....

Tools of the trade

I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools...

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour