SQLPASS SUMMIT 2016 Discount Code
SQLPASS SUMMIT 2016 is around, only few months left for this super event. Probably you all would have heard about...
2016-05-14
1,463 reads
Blog Posts
Hello SQLSaturday Houston!
I've been looking forward to speaking at SQLSaturday Houston again all year!
Big thanks to the organizing crew behind this great...
2016-05-13
478 reads
SQL Server – Row Level Security in SQL 2016 – Part 2
Hi friends, in my previous post we have learnt how to implement Row Level Security feature in our database. You...
2016-05-13 (first published: 2016-05-05)
1,481 reads
The New Global Dashboard
Redgate recently released SQL Monitor 5.2, which is the latest upgrade to our monitoring/alerting/troubleshooting product for DBAs. This was the...
2016-05-13
694 reads
Where do you put your business logic? In stored procedures?
There seems to be two trains of thought and I think this is mainly down to who and where your...
2016-05-13 (first published: 2016-05-05)
4,341 reads
Big Data architectures
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...
2016-05-12 (first published: 2016-04-29)
3,119 reads
Find Unused Database Objects in SQL Server
Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...
2016-05-12
569 reads
PowerShell – SQL Database Refresh -Restore – Multiple Databases
.SYNOPSIS
The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.
.DESCRIPTION
The...
2016-05-12
1,758 reads
See you Saturday in Houston!
Here’s your friendly neighborhood reminder to get free learnin’ at SQL Saturday Houston this weekend, where we’ll have the MinionWare booth, and sessions...
2016-05-12
511 reads
SQL Nexus
I was lucky enough to be accepted to speak at SQL Nexus in Copenhagen and I attended the event a...
2016-05-12
652 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