A SQL Cluster Resource started from services.msc but sat in Online Pending and then failed in Failover Cluster Manager. Here is how I tracked down the cause.
SQL SERVER – Understanding the Basics of Write Ahead Logging (WAL) Protocol
Doing the basics right matters. Here is a simple, story-driven explanation of the Write Ahead Logging (WAL) protocol that keeps SQL Server transactions safe.
SQL SERVER – Error while starting SQL Server logFileSize <= BlkToByteOffset ((ULONG)-1)
A tempdb mistake left SQL Server unable to start. Here is the error while starting SQL Server, a failed assertion on logFileSize, and the fix.
SQL SERVER – Error: Msg 4305, Level 16, State 1 – The log in this backup set terminates at LSN, which is too early to apply to the database.
Msg 4305 says the log in this backup set is too early or too recent to apply. I build a sample database with backups to show why it happens during a log restore.
SQL SERVER – Adding File to Database in AlwaysOn Availability Group
A classic interview question: what happens when adding file to database in an AlwaysOn Availability Group? Here is the answer, with the basics first.
SQL SERVER – How to do IF…THEN in SQL SERVER?
How do you write IF…THEN in SQL Server? Use a CASE statement, or IIF from SQL Server 2012. Here are simple examples of both for a .NET developer.
SQL SERVER – A Stored Procedure for Executing SSIS Packages in the SSIS Catalog – Notes from the Field #092
SSIS expert Andy Leonard shares a stored procedure for executing SSIS packages in the SSIS Catalog, from the book SSIS Design Patterns. Notes from the Field #092.