After the announcement of Serveless Azure SQL Datbase at //build/, I decided to give it a try. I have some Basic databases, so what would Serverless mean for me?...
2019-05-31 (first published: 2019-05-15)
912 reads
This month we have a very interesting topic from Matthew McGiffen. He gets back to the roots of the party with code by asking a question on puzzles. It’s...
2019-05-14
36 reads
I’ve had this code in a snippet for a long time: I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen. I can’t...
2019-05-13
118 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Which of these is more complex? GRANT SELECT...
2019-05-23 (first published: 2019-05-10)
595 reads
If you haven’t heard, SSMS v18 went GA (Generally Availability) recently. You can download it from Microsoft, though if you have a preview version, you do need to uninstall...
2019-05-17 (first published: 2019-05-06)
561 reads
A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others. I had a VMWare Workstation v12.x...
2019-05-10 (first published: 2019-05-01)
140 reads
Tomorrow is the SQL in the City Summit in London. Right now I’m in a Heathrow airport hotel, finalizing some prep for the event. I have to run a...
2019-04-29
7 reads
This is part of a series of posts that look at the changes to the SQLServerCentral design, bringing us to v3 of the site. You can see the other...
2019-04-26
44 reads
Maybe we can get Chris Spalton to do some of these for all our events? I really like it. Just a few days until SQL in the City Summit...
2019-04-26
46 reads
I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed...
2019-04-24
25,374 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers