My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2019-03-11
365 reads
Missing Indexes in the Query Store
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place...
2019-03-11
26 reads
Missing Indexes in the Query Store
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing...
2019-03-22 (first published: 2019-03-11)
2,389 reads
Data Warehouse Design and Power BI at SQL Saturday Tampa 2019
Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...
2019-03-11
593 reads
One week blogging hiatus
I’m taking a brief break from daily blogging, even though it has been a ton of fun.
No excuses
I hope...
2019-03-11
231 reads
SQL Server Availability Group Failovers in Kubernetes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-03-25 (first published: 2019-03-11)
542 reads
Last Week Reading (2019-03-10)
Databricks-Connect – FINALLY! Do write your code in VS Code and run it remotely on Azure Databricks cluster. Automatically validate E-mail...
2019-03-11
302 reads
2019-03-11
22 reads
Debugging Type Binding in PowerShell
Some effort I spent in researching Type Binding in Stack Overflow to help answer a question by Chris Oldwood helped me solidify my understanding of the best way to...
2019-03-11
21 reads
Communication in Azure: using Data Factory to send messages to Azure Service Bus
(2019-Mar-10) A conversation between two or more people involves continuous efforts to listen and reflect on what other people have to...
2019-03-25 (first published: 2019-03-10)
11,048 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers