Notes from the December 2018 SQLOrlando Meetup

Notes:
19 attendees out of 44 registeredSQLGrease sponsoredSolid hour of networking before the meeting started, managed to get everyone talking to...

Pens

On Monday I wrote about journaling and while any pen will do, I think having a pen dedicated (as it...

Running a custom SQL Server Docker Image in Amazon AWS

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Speaking at SQL Saturday #782 Slovenia

In coming weekend I will be speaking at SQL Saturday in Ljubljana, Slovenia. I’m extra happy because I do it...

SQL Server Find Unused Data Files

You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...

4 SQL Injection Techniques For Stealing Data

Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data.

However,...

Advent of Code 2018 – Day 5 (Alchemical Reduction)

A T-SQL approach to solving the 2018 "Advent of Code" programming challenge. This solution includes a recursive case-sensitive string replacement.
The post Advent of Code 2018 – Day 5 (Alchemical...

Advent of Code 2018 – Day 5 (Alchemical Reduction)

Advent of Code 2018 – Day 5
As I explained in a recent post, I’m participating in this year’s Advent of Code...

Azure Data Factory v2 and its available components in Data Flows

Many of you (including me) wonder about it. Namely: Is it possible to move my ETL process from SSIS to...

Enabling Query Store

Performance tuning in SQL Server is one of the main jobs a DBA has.  Starting with SQL Sever 2016 a...