Finding & Downloading Required SQL Server Updates
A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...
2020-07-21
163 reads
alevyinroc
- Website: https://flxsql.com
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-07-06 (first published: 2020-06-23)
2,547 reads
Virtual SQLRun for PASS Summit 2020
Just because we aren’t all together in Houston doesn’t mean we can’t have a #SQLRun at this year’s Summit. It might even be easier for some folks as there’s...
2020-07-02
8 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-06-23
25,874 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ‘em all over the place...
2020-06-23
3 reads
Speaking at SQL Saturday Albany
For the second consecutive year, I will be speaking at SQL Saturday Albany 2020 on July 25th, 2020. I will be presenting “Keys to a Healthy Relationship with SQL...
2020-06-16
3 reads
T-SQL Tuesday #127 - Non-SQL Tips & Tricks
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Kenneth Fisher (blog | twitter) asks us for non-SQL tips &...
2020-06-09
8 reads
Home Office Desk Evolution
Setting up a home office can be a daunting task. Doubly so when you don’t get an opportunity to plan it out and you have to set things up...
2020-06-02
2 reads
Checking for SQL Server Updates with dbatools
It turns out I was doing this all wrong for months.
For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild from...
2020-04-28
69 reads
Remote Work Resources
We’re at least five weeks into this thing here in New York and while there are some encouraging signs, it’s more likely than not that “non-essential” workers aren’t at...
2020-04-21
4 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