The SQL Server service would not start for a DBA fresh out of college. The cause was Error 5118, and here is how to read it and fix it.
SQL SERVER – One Trick of Handling Dynamic SQL to Avoid SQL Injection Attack?
SQL Injection is not a SQL Server problem, it comes from coding habits. Here is one trick of handling dynamic SQL to avoid SQL injection attack on a search page.
SQL SERVER – Watching Table Variable Data in TempDB
Are table variables only in memory? I watch table variable data in TempDB to answer a reader’s questions on where it is stored and if it is logged.
MySQL – Scaling Existing Applications: Key Observations and Measurements
When a monolithic MySQL database hits its limits, bigger hardware only goes so far. Scaling existing applications starts with key observations and measurements.
MySQL – How to Create a Distributed Relational SQL Database
How is data spread across a distributed relational SQL database? I explain what a data distribution policy is and why it matters as your applications grow.
SQL SERVER – How to Check Snapshot Isolation State of Database
A quick script to check the snapshot isolation state of every database, plus a note on when to pick READ COMMITTED SNAPSHOT over SNAPSHOT.
Google Drive Trick – Google Spreadsheet Formatting Dates to String
Google Spreadsheet keeps turning the dates I type into mm/dd/yyyy. My team found a trick to keep dates as plain strings so nobody mixes up formats.