During a consulting session on SQL Server building blocks, a DBA asked me about pages. Here is how to identify Page Types in your database, back to basics.
SQL SERVER – Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster
After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
What is ACID Property in Database? – Interview Question of the Week #066
What is the ACID Property in a database? A classic interview question, with Atomicity, Consistency, Isolation and Durability explained in plain words.
SQL SERVER – InMemory OLTP Migration Assistant Powershell Script
Is your application ready for In-Memory tables? A client upgrading from SQL Server 2005 asked me, so here is the InMemory OLTP Migration Assistant script.
SQL SERVER – Identifying Database Default Locations for Data and Logs
Going back to basics can still teach you something new. Here are ways to identify the Database Default Locations for data and log files in SQL Server.
SQL SERVER – Huge Transaction Log in Snapshot Replication!
The log kept growing and sys.databases showed REPLICATION as the reuse wait. Here is how I found why the transaction log in snapshot replication was not reused.
SQL SERVER – What is DBCC TRACEON and DBCC TRACEOFF messages in ERRORLOG?
A client asked about DBCC TRACEON and DBCC TRACEOFF messages in the ERRORLOG. Here is what they mean, using trace flag 1222 for deadlock logging as an example.