Bad Query Performance Tips Rebutted
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over...
2018-11-20 (first published: 2018-11-12)
3,235 reads
Blog Posts
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time...
2018-11-20
249 reads
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time is a bit troublesome. Is it milliseconds, seconds or...
2018-11-20
2 reads
Power BI World Tour–Dallas Nov 27-29
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World...
2018-11-20
205 reads
Power BI World Tour–Dallas Nov 27-29
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World Tour. There will be a one-day workshop on Tuesday...
2018-11-20
19 reads
Reasons to Serve on the PASS Board of Directors
A few weeks back I wrote Some Thoughts on How To Prepare to Serve on the PASS Board of Directors....
2018-11-20 (first published: 2018-11-11)
1,527 reads
Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that,...
2018-11-20
6,775 reads
Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that, Test-NetConnection. With the -Port option, this cmdlet will do...
2018-11-20
55 reads
Watch out – new Database Level Health Detection can send your AOAG down!
Background
In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups...
2018-11-20
295 reads
Would you give our database monitoring the UX thumbs up?
“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other...
2018-11-20
278 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers