SQLRally 2012-Friday
Started the day early, heading to the Convention Center to be at Starbucks at 6:45 for the networking event I...
2012-05-12
951 reads
Blog Posts
Denali — Day 11: SSMS enhancement
Denali — Day 11: SSMS enhancement
SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...
2012-05-11
669 reads
RedGate SQLSearch & SQL Treeo friendship
Hi,
one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL...
2012-05-11
1,186 reads
SQL Rally Wrap Up
Another SQL Rally has wrapped up in Dallas, TX and it was great event. My favorite part about these larger...
2012-05-11
1,479 reads
SQL Saturday #119 – One week to go
One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).
One week...
2012-05-11
727 reads
SQLRally 2012–Thursday
Arrived at the convention center about 7:30, managed to arrive at the right end of the convention center and walked...
2012-05-11
710 reads
Tech Days 2012 in Kosovo
Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in...
2012-05-11
1,852 reads
Which SELECT * Is Better?
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,411 reads
#SQLRally Women in Technology Panel of WIN AND AWESOMENESS
Best. Luncheon. EVAR.
I just finished up moderating this year’s Women in Technology panel here at SQLRally, and it was fantastic. ...
2012-05-10
706 reads
“Query cost (relative to the batch)” <> Query cost relative to batch
OK, so that is quite a contradictory title, but unfortunately it is true. There is a common misconception that the query with...
2012-05-10
2,340 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