The Final Word on SQL Server 2005 SP2?
Bob Ward posted on the PSS SQL Server Engineers blog a fairly long post on SP2 and the hotfixes thereafter:...
2007-04-11
1,435 reads
Blog Posts
Thoughts from Never Eat Alone
Watching a Chefograpy on Giada De Laurentiis, I learned that she was considered very much an introvert and had a...
2007-04-10
1,447 reads
Help Johnny, Help Kids
I had heard of Johnny Long before I attended his briefing at Black Hat 2004. Well known for his research...
2007-04-09
1,512 reads
Microsoft CRM Security Internals
On the Microsoft Dynamics CRM Team Blog, Jay Grewal has posted information about the CRM Security Model Internals.
CRM is...
2007-04-09
1,639 reads
More information about SQL Server 2005 and SP2
SQL Server MVP Aaron Bertrand has posted an update (April 6, 2007) on the version numbers of post SP2 hotfixes....
2007-04-09
1,374 reads
How to pick a combination lock in 30 seconds
This is just frightening. A piece of a beer can, a pair of pliers, and the combo lock pops open.
...
2007-04-07
1,501 reads
QA/QC
I wrote a small commentary on quality control today and I'm surprised it didn't get more reaction.
I'm not a great...
2007-04-06
1,467 reads
SQL Server Samples on CodePlex
Like many other SQL Server focus area, SQL Server Samples has its own blog. A recent post there indicates that...
2007-04-06
1,417 reads
The Data Warehouse Lifecycle Toolkit
On a recommendation, I picked up this book by Ralph Kimball. I remember it coming out years ago and I...
2007-04-06
1,418 reads
Thoughts from The Cuckoo's Egg
The Cuckoo's Egg by Clifford Stoll has been around for a while, having been published in 1989. It details how...
2007-04-06
1,655 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