Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
210 reads
Blog Posts
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
224 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got an error message to say “The host cannot be...
2017-11-30
8 reads
Handling Missing Instances when Looping with Pester
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
683 reads
Hit Refresh
I read Satya Nadella’s Hit Refresh recently, and it was a very enjoyable book. He’s had an interesting journey and...
2017-11-30
671 reads
I’m Presenting Two Linux Sessions on One Day!
On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from...
2017-11-30
484 reads
I’m Presenting Two Linux Sessions on One Day!
On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from anywhere!
Let’s go through both!
First, on 12/13 at 1PM Central,...
2017-11-30
7 reads
Information Measurement with SQL Server, Part 2.4: Conditional and Joint Entropy
By Steve Bolton
…………Since this series on using SQL Server to implement the whole gamut of information metrics is wide-ranging in...
2017-11-30
717 reads
Resources from the PASS community this coming month
Even though it is December, I noticed a lot going on for FREE in the PASS Microsoft Data Technology community....
2017-11-30
605 reads
Sessions, Temporary Objects, and the Afterlife
For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some...
2017-11-30 (first published: 2017-11-20)
2,008 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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