A Month of PowerShell – Day 24 (JobServer: Jobs)
Welcome to Day 24 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-24
2,188 reads
Blog Posts
PASS Data Arch VC presents: Neil Hambly’s Think You Have The Right Data-Type?
Please join this Thursday Feb 24th 2013 at noon central for Confio SQL Server expert Neil Hambly talking SQL Server...
2013-02-24
733 reads
SQL BLOG: Calculating number of week along the days completed in that week for a given input date
Below code will display the week started along with the number of days completed in that week. For deriving this...
2013-02-24
560 reads
SQL BLOG: Playing with Date Time
Below code returns remaining days in the month based on the input date. We can have this inside a function...
2013-02-24
426 reads
A Month of PowerShell – Day 23 (JobServer: Alerts)
Welcome to Day 23 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-23
2,121 reads
Partitioning Relational Data – (Part – 3)
This is the third part of the three part article series on partitioning relational data.
In the first part of this...
2013-02-23
571 reads
SQL Server Encryption
Today, I am very happy because my first article (SQL Server Encryption) was published in SQL Server Pro. In this...
2013-02-23
1,086 reads
The pros and cons of virtualizing SQL Server environments
Virtualization is a hot trend in the computing world, offering businesses substantial cost and performance benefits that include server consolidation,...
2013-02-23
1,601 reads
XML Support and SQL Server (Part 4)
Checkout the fourth part of my XML support and SQL Server article series here.
In this part, I talked about XML...
2013-02-23
843 reads
Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies
Welcome to day 28 of my series 31 Days of Disaster Recovery. Today I want to talk about recovering SQL...
2013-02-22 (first published: 2013-02-14)
2,883 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