Docker Swarm
As we studied the basics of Docker and container and containerization , Docker – is a open-source platform to have multiple light...
2019-01-28
418 reads
Blog Posts
It’s always parameter sniffing (part 1?)
This is a blog post about a perennial issue. Have you ever had a call in the middle of the...
2019-01-28 (first published: 2019-01-16)
3,031 reads
My alternative to sp_WhoIsActive
I use sp_WhoIsActive a lot. I’m extremely grateful for Adam Machanic writing it. It has tons of options that let...
2019-01-28
5,105 reads
Pro SQL Server Linux–Connecting and Building an App
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-01-28
856 reads
Last Week Reading (2019-01-27)
Hello guys, a few internet posts that you might find interested. Press Azure SQL Analytics—Automating Deployment Apparently, it wasn’t an...
2019-01-27
181 reads
I’m a Friend of Redgate for Another Year!
I am very proud and happy to be a Friend of Redgate for a ninth year! I had to ask Redgate when...
2019-01-26
206 reads
Notes on our First SQLOrlando Lunch Meetup
Notes:
We had 17 register and 8 attend our first lunch meetup of the year at Fuzzy’s Tacos Great venue. $10...
2019-01-26
209 reads
SQLOrlando Tax Filing
Last year (the first filing) I had my accountant do the filing for SQLOrlando, but this year I wanted to...
2019-01-26
164 reads
ASF 018: Mladen Prajdic interview
Introduction Mladen Prajdic is a Data Platform MVP from Slovenia. He’s been professionally programming for over 15 years, developing di?erent...
2019-01-25
185 reads
Awarded Friend of Redgate – 2019
Friend of Redgate – 2019
I’m excited to announce that I have been named a Friend of Redgate for 2019, my forth year in...
2019-01-25
157 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
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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