Category: Database
-
SQL Server Schema Dump: One Copy-Paste Script to See Your Whole Database
List every table, column, key, index, and row count of any SQL Server database with one copy-paste script. Read-only, reusable, no install.
-
Convert Lat/Lng to X and Y Coordinates Using SQL: A Practical Guide
Learn how to project latitude/longitude coordinates into flat X/Y plane coordinates using SQL. Full T-SQL, PostgreSQL, MySQL, and SQLite examples with cosine correction and distance calculation.
-
SSMS “Cannot Open User Default Database” — Why Your App Works But SSMS Doesn’t
You fire up your .NET application, it connects to SQL Server without a hitch. Queries run, data flows, everything’s fine. Then you open SQL Server Management Studio to…
-
How to Use sqlite3.exe to Explore and Query a SQLite Database
SQLite is one of the easiest databases to work with because it stores everything in a single file and does not need a server running in the background.…
-
SSRS Gotcha: Recreating a Deleted Data Source Does Not Automatically Fix Broken Reports
I recently ran into a frustrating SSRS error that looked like a simple data source problem — but turned out to be a subtle reference issue that’s easy…
-
SQL ‘Like’ Command Cheat Sheet
The LIKE command in SQL is used to search for a pattern within a text/string column. It’s very useful when you don’t want an exact match but want…
-
SQL JOIN Cheat Sheet: A Memory‑Friendly Guide
If you ever find yourself pausing mid‑query wondering “wait… WHERE goes before GROUP BY, right?”—this cheat sheet is for you. This article gives you: The One Mnemonic to…
-
Unlocking the Power of Audit Tables: Lessons from Episode Tracking
When working with complex systems—like healthcare management platforms—having an audit table can be a lifesaver. These tables, which record every change to a record, often contain hidden gems…
-
Avoiding Database Persistence Pitfalls in Drone CI Deployments
The Problem: Data Loss During Deployments When deploying applications with Drone CI, one of the most frustrating issues is losing your database data after each deployment. You might…
-
Seeding SQL Server LocalDB v11: A Developer’s Guide
A practical guide to working with SQL Server LocalDB v11, creating databases with Entity Framework, and running seed scripts using PowerShell Introduction SQL Server LocalDB is a lightweight…