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
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers