Exploring Excel 2013 for BI Tip #6: GeoFlow–The Latest Excel Visualization
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-04-23 (first published: 2013-04-11)
3,323 reads
Blog Posts
Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
499 reads
Industry Expert Interview
I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so...
2013-04-23
1,003 reads
PowerSQL – Database Backup Report across all Servers – Centralized Approach
This topic provides and describes the quickest way to find when and what databases are being backed up recently.Backups are...
2013-04-23
1,058 reads
Review of The Way
The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...
2013-04-23
675 reads
Service Application Architecture
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Today I am here with...
2013-04-23
887 reads
snippet designate a certain time of the day in getdate()
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
354 reads
Speaking at the 2013 Carolina Code Camp
On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...
2013-04-23
881 reads
Creating Dimension Table ==> Time (Example)
Script for Dimension table for Time.
Here Date_ID is the primary key which can be used as the foreign key...
2013-04-22
911 reads
Cumulative Update – 7 for SQL Server 2012 RTM Is Now Available !
The 7th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 7 contains all the hotfixes...
2013-04-22
861 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...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
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