Does SQL Server start a new transaction for every BEGIN TRAN inside another? I show nested transactions behavior with a simple demo for a reader.
SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location
When readers report a strange error, I first ask for the SQL Server ERRORLOG. Here are the various ways to find the ERRORLOG Location on your server.
SQL SERVER – Backup and Restore Behavior of ReadOnly Filegroup Databases
How do backups behave for a database with a ReadOnly filegroup, and does a restore keep that setting? I walk through it with simple T-SQL scripts.
Interview Question of the Week #012 – Steps to Restore Bak File to Database
Restore bak file backups safely with header and file inspection, complete Windows paths, conditional access changes, and recovery options.
SQL SERVER – Trivia – Days in a Year
A friend was asked in an interview how to find the days in a year efficiently. Here are the T-SQL methods I tried, plus a small quiz for you.
SQL SERVER – Add Node in Cluster – Rule “Node and cluster edition match” failed
Running AddNode on the second cluster node failed with the rule Node and cluster edition match. Here is what the setup logs revealed and how to solve it.
SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072
Reeves Smith explains why you should add Master Data Services to your enterprise and why data governance is often overlooked in data warehouse projects.