Weekly reading #24

Hello #SQLFamily! We are packing for the longest trip this year. Next week we will start in Shanghai, then will move to Bangalore for #DPS10 and the last week...

5 Things You Need To Know When Reading SQL Server Execution Plans

Watch this week’s episode on YouTube. 5 Things You Need To Know When Reading SQL Server Execution Plans In the first part of this series I explained what an execution...

5 Things You Need To Know When Reading SQL Server Execution Plans

Watch this week's video on YouTube

Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans

In the...

5 Things You Need To Know When Reading SQL Server Execution Plans

Watch this week's video on YouTube

Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans

In the...

Azure SQL Database Clustered Columnstore Index

You can read about columnstore indexes here (https://azure.microsoft.com/en-gb/blog/transforming-your-data-in-azure-sql-database-to-columnstore-format/). I won’t rehash the material but high level, these index types are optimized for analytical queries and high compression of data...

spark-dotnet how to manually break a file into rows and columns

I found this question on stack overflow that went something like this:
“I have a file that includes line endings in the wrong place and I need to parse the...

spark-dotnet how to manually break a file into rows and columns

I found this question on stack overflow that went something like this:
“I have a file that includes line endings in the wrong place and I need to parse the...

A Day in the Life (4/?) - August 2, 2019

This is my fourth installment in a series responding to Steve Jones’s (blog | twitter) #SQLCareer challenge. I jotted down most of what I did through the day, filling...

Feature Restrictions in SQL Server 2019 are Worse Than Useless: a False Sense of Security And Wasted Opportunity

A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...

Running Containers In a Virtual Machine

The more you work with containers, the more you just want to work with containers. However, there are still reasons to have a virtual machine for some types of...