SQL Server Science
Technical Articles for the DBA / Developer
Home » tools » Page 2

The Progress Bar That Goes Backwards: A Jetpack Boost Source Code Archaeology

2026-05-25 · by Hannah Vernon · in Hot Takes, tools

You click “Regenerate Critical CSS.” The progress bar crawls forward: 20%, 30%, 40%. Then it drops to 20%. Climbs back to 50%. Drops to 35%. Eventually it hits 100%, and you exhale. Then it starts…

I Shaved 156 MB Off My Blog by Converting PNGs to WebP

2026-05-18 · by Hannah Vernon · in tools

I just shaved 156 MB off my blog. Not the database, not the theme, not some plugin audit. The images. The Problem Nobody Talks About If you use AI to generate featured images for your…

Your AI Agent Is Quietly Corrupting Your SQL Files

2026-05-11 · by Hannah Vernon · in AI for DBAs, tools

AI agents writing T-SQL via PowerShell here-strings produce LF line endings, breaking SSMS and diffs.

SqlPackage, Synonyms, and the Third-Party Database Problem

2026-05-08 · by Hannah Vernon · in tools

You’ve got a SQL Server database that talks to a third-party database via synonyms. The third-party vendor lets customers customize their schema. The table names differ across environments. You use SSDT and SqlPackage for deployments….

Database Seeding: When to Hit the Table vs. When to Hit the API

2026-05-06 · by Hannah Vernon · in tools

You’ve got a new environment to stand up. Maybe it’s a fresh QA instance, maybe it’s a training environment someone just spun up, or maybe production got rebuilt after a disaster recovery test. Either way,…

Inspecting SQL Server TLS Certificates Without Credentials

2026-04-15 · by Hannah Vernon · in security, tools

If you’ve ever needed to check the TLS certificate on a SQL Server instance – whether it’s expired, misconfigured, missing SANs, or just plain self-signed – you’ve probably had to connect with SSMS, run some…

« Previous 1 2 3 … 12 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • Data Architecture
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • High Availability
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • PostgreSQL
  • Professional Development
  • recovery
  • reporting
  • ROLLBACK;
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • Privacy Policy

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2026 SQL Server Science