Check for Database Constraints
Constraints are your data-integrity contract, but the contract only holds if it’s actually being enforced. A CHECK or FOREIGN KEY
Constraints are your data-integrity contract, but the contract only holds if it’s actually being enforced. A CHECK or FOREIGN KEY
Every so often a database needs to go back to a clean slate: all data gone, schema intact, identity columns
Continue readingSQL Server, Empty your Database & Reset Identity Columns **made Simple
Importing a spreadsheet into MySQL is a two-command job once you know the LOAD DATA incantation — but the details
A quick T-SQL snippet I dug up from 2009: how to list every foreign key in a SQL Server database,
In 2009 I posted a list of 56 CSS galleries and web-design inspiration sources. Nearly two decades later it’s a
This is the second version of my Flash ActionScript 3 XML-driven navigation menu — a little component I built back
Back when Windows 7 was in RC/Beta, Chrome had an ugly crash on it — pages with plugins would take
This one comes straight from the trenches: May 2009, Windows 7 RC, and Apache refusing to bind port 80. Sixteen
Back in 2009 I wrote a workaround for installing LogMeIn Free on Windows 7 Beta, months before LogMeIn shipped an
So there I was, installing Ubuntu 9.04 on a machine that already had Windows on it, and GRUB greeted me