In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography are susceptible to Shor's Algorithm in quantum cryptography. Cracking those algorithms with classical computing is...
2026-04-08 (first published: 2026-03-27)
187 reads
But as I've matured over the years, I came to realize that I needed to ask a critical question, "Who am I doing this for?" When I agree to...
2026-04-01 (first published: 2026-03-30)
21 reads
I am guilty as charged. The quote was in reference to how people argue about details in fitness or finances that are more detailed than is useful to them....
2026-03-30 (first published: 2026-03-13)
185 reads
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released patches for SQL Server to address privilege escalation vulnerabilities in supported versions. Time to patch!
2026-03-25 (first published: 2026-03-12)
556 reads
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class on April 13-16, 2026, in Columbia, SC.
2026-03-18
20 reads
If your organization is spending money, then meaningful results are a must. Pen testing isn't supposed to be a pat on the back. It's supposed to be a tool...
2026-03-17
7 reads
If you want to learn better, pause more in your learning to intentionally review.
2026-01-26 (first published: 2026-01-13)
222 reads
2026-01-19 (first published: 2026-01-08)
226 reads
2026-01-14 (first published: 2026-01-05)
448 reads
Following the advice in Smart Brevity improves communication.
2026-01-06
16 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
We need to replace our Windows server running SQL 2017. Any reason not to...
Comments posted to this topic are about the item 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