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.
Does Dropping Primary Key Drop Clustered Index on the Same Column? – Interview Question of the Week #082
When you drop a primary key, does it drop the clustered index on the same column too? Yes, it does. Here is a small script that shows it.
SQL SERVER – What is Deadlock Scheduler? How to Reproduce it?
If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler.
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.