SQL Server Performance Tuning Precon

On April 3rd, 2020 I’ll be presenting a Precon at SQL Saturday Croatia. In this session, you will learn about SQL Server 2008 R2 through SQL Server 2017 performance tuning and optimization. Industry Expert Denny Cherry will guide you through tools and best practices for tuning queries and improving performance within Microsoft SQL Server. This…

The post SQL Server Performance Tuning Precon appeared first on SQL Server with Mr. Denny.

My SQL Saturday Chicago Precon: Leveling Up Your Azure Skills

I’m doing another precon at SQL Saturday Chicago on March 20th, 2020. The event is at Benedictine University in Lisle, IL. This time we’re going to dive a little bit deeper into Azure. While last years precon focused on basic infrastructure skills in Azure, this time we’re going to focus a little deeper into the […]

EGPAF and DCAC HD

Highlighting the work that DCAC has been doing to help the Elizebeth Glaser Pediatric AIDS Foundation. This process requires importing data from over 5000 medical clinics in 19 countries. DCAC created a data warehouse for storing the data, BILM packages for import and maintenance of the import process, allowing for a PowerBI frontend in order

The post EGPAF and DCAC HD appeared first on DCAC Videos.

Understanding Azure Geo-Redundant Storage

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform.  In that session, I talked about Azure storage and the various redundancy options that are available to the storage, one of them being geo-redundant (GRS). Geo-redundant storage asynchronously replicates your data from one region to another […]