Starting Conversations - Part 6
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker...
2009-06-09
334 reads
Blog Posts
Transparent Data Encryption - Encrypting the Log
One of the interesting things about Transparent Data Encryption is that it tries to ensure that your data, whenever it...
2009-06-09
468 reads
Call for Speakers for SQLSaturday #16 in Miramar, FL on August 8, 2009
Scott Klein still needs a few more speakers for the first ever SQLSaturday in Miramar (basically Miami). So far Jeff...
2009-06-08
350 reads
Gathering in the Corner - SQLSaturday #14
I'm done with SQLSaturday #14, actually stuck in Pensacola for an extra night, but that's another story.
It was a great...
2009-06-08
593 reads
Handling Errors in PowerShell
Scripting tasks in PowerShell is a fairly easy way to automate tasks, but you have to know when you get...
2009-06-08
954 reads
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week!
Some quick observations:
The build quality is outstanding. Nothing cheap at all...
2009-06-08
579 reads
Jacksonville Code Camp Scheduled for August 29, 2009
My friend Bayer White is the event lead for the fifth annual Jacksonville Code Camp being held on August 29th...
2009-06-08
293 reads
Notes on SQLSaturday #14 in Pensacola
I'm just back from the event and it turned out very well, just over 170 attendees attending their choice of...
2009-06-08
900 reads
Speaker Eval Results from SQLSaturday #14
Just received these from Karla:
Expectations: 0 Did not Meet, 4 met, 6 Exceeded.
Overall quality: Zero 1's, Zero 2's, Zero...
2009-06-08
293 reads
SQL Saturday Pensacola pics
The SQL Saturday Pensacola pics are up! Visit the SQL Saturday Facebook group at http://www.facebook.com/home.php#/group.php?gid=58052797867&ref=ts
and tag or leave your comments.
2009-06-08
834 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