How Snowflake Creates and Detects Deadlocks
In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.
Validating Password Expiration
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
AI Thoughts on the Build Keynote
Today Steve has a few thoughts, and links, from the Build Keynote last week, which featured AI technology.
Microsoft Build Announcements for Data Professionals
This week was Microsoft Build. After four years, it was back in person in Seattle and available online. I didn't attend in person, but I did watch a number of sessions and also went through the Build 2023 Book of News. You can download the book if you want, as it provides a lengthy list […]
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Learn how to get started with Google Cloud MySQL and PostgreSQL databases by creating and configuring a database.
A First Look at PostgreSQL Monitoring in SQL Monitor
PostgreSQL monitoring is now supported by Redgate SQL Monitor to improve performance and reduce downtime.
Getting Started with Ensemble AI Models in SQL Server
In this article, we look at an ensemble AI model which can be considered a collection of two or more AI models that complement each other to arrive at an outcome for a set of historical data.
The Best Graph
Today Steve discusses visualizations and how we would think about the information a client gets from them.
Using Azure Data Studio to Deploy a SQL Server VM on Azure
This article looks at deploying SQL Server on an Azure VM from Azure Data Studio.
PASS Data Community Summit 2023 registrations are open!
In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers