Creating the SSIS Catalog
If you are building SQL Server Integration Services (SSIS) packages, using the SSIS catalog as a deployment target is usually...
2017-07-03
706 reads
Blog Posts
Database Mirroring Needs FQDNs
A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things,...
2017-07-03
472 reads
Monday Coffee: Alerts & Checks
Hope you all had a good weekend, the Lions won so I’m pretty happy.
Over the weekend I was thinking about...
2017-07-03
360 reads
SQL Homework – July 2017
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...
2017-07-03
413 reads
SQL Server Database Files Wise I/O Latency Details PART#1
One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...
2017-07-03 (first published: 2017-06-26)
4,256 reads
Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations
Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API.
I have been...
2017-06-30
912 reads
Friday Reading 2017-06-30
Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up...
2017-06-30
574 reads
Implementing Fuzzy Sets in SQL Server, Part 11: Fuzzy Addenda
By Steve Bolton
…………One of the key reasons I looked into the topic of fuzzy sets in the first place was...
2017-06-30
719 reads
SQL Server Permissions and Security Principals on UserGroup.tv
You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a...
2017-06-30
675 reads
Statistics and Cardinality Estimation
Cardinality
This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”....
2017-06-30 (first published: 2017-06-20)
5,881 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers