Thank God I Chose SQL Server part II: How to Improperly Install Oracle 11gR2
As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming...
2012-05-01
3,545 reads
Blog Posts
The 2012 Powershell Scripting Game(shows) in review
Over the past few weeks, those around me know that I’ve been talking a lot about Powershell, how much it...
2012-05-01
1,192 reads
When Will You Upgrade to SQL Server 2012?
This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...
2012-05-01
1,241 reads
Blogging Tools: BlogDesk Review
As a blogger, you have several options available to you when it comes to writing posts. You can write them...
2012-04-30
2,213 reads
Changing DB_CHAIN Can Clear the Plan Cache
If you make changes to the settings of a database, it can cause the procedure cache to be cleared. Microsoft...
2012-04-30
1,763 reads
Generate restore script automatically by backup history table
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
6,975 reads
Less Energy through Better Design
When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements...
2012-04-30
1,997 reads
Locked out of SQL Server.
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...
2012-04-30
2,638 reads
SQL Saturday #131 Recap
This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ
It’s April,...
2012-04-30
1,920 reads
SQL Server – Four-part object names
Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion...
2012-04-30
3,137 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