SQLRally at Starbucks Networking Event
Craig Purnell and I are hosting an informal networking event at SQLRally this year on Friday May 11th from 7-8:30...
2012-05-04 (first published: 2012-04-12)
1,720 reads
Blog Posts
Changing Priorities
If you’ve been following this blog for a while, you have probably noticed that the content here has been a...
2012-05-03
712 reads
Content is King: Great (paraphrased) advice from TheOatmeal.com
TheOatmeal.com has provided the absolute best counsel regarding creativity vs marketing. The comic I’m talking about is entitled “How to get...
2012-05-03
842 reads
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
I know this should be first or second blog post when...
2012-05-03
880 reads
Eight Words
I remember a lot of things about that day. It was July in Texas, which is to say, it was...
2012-05-03 (first published: 2012-05-02)
2,557 reads
OFFSET and FETCH Query Options in SQL Server 2012
If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly...
2012-05-03
540 reads
OFFSET and FETCH Query Options in SQL Server 2012
If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have...
2012-05-03
100 reads
On the road less traveled: a DBA Roadmap review
The story of why I came up with this blog is no secret to the few readers I have here. In...
2012-05-03
1,368 reads
Patience
Update: This is confirmed by Snopes.
A NYC Taxi driver wrote:
I arrived at the address and honked the horn. After waiting...
2012-05-03
2,910 reads
Slowing Changing Dimension (SCD) demystified – Part 1
SCD is a basically a concept that explains how historical data/values are stored within a data in a database.
There are...
2012-05-03
692 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