Speaking at SQLBits 2014: PreCon on In-Memory OLTP and Security session
Sprecher auf der SQLBits 2014 zu In-Memory OLTP und Sicherheit
(DE)
Nachdem ich letztes Jahr das erste Mal als Teilnehmer auf...
2014-05-07
841 reads
Blog Posts
SQLSaturday #308 Houston, TX Saturday May 10th
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans...
2014-05-07
457 reads
What’s Happening at the PASS Business Analytics Conference?
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week...
2014-05-07
452 reads
Datatypes In Your Mind–Question Of The Day
My latest question Datatypes In Your Mind is live today and it’s generated quite the discussion. I wrote here about...
2014-05-06
470 reads
Filetable–Moving files programmatically
I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically?
It’s...
2014-05-06
1,823 reads
Using a Filtered Index to Enforce Filtered Uniqueness
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,158 reads
VMworld 2014 Session Voting Is Open!
I can’t believe it’s that time of year again. VMware has opened up the public voting for the VMworld 2014...
2014-05-06
733 reads
Applied SQL: Orphan a user, fix orphaned users (sp_FixOrphanedUsers)
Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when...
2014-05-05
928 reads
Cumulative Update – 1 for SQL Server 2014 RTM Rollback by Microsoft !
The 1st cumulative update release for SQL Server 2014 RTM was released by Microsoft.
But due to issues in setup Microsoft...
2014-05-05
970 reads
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2014-05-05
1,799 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers