Justin Manning MSFT PFE

The life of a SQL PFE

Upgrade a clustered Microsoft SQL Server 2014 to SQL Server 2017 (step by step)

Technical Details This document will contain step by step guides on to follow to achieve the objectives listed below. The objective of this guide is to minimize downtime during the upgrade procedure and ensure a successful upgrade of Microsoft SQL Server. Upgrade Microsoft SQL Server 2014 to SQL Server 2017 The objective of this step… Read more

SQL Server Performance Testing with Database Experimentation Assistant

Introduction This quick post is to assist users in performing performance tests on various environments and generate analytics from the results. The Database Experimentation Assistant makes use of SQL Server Distributed Replay Controller and Clients. Tool: Database Experimentation Assistant (DEA) Virtual Environment: SQL Server 2017 CU6 (DEA has a known issue in replay if the… Read more

Azure Backups and Site Recovery – Encrypted SQL Backups

    Introduction   This document is intended to assist the user in configuring Azure Recovery Services for on premise backups of encrypted SQL Server Backups. The goal of this document is to demonstrate the capability of backing up encrypted Database backups, where the encryption key stays in possession with the customer (onsite) and is… Read more

Setting up Central Management Server in SQL Server

Hey SQL Fans, Today I thought I would write a quick post about Central Management Server for SQL Server. I have been to so many customers who are not making use of this amazng a free feature that ships with SQL Server. I always ask the resident DBA team at a customer,  how they are managing… Read more

SQL Server In-Memory

Hi to all of you SQL Server fans, There has been a lot of interest from customers moving to SQL Server 2014, specifically around the use of SQL Server in-memory optimizations as well as identifying possible candidates that could benefit from this technology. I thought I would write a quick post to cover the implementation of… Read more