TempDB Information starts with the files and their actual locations. I inspect every data and log file before proposing changes.
SQL SERVER – Solution – Log File Very Large – Log Full
Is your log file too big, or is the log full? Fix it in three steps: back up the log file, truncate it, then shrink it. I link my two detailed posts too.
SQL SERVER – TempDB Restrictions – Temp Database Restrictions
TempDB Restrictions follow from how SQL Server recreates and uses this system database. I check them before applying user-database maintenance habits.
Working With an Outsourced Database Team
An outsourced database team needs a clear scope, controlled access, useful reporting, and a plan to keep operational knowledge in house.
SQL SERVER – Do Not Store Images in Database – Store Location of Images (URL)
Should you store images in database tables? My advice: keep the image location (URL) in a VARCHAR column instead, so the database stays small and updates stay simple.
Migrating From Access to SQL Server: Data Types and Gotchas
Plan migrating from Access with explicit type mappings, boolean and date checks, query rewrites, and a primary key inventory.
NCHAR: Build Unicode Characters From Integer Codes
NCHAR builds a character rather than formatting a number. Preserve source codes and distinguish unsupported values from missing input.
A Throwaway Virtual Machine for SQL Server Testing
Use a Throwaway Virtual Machine to test SQL Server setup, patches, and failures with snapshots and safe rollback away from shared servers.
SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)
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 – Generic Architecture Image
A Generic Architecture image of SQL Server I found on Wikipedia, with a short note on physical storage in MDF and LDF files and how data is grouped logically.