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,625 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,043 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
883 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,310 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,243 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
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KAS GAJAH MADA TLP/WA 081717899866
Jl. Gajah Mada No.108, Delod Peken, Kec. Tabanan, Kabupaten Tabanan, Bali 82113
BCA KCP SANUR RAYA TLP/WA 081717899866
Jl. Raya Jl. Bypass Ngurah Rai No.287, Sanur, Denpasar, Kota Denpasar, Bali 80227
BCA KCP KAS BATURITI TLP/WA 081717899866
Baturiti, Kec. Baturiti, Kabupaten Tabanan, Bali 82191
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers