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.
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.
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 Layers: Protocols, Query Processor, Storage Engine and SQLOS
SQL Server layers run from the network protocols down to SQLOS and the data and log files. Here is what each layer does, and how physical architecture differs from logical architecture.