What's a forgivable mistake?
Today Steve wonders if your company is understanding of your human frailty.
2019-12-06
263 reads
Editorials
Expect the Unexpected with DiRT
Disaster recovery is no joke at Google, where they really test their systems, people, and processes.
2019-12-05
226 reads
Proactive Performance Tuning
Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.
2019-12-04
383 reads
HSA for Training
Is there a good way to ensure employees get trained? Steve has a few thoughts today on an idea that could help.
2019-12-03
182 reads
2019-12-02
354 reads
How SQL Server Can Just Go Faster
It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]
2019-11-30
592 reads
2019-11-29
349 reads
2019-11-28
107 reads
How Do You Act When You Need to Learn New Technology?
Today we have a guest editorial from Ben Kubicek as Steve is away from the office. It is hard to be humble, but it is needs to learn something new.
2019-11-27 (first published: 2016-11-07)
477 reads
2019-11-26
376 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
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...
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