SQL Server would not start and there was no ERRORLOG. Event 17058, initerrlog: Could not open error log file, came from missing permissions on the Log folder.
Find and Replace With Regular Expressions in SSMS
A regex replace can turn forty column names into ISNULL expressions in seconds. Here is the pattern, the safety habits, and the trap of a zero default.
SQL SERVER – Setting Firewall Settings With Azure SQL Server VMs
Can’t reach SQL Server on an Azure VM from your app? The firewall was the culprit. Here are the steps I use to set firewall rules with Azure SQL Server VMs.
A Retry Loop in T-SQL for Deadlock Victims and Lock Timeouts
Build a bounded retry loop for deadlock and lock-timeout errors, roll back each failed transaction, and keep diagnostics beside retries.
SQL SERVER – Becoming a More Effective DAX Developer with DAX Studio – Notes from the Field #134
Bill Anton walks through DAX Studio, the tool that makes writing, testing and tuning DAX easier for Power BI, Power Pivot and Tabular developers.
SQL SERVER – System Stored Procedures I Use to Get Started
System Stored Procedures remain part of my troubleshooting toolbox. I use these familiar entry points before moving to more detailed views.
SQL SERVER Installation – FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed
SQL Server Installation failed on rule FeatureUpgradeMatrixCheck: the edition upgrade from Enterprise to Evaluation is not supported. Here is why and the fix.