Upcoming Speaking Engagements
In the next few months I will be speaking at some awesome events around Europe.
SQLBits – April 5-8
SQLBits is THE SQL...
2017-02-27
605 reads
Gianluca Sartori
- Twitter: @spaghettidba
- Website: https://spaghettidba.com
Installing SQL Server 2016 Language Reference Help from disk
A couple of years ago I blogged about Installing the SQL Server 2014 Language Reference Help from disk.
With SQL Server 2016...
2016-10-27 (first published: 2016-10-17)
1,623 reads
ForumSurfer – a RSS reader for the SQL Server online community
Today I published the first release of ForumSurfer, a RSS reader designed explicitly to be a tool for the SQL...
2016-08-31
924 reads
SSMS is now High-DPI ready
One of the most popular posts on this bog describes how to enable bitmap scaling is SSMS on high DPI displays,...
2016-08-25 (first published: 2016-08-18)
4,042 reads
My Feedback on my PASS Abstracts Feedback
Brent Ozar recently published the feedback he got on his abstract submissions for PASS Summit 2016 and, as he often...
2016-06-30
882 reads
Upcoming Speaking Engagements
The next few months will be crazy for me. I will be travelling a lot around Europe, speaking about SQL Server topics.
Here is where...
2016-04-14
460 reads
Weird Things Happen with Windows Users
This will be no surprise to those who have been working with SQL Server for a long time, but it...
2016-03-18
731 reads
An annoying Bug in the Restore Dialog
Today, thanks to a customer, I discovered one of those annoying little things that can really drive you nuts.
Basically, they were...
2016-03-01 (first published: 2016-02-23)
2,309 reads
SSMS in High-DPI Displays: How to Stop the Madness
I spent the last few weeks travelling a lot compared to my usual routine and I got quickly fed up...
2015-10-14
41,218 reads
SQL Server Infernals – Circle 6: Environment Pollutors
Don’t tell me that you didn’t see it coming: at some point, Developers end up being put to hell by...
2015-07-31
1,234 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
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