Performance Tuning Steps a Query by looking an execution plan and effectiveness of the index creation Part-1

The index is very important and powerful object...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Renewed As A Microsoft Data Platform MVP

I am so excited and honored to have been awarded my second Data Platform MVP from Microsoft on Monday.  It’s been a crazy busy 18 months and the next...

Trailing Spaces in SQL Server

Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...

Behind the Scenes: How I Create Weekly Technical Videos

Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...

Behind the Scenes: How I Create Weekly Technical Videos

Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...

Cool Stuff in Snowflake – Part 9: ILIKE

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Finding Data...

Power BI Interview Questions – Volume 02 – Data Shaping

Welcome to a brand new series that I have started with with Erin Ostrowsky [Blog | Twitter] that will focus on interviewing for a Power

T-SQL Tuesday #116 Invitation – SQL on Linux

Ever since Microsoft said SQL would run on Linux, I was excited.  Finally, all the Linux administrators I had worked with could be quiet and the Oracle DBAs that...

T-SQL Tuesday #116 Invitation – SQL on Linux