The Encryption Primer
SQL Server has a number of encryption features that allow you to better secure your data. This session will examine...
2012-03-28
1,441 reads
Blog Posts
TinyInt problem in SSAS
If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...
2012-03-28
1,609 reads
Transforming Event Log Data
Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...
2012-03-28 (first published: 2012-03-23)
6,049 reads
Unstructured Data in SQL Server
More and more of our data does not fit neatly into a structured, relational model of rows and columns of...
2012-03-28
1,742 reads
Why I am excited about SQL Server 2012 (Part 2)
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
696 reads
Exporting data to CSV file using SQLCMD/BCP
When it comes to exporting data there are different options available in SQL Server, such as SQL Server Integration Services,...
2012-03-27
4,812 reads
FILESTREAM and Snapshot Isolation Mode in SQL 2008
FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.
In SQL 2008 R2 however...
http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot...
2012-03-27 (first published: 2012-03-20)
2,178 reads
Inserting UniCode / Special characters in tables
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,818 reads
Powershell – Adding accounts to Local Security Policy
One of the challenges I’ve had over the years is figuring out a way to add the SQL Service accounts...
2012-03-27
10,527 reads
SQL in the City: Free SQL Server Event in London
Red Gate Software has announced “SQL in the City: London,” to be held on Friday, July 13, 2012, at the...
2012-03-27 (first published: 2012-03-19)
1,595 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