Stairway to Always On Level 8: Segregate Mirror Traffic in AlwaysOn
this article details how to segregate the mirror traffic in an Always On group configuration
How to use Jupyter Notebook in VSCode
Learn how you can create and use a Jupyter Notebook in VS Code.
The Biggest Database Professional Challenges Today
What are the biggest challenges you face today? Steve asks the question and is hoping for a few answers from you.
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
Planes, Trains, and Automobiles
I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]
A Programmer's Attitude
The way we approach development can have a big impact on quality, as well as how smoothly our team works together.
Deleting Documents from a MongoDB Collection
So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collection. This article continues that discussion by explaining how to use MongoDB Shell to delete documents from a collection.
Cloud vs On-premises
Is the cloud better or worse for a workload? One company, BlueSky, has moved on-premises despite their rapidly growing workload.
Configure Microsoft Fabric Database Mirroring for Snowflake
In this tip, we explore how to configure mirroring for a Snowflake database to be available in Microsoft Fabric.
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