Checking Up on Vendors
Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.
2021-05-10
167 reads
Editorials
Non-Stop Learning
There was a recent discussion in the forums here at SQL Server Central regarding the difficulties presented by the constantly shifting technology landscape. The core question was, how on earth do you master stuff? Especially, how do you master things when they're both new and constantly changing? Honestly, you don't. I mean, you can, but […]
2021-05-08
254 reads
Getting Started Remotely
Today Steve wonders what advice you might give someone starting out their career in technology.
2021-05-07
103 reads
Cloud Database Growth
The use of cloud databases is growing, and Azure SQL Database is one of the more popular ones.
2021-05-05
280 reads
Holding Code in Your Head
Steve has a few thoughts on software development and coding today when working in teams and trying to keep the entire solution in your head.
2021-05-03
526 reads
No-code Software Engineering
The idea that software engineers might be better with no-code tools is a direction Steve thinks is misaligned with the problem. We should help developers learn to be better.
2021-05-01
179 reads
Documentation. The Under Recognised Skill
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
426 reads
Ransomware May Get Worse
Criminal groups using ransomware are working together, which is bad news for all organizations.
2021-04-29
243 reads
2021-04-28
107 reads
A Cloud Database for Statistics
A company decides to move to the cloud and outsource database administration.
2021-04-27
114 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...
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...
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