How to generate Fibonacci series for the first 1000 values? Most answers online stop near 70 or 80 values because the numbers get too big. Here is mine.
SQL SERVER – SQL Server Cluster Resource Doesn’t Come Online Randomly
A client’s SQL Server Cluster Resource sometimes failed to come online after a failover to another node. Here is what caused it and how we fixed it.
How an Open Transaction Uses Free Log Space
An open transaction holds free log space hostage. This post runs one transaction in a SIMPLE recovery database and reads the log after the load and after the commit. It explains why the log grows before COMMIT, what ACTIVE_TRANSACTION means, and why a new FULL recovery database behaves like SIMPLE until its first full backup.
Find Who Dropped a Table by Reading the Transaction Log
To find who dropped a table, read the transaction log for the DROPOBJ transaction and look up the login behind its security ID. This post runs that search on a demo database, shows the default trace as a second source when the log has been truncated, and explains what to do when everyone shares one login.
SQL SERVER – Creating a Login and Database User Without Automatic Sysadmin Grants
To Create a Login and User, I separate the instance identity from database access. Database ownership and sysadmin membership have different scopes.
Recovery Pending State in SQL Server: Find Why Databases Go There at Random
A Recovery Pending state means SQL Server could not finish opening a database, most often because it could not open a file. I reproduced two file errors on SQL Server 2025, show what each leaves in the error log, and explain how AUTO_CLOSE and antivirus scanning caused one client case.
SQL SERVER – FIX: Msg 22004 – The Log File is Not Using Unicode Format
The SQL Server Agent log would not open in SSMS and showed Msg 22004, the log file is not using Unicode format. Here is the setting that fixed it.