Speaking at SQLSaturday #14 in Pensacola on June 6, 2009
I'm driving over tonight to spend a long weekend in Pensacola (6-7 hour drive from Orlando) for their first SQLSaturday,...
2009-06-03
470 reads
Blog Posts
SQLServerCentral Article on Backup Monitoring and Reporting
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,328 reads
TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8
This is based on the original post in Franglais.
The goal of this post is to explain how to handle errors...
2009-06-03
2,485 reads
Balancing Priorities
This one isn't a technical post, but it's entirely appropriate to those of us in the IT field. Today was a...
2009-06-02
775 reads
Other Desktops
The USB not in Hyper-V thing is annoying. It actually made me stop and consider my alternatives for a desktop....
2009-06-02
773 reads
Notes on SQLSaturday #7
I flew up to Birmingham Friday for SQLSaturday #7 organized by John Baldwin from Steel City SQL and a lot...
2009-06-01
704 reads
Reminder - SQLSaturday #12 in Portland is June 6, 2009
Ken Starnes from the Portland group will be having their first event on June 6th. I like the way they've...
2009-06-01
294 reads
Security Basics: Understanding the Surface Area
When it comes to securing a system, it's important to understand how it might be attacked. That's what surface area...
2009-06-01
1,325 reads
SQL Server Encryption - Hashing Collisions
A hash is a computation that transforms one set of data into another (hopefully smaller) set of data. So a...
2009-06-01
5,241 reads
Upcoming Speaking Engagements
For those who are interested, I've got a couple of speaking engagements coming up in the next two weeks. I'll be speaking...
2009-06-01
614 reads
Blogs
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...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
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