Lone DBA Podcast
I recently had the pleasure of being a guest on a Podcast episode with the SQL Data Partners Carlos Chacon...
2017-04-03
351 reads
Blog Posts
Monday Coffee 2017-04-03
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
269 reads
Monday Coffee 2017-04-03
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
137 reads
Olcot and Arratoon Ancestry
I have spent a fair amount of time researching the Olcot and Arratoon ancestry and I am very interested in the family tree, especially pre 1900 in India. If...
2017-04-03
10 reads
Preconference Session at SQL Nexus – SQL Server Virtualization
If you are attending this year’s SQL Nexus conference in Copenhagen, Denmark, from May 1st to 3rd this year, I...
2017-04-03
415 reads
Sampling Distribution and Central Limit Theorem
In this post am going to explain (in highly simplified terms) two very important statistical concepts – the sampling distribution and central...
2017-04-03
696 reads
Test the SQL Server database collation with PowerShell and dbatools
If your server collation is different to your database collation then you may find that you get an error similar...
2017-04-03
658 reads
Tuga IT 2017 Tickets are on sale
I am glad to announce thatTuga IT 2017 Tickets are finally on sale!
Wait a second, you might think – on sale?...
2017-04-03
339 reads
Understanding Keys and Certificates with Always Encrypted
This post attempts to explain in simple terms what keys are involved in Always Encrypted, how they get used, and the implications of those facts.
2017-04-03
9 reads
What Is SQL Saturday?
I was recently approached and asked, “What is SQL Saturday? I actually get asked that question more times than not...
2017-04-03
386 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...
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