Presenting Two Sessions at PASS Summit 2019
In just a few days, I’ll begin my annual journey to Seattle, Washington for the PASS 2019 Summit. This is one of my favorite conferences to attend. It is...
2019-10-30
23 reads
John Morehouse | Sqlrus.com
Improving TweetDeck with Better TweetDeck
If you are at involved with the #sqlfamily, you are bound to hear about the benefits of social media platforms such as Twitter. Twitter helps us to engage each...
2019-10-31 (first published: 2019-10-18)
355 reads
HammerDB for Azure SQL DB
Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to...
2019-10-03 (first published: 2019-09-27)
776 reads
Using Powershell for SQL Saturday Logos
Out of necessity are born the tools of laziness. This is a good thing. I have found that organizing and running a SQL Saturday event is a great way...
2019-09-23 (first published: 2019-09-13)
363 reads
Moving to Azure SQL Database Serverless
In a previous post, I discussed the public preview of Azure SQL Database Serverless. This is a newer product released from Microsoft for the Azure ecosystem. Moving to this...
2019-09-13 (first published: 2019-08-30)
965 reads
Finding the Best Azure Datacenter
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x...
2019-07-26
305 reads
Getting Your SQL Server Backup Footprint
Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using...
2019-07-15 (first published: 2019-06-28)
465 reads
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...
2019-03-22
458 reads
Checking Open Ports in Azure
Let’s be honest here, data security is really important to me. Some people probably think that I go to extremes...
2019-04-03 (first published: 2019-03-15)
758 reads
Secure Travel
Traveling in today’s age of technology is a lot easier than in the past. You can start your journey in...
2019-03-22 (first published: 2019-03-08)
1,995 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