Slides and Scripts from IT/Dev Connections
If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.
As I...
2018-10-23
245 reads
Blog Posts
SQL Saturday Lincoln Precon this Friday Oct 26
I’m presenting an exciting preconference training session on Friday, October 26, ahead of the SQL Saturday in Lincoln, Nebraska. This...
2018-10-23
193 reads
SQL Server on Linux – External Memory Pressure with 2019 CTP2
In this blog post we’re going to revisit how SQL Server on Linux responds to external memory pressure. This is...
2018-10-23 (first published: 2018-10-13)
1,680 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...
2018-10-23
5 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...
2018-10-23
7 reads
Webinar: The end of support for SQL Server 2008
Coeo is a partner with Redgate Software. Tomorrow they are hosting a webinar on what your position will be if...
2018-10-23
393 reads
ASF 015: Kalen Delaney interview
Introduction Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California....
2018-10-22
102 reads
Azure SQL DB – Failed to update database because the database is read-only
Quite an interesting situation I found myself in where I was perplexed for about 5 minutes. I was connected to...
2018-10-22
423 reads
Database Fundamentals #19: JOINS
The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but...
2018-10-22 (first published: 2018-10-08)
2,968 reads
Some Thoughts on How to Prepare to Serve on the PASS Board of Directors
From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I...
2018-10-22
248 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