Home Power – Generators
A slightly off topic post, but since I was asked recently, I thought I’d take my reply, make a post...
2013-02-22 (first published: 2013-02-14)
2,675 reads
Blog Posts
Microsoft Azure is faster than Amazon
I just read a great article on NetworkWorld that demonstrates that Microsoft’s Azure outperforms most tests against Amazon’s AWS. That’s great...
2013-02-22
729 reads
Reblog: February 15 to February 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
914 reads
Search all running SQL Server instances over LAN
Sometimes you need to know how many and what instances of
SQL Server running in your organization over Network. You can...
2013-02-22
2,366 reads
Speaking – Slide Design
I’m not sure I love this advice on slide design, but some of it makes sense. Much too often I...
2013-02-22
804 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 8: Sequence Clustering
by Steve Bolton
In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we...
2013-02-21
2,013 reads
Configure MOSS without GUI || Database name without additional GUID || PSCONFIG command to configure MOSS
Friends, do every time we need the GUI ? or we feel the need of Customized things some times in life....
2013-02-21
1,126 reads
Get Perfmon data with Powershell
Sometimes you just want to have a look at the system performance, or you feel tired with log on the server, open...
2013-02-21
2,134 reads
I’m presenting at the PASS SQL Saturday in Chicago
I have been selected to present at the SQL Saturday in Chicago on April 13th. This works out nicely as the...
2013-02-21
958 reads
Presentation Materials “What Are You Waiting For?”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of...
2013-02-21
563 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