Networking - Part 3
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've...
2009-01-20
1,137 reads
Blog Posts
Kindle Review – How I Read
In the last 4 months of having the Kindle, I’ve gone through a few different ways of reading on it...
2009-01-19
960 reads
We Are Microsoft charity challenge
I got the opportunity to participate in the We Are Microsoft Charity Challenge (under the umbrella of GiveCamp) in Dallas...
2009-01-19
696 reads
Book Reviews - Worthwhile?
Lately I've been thinking (again) about books and book reviews, mostly because I'm looking to see if it makes sense...
2009-01-18
914 reads
The Hassles of Travel - Part 2
I didn't want to go on this trip, but I agreed to do it. Now I regret it.
My flight to...
2009-01-18
778 reads
It's Minus Twenty-Five Outside and I'm Writing about Transaction Log Files
(1linerForward) I originally wrote this in French while working at LaCaisse.com - http://dbhive.blogspot.com/2008/07/fichiers-journaux-de-transactions.html
Why do you care, as a DBA, or a Developer...
2009-01-17
7,584 reads
List Objects in a Filegroup in SQL Server 2005
I have tried hard to google a SQL query to find what objects exist in a specific filegroup, but in...
2009-01-16
12,543 reads
Loading Up For Travel
I fly to the UK tomorrow, not really my favorite thing to do, so I’m trying to ensure I can...
2009-01-16
786 reads
Comments on Pro Full-Text Search in SQL 2008 by Michael Coles
Apress sent me a free review copy, so I took a quick look through it at lunch. I've used full...
2009-01-15
604 reads
devLINK Technical Conference to Be Held in Nashville, TN in August
The 2009 devLINK Technical Conference will be held in Nashville, TN, August 13-15, 2009. This three-day conference provides technical content...
2009-01-15
474 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