My Biggest Weakness
I took some time off in December and I'm finally getting around to catching up on RSS feeds. Turns out...
2009-12-31
1,515 reads
Blog Posts
Running a Small User Group - Remember, It's Not Exclusively Yours
I'm going to conclude this series on running a small user group with a topic that came up for discussion earlier...
2009-12-31
1,405 reads
Saying Goodbye To 2009
I'll close out 2009 with an update on the goals I set at the beginning of this year and things...
2009-12-31
1,395 reads
Script Individual User Rights in a Database with PowerShell
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,428 reads
Stored Procedures to Store and Get Database Users with All Permissions
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,780 reads
A Small Collection of I/O Specific DMV Queries
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...
2009-12-30
4,224 reads
Looking back at 2009 Goals
I set goals at the start of 2009 for the year. They were:
Continue with 400 posts a month Blog Daily...
2009-12-30
1,730 reads
Practice Your Restores
Steven Jones posted an excellent editorial today all about how your backups are only good if you know that you...
2009-12-30
1,322 reads
Running a Small User Group - The Tools
Because running a small user group is a labor of love, we look for time savings wherever we can to...
2009-12-30
1,830 reads
Wrapping Up Blogging for 2009
I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5...
2009-12-30
1,401 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