MDX Utility Belt of Calculations Part 2
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility...
2009-12-01
1,770 reads
Blog Posts
Upgrading to Windows 7
I’ve been using Win 7 on my dev machine for a few months now, and finally decided over the Thanksgiving...
2009-12-01
496 reads
Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008
One quick and dirty tool that I like to use to monitor I/O performance at the file level is Resource...
2009-12-01
2,298 reads
Using Social Media to become more social
I saw this report that a good percentage of online social media users (27%) find that their offline relationships benefit...
2009-12-01
1,346 reads
Are You a Giver or a Taker?
I have been involved in the SQL Server community since 2000, and during the past nine years I have seen...
2009-11-30
1,450 reads
Columbia Code Camp!
The Midlands of South Carolina will be hosting a Code Camp on January 30, 2009. You can register as an...
2009-11-30
1,698 reads
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features.One key feature was the inclusion of the Gauge Controls.I was recently...
2009-11-30
1,730 reads
Maintaining Security and Performance Using Stored Procedures Part II – Signing
Well, it has been a couple of weeks since my last blog post and over a month since Maintaining Security...
2009-11-30
1,648 reads
More News About AMD’s 2010/2011 Server Roadmap
AnandTech IT has an interesting post up that looks at the roadmap for AMD in the server arena for 2010/2011....
2009-11-30
1,699 reads
My first useful powershell script – capturing performance counters
After playing around with powershell a bit, I managed to do something quite useful. There are a multitude of ways...
2009-11-30
1,765 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...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
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