Count Tables, Views and Stored Procedures in your Database
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
From Our Blog
Trace freed/deallocated instances of objects
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
Windows 7 – GodMode
Originally posted May 2010, back when this trick was making the rounds as “GodMode” in Windows 7. Fifteen years on
SQL Server – Clear Log File
The 2010 recipe floating around (and the one I originally posted) for an out-of-control transaction log: switch the database from
SQL Server Performance Bible
Back in February 2010 I kept a running list of SQL Server performance tips. Fifteen-plus years later almost all of
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
SQL Server, Empty your Database & Reset Identity Columns **made Simple
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
MySQL Import Data From EXCEL (csv file)
Importing a spreadsheet into MySQL is a two-command job once you know the LOAD DATA incantation — but the details
SQL Script for Constraints
A quick T-SQL snippet I dug up from 2009: how to list every foreign key in a SQL Server database,
55 + 1 Sources for Web Design Inspiration
In 2009 I posted a list of 56 CSS galleries and web-design inspiration sources. Nearly two decades later it’s a