Apply best practices around filegroups with table placement, independent backups, read-only archives, and staged recovery planning.
SQL SERVER – How to Identify Locked Table in SQL Server?
Here is a quick script using sys.dm_tran_locks and sys.partitions to identify locked table names in SQL Server along with the lock type on each.
Bring SQL Cluster Resource Online When It Sits in Online Pending
A client could start a SQL Server instance from services.msc but could not bring SQL cluster resource online in Failover Cluster Manager. Here is how I checked the connection and found the cause: a TCP alias with an old port.
Analysis Services Performance Monitoring: What to Measure
Analysis Services performance monitoring starts with one habit: take measurements before users complain. This guest post by Bill Anton explains what to measure for processing and for queries, and why the OLAPQueryLog table tells only part of the story.
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.