Kindle - On Hold
Just as I was debating whether to take advantage of Amazon's $100 savings offer on the Kindle (with a new...
2008-08-25
1,943 reads
Blog Posts
Tool Review: Quicken
I've used Quicken for a long time now and it's the center of how I manage finances at home. There...
2008-08-25
1,367 reads
Assessing DB Changes
One of the things I teach in our admin course is that it's not enough to just be the gatekeeper/central...
2008-08-24
1,443 reads
Deleting Duplicates without a unique key
The following was sent to me by my friend and colleague Dave Miller:
Dave's Email:
Wanted to pass along something I hadn't...
2008-08-21
1,616 reads
Kindle - On the clock
In a week and a half, I start on the first of my four trips this year for work, and...
2008-08-21
1,459 reads
Taking Care of Employees - Storms
As I write this a tropical storm is passing over Orlando and has turned out to be milder than expected...
2008-08-21
1,401 reads
[Off Topic] The Big Apple
I got my first opportunity to visit New York City last week. I was actually sitting in on a training...
2008-08-20
1,553 reads
SQLSaturday #8 in Orlando - Update (Aug 21)
Registration has been open for only a few weeks and we've got 110 registered so far, a nice start! We...
2008-08-20
1,455 reads
Troubleshooting High Connections & What's The Application Name?
I was visiting with a client recently when they asked me to come take a look at an incident in...
2008-08-20
1,368 reads
Notes on My Visit to the St Louis SQL Group
Actually it was subset of the group, but Kathi & Julie from the St Louis SQL Server User Group did a...
2008-08-19
1,413 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