Goals for 2023
This is the goal setting post for 2023. The previous ones were: 2022 2021 2020 2019 2018 As with previous years, I’ll break these into three categories: career, personal,...
2023-01-06
19 reads
Blog Posts
Outlining Goals in 2023
Last year I set a bunch of goals, and I thought I did pretty good working on them. Not amazing, but pretty good. This year, I want to attack...
2023-01-06
17 reads
Setting up TDE
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In the previous posts we looked at what TDE is and how it...
2023-01-06
83 reads
Solar Projection v Estimates
We got a solar system in 2022 to try and fix some of our power costs and hedge against the future. We were fairly confident it would work well,...
2023-01-06 (first published: 2022-12-28)
254 reads
SQLBits 2023
Super excited that I was selected to speak at SQLBits 2023. The conference is taking place 14-18 March 2023 in Wales. I have never been to Wales and am...
2023-01-06 (first published: 2022-12-23)
240 reads
Daily Coping 5 Jan 2023
Today’s coping tip is to set aside a regular time for the next month for an activity you love . This is a big month for me, with coaching...
2023-01-05
19 reads
Daily Coping 4 Jan 2023
Today’s coping tip is to share something helpful with a friend that you learned recently. I share a lot with my wife and kids. They are a big part...
2023-01-04
8 reads
Monitoring with the Pure Storage FlashArray OpenMetrics Exporter
This post introduces you to the Pure Storage FlashArray OpenMetrics Exporter. It shows you how to get started quickly using Docker Compose so you can monitor your Pure Storage...
2023-01-04 (first published: 2022-12-20)
329 reads
Understanding Keys and Certificates with TDE
When you first look at the encryption hierarchy for TDE in SQL Server it can be a bit daunting. There seem to be a lot of objects involved and...
2023-01-04 (first published: 2022-12-21)
336 reads
Daily Coping 3 Jan 2023
Today’s coping tip is to use one of your strengths in a new or creative way. I have a lot of strengths. They’ve helped me to be successful. This...
2023-01-03
14 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...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
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