ACID stands for Atomicity, Consistency, Isolation and Durability, the four properties every reliable database needs. Each one explained in a line or two.
SQL SERVER – Q and A with Database Administrators
My Q and A with Database Administrators from interviews in India: the technical questions we discussed and my opinion on each, with a link to the full article.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.
Onboarding a New DBA
Onboarding a new DBA starts with safe access, a server map, tested runbooks, and a first month of supervised operational tasks.
SQL SERVER – Generate Script with Data from Database – Database Publishing Wizard
The Database Publishing Wizard scripted schema and data for SQL Server 2005-era transfers. I keep that workflow separate from current SSMS instructions.
Comparing Server Settings Across Instances
Comparing server settings across SQL Server instances shows configured and live values, so you can judge which differences affect a workload.
Configuration Drift Between Servers
Find configuration drift between SQL Server instances, establish a baseline, and separate approved exceptions from settings that need repair.