An outsourced app had teams using different coding standards, and performance suffered. Here is how to find the transaction isolation level of each session.
SQL SERVER – Unable to Run Maintenance Plan. Error: Integration Services Evaluation Period has Expired
The Integration Services evaluation period expired while the Engine remained available. Identify the failing runtime and verify backups before planning the upgrade.
Linting T-SQL: Rules Worth Automating in a Build
Use linting T-SQL to flag repeatable code risks, review catalog-based candidates, and automate confirmed rules without false certainty.
SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).
SQL Server Agent would not start in my lab: Failed to initialize SQL Agent log (reason: Access is denied). Here is what I found in the log folder and the fix.
SQL SERVER – All the Features not Listed While Installing SQL Server
Analysis, Reporting and Integration Services were missing from the Features page while installing SQL Server. The cause was missing MSI files in my setup media.
SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account
After I changed the SQL Server service account in my lab, the Always On secondary replica went disconnected. Here is why the endpoint rejects the new account.
SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction
A client’s SQL Server 2016 Installation in Cluster hung at RunRemoteDiscoveryAction while setup ran discovery on the other node. Here is the cause of the delay.