Source control isn't just a backup
In the second part of this series on getting more agile and bringing our Sql Server development practices up to...
2015-02-19
433 reads
Blog Posts
Speaking at SQLSaturday Pordenone
Next week, on Saturday 28, make sure you don’t miss SQLSaturday Pordenone!
Pordenone is the place where the Italian adventure with SQLSaturday...
2015-02-19
644 reads
SQL Cruise Caribbean 2015 Wrap Up
I just returned home from this year’s SQL Cruise in the Caribbean. WOW!
This trip was our first SQL Cruise, but it...
2015-02-19
803 reads
T-SQL Tuesday #63 – Security
It’s T-SQL Tuesday time again and this month we look at security. Kenneth Fisher has chosen this as his topic...
2015-02-19 (first published: 2015-02-10)
6,999 reads
TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role
So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...
2015-02-19 (first published: 2015-02-10)
7,222 reads
Clustered Columnstore Indexes – part 48 (“Improving Dictionary Pressure”)
Continuation from the previous 47 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to one of the most complex problems in...
2015-02-18
1,890 reads
Free Video for Accidental DBA’s
Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills...
2015-02-18
1,844 reads
Parsing SQL Saturday Data – Looping Through And Loading All XML Files
After my last post on parsing the XML, I decided to continue forward and get ready to put the data...
2015-02-18
890 reads
Power BI Made Simple
In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to...
2015-02-18
1,110 reads
Test your UPDATEs and DELETEs before you run them
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...
2015-02-18
2,226 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