Back in 2010 I posted a few scripts to count your database’s tables, views and stored procedures. Good news: they

Continue readingCount Tables, Views and Stored Procedures in your Database

Originally posted June 2010. This debugging procedure — zombies plus malloc stack history — saved me more than once in

Continue readingTrace freed/deallocated instances of objects

Originally posted May 2010, back when this trick was making the rounds as “GodMode” in Windows 7. Fifteen years on

Continue readingWindows 7 – GodMode

The 2010 recipe floating around (and the one I originally posted) for an out-of-control transaction log: switch the database from

Continue readingSQL Server – Clear Log File

Back in February 2010 I kept a running list of SQL Server performance tips. Fifteen-plus years later almost all of

Continue readingSQL Server Performance Bible

Constraints are your data-integrity contract, but the contract only holds if it’s actually being enforced. A CHECK or FOREIGN KEY

Continue readingCheck for Database Constraints

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

Continue readingMySQL Import Data From EXCEL (csv file)

A quick T-SQL snippet I dug up from 2009: how to list every foreign key in a SQL Server database,

Continue readingSQL Script for Constraints

In 2009 I posted a list of 56 CSS galleries and web-design inspiration sources. Nearly two decades later it’s a

Continue reading55 + 1 Sources for Web Design Inspiration