Capture the Flag – The Trace Flag

Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to...

Live Query Stats of Running Queries

Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...

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)

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

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