Catching Minor Issues
Can you catch minor code changes that might cause issues? Steve advocates for more testing to ensure you can.
2020-12-03
112 reads
Editorials
Completely Encrypted Data
Do we care or worry if our databases need to handle encrypted data? Steve has a few thoughts about why we may or may not be concerned.
2020-12-02
126 reads
Increasing the Accuracy of Data We Rely On
GPS data is used by many applications. Steve notes that managing data like this might be hard inside organizations.
2020-12-01
68 reads
Delivering Patches Quickly
Tesla updates their cars over the air while many other companies require you to move slow and visit a dealer. Steve thinks we can be more like Tesla as developers if we move to DevOps.
2020-11-30
83 reads
Bad career advice from a 14 year old
I was having a conversation with my 14-year-old grandson Thomas the other day. He was telling me that is signed up to take a programming class in school next term and sees a future career in technology. He loves playing video games, so maybe developing them would be a good choice. He also was thinking […]
2020-11-28
189 reads
Black Friday Wishes
Today Steve asks if there are things you might wish your employer would do for you this holiday season.
2020-11-27
106 reads
2020-11-26
61 reads
2020-11-25
71 reads
Privacy Problems in Apps
Lots of contact tracing apps are out there. Do you know which ones collect which types of data and what they do with it?
2020-11-24
161 reads
2020-11-23
117 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