2020-07-24
95 reads
The Lighter Side
2020-02-21
754 reads
Unreliable Data Sensors
Steve doesn't like the idea of cars using data from cameras to update a display instead of a mirror.
2019-09-30
198 reads
NASA officially orders its first segment of a lunar space station
"This time when we go to the Moon, we're actually ...
2019-05-23
2019-05-10
Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?
Brent Ozar asks if you can tell if each of these SQL Server bugs is brand-new, or almost 20 years old.
2019-05-03
Massachusetts offshore wind project gets green light at roughly 8.9 cents/kWh
The Vineyard Wind project will also commit $15 million to battery development.
2019-04-24
These are the best new vehicles of the 2019 New York International Auto Show
American auto shows are in decline, but we still found a few things to excite.
2019-04-22
The Porsche Panamera Turbo Sport Turismo—to hybrid or not to hybrid?
The Panamera Turbo comes in two flavors, and the more powerful one is a hybrid.
2019-04-11
T-SQL Tuesday #113: A year of marriage and boardgames
This week’s T-SQL Tuesday is about where you use databases in your personal life. And I have a database I don’t use any more that’s a little happy and...
2019-04-09
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