Archives
All the articles I've archived.
- Test Post Type
Test Post
A test post for development purposes.
- Review
Orange Travel eSIM in Sharm el-Sheikh
What to expect from an Orange Travel eSIM in Egypt -- coverage, speeds, VPN compatibility, and a French IP address.
- Deep Dive
When a VARCHAR Isn't a VARCHAR
Implicit conversions in T-SQL are silent and legal, and they can turn an index seek into a full table scan without any obvious cause.
- Deep Dive
Your SQL Server Version Isn't the Whole Story
Database compatibility level controls a lot more than most people realise, and it doesn't follow the SQL Server version automatically.
- Deep Dive
NOLOCK Isn't Free
NOLOCK is one of the most misused hints in T-SQL. Here's what it actually does, what it risks, and when it might be worth it.
- Opinion
Where have all the graduate IT roles gone?
My daughter is finishing her MSc in computer science and the job market for graduates isn't great. I've been in IT for twenty-five years and I find it a bit worrying.
- SQL Shorts
Concerned about available disk space?
A quick script to view disk sizes and available space for all drives hosting databases, straight from SSMS.
- SQL Shorts
Who's there?
Find out what is running on your SQL Server
- Opinion
25 Years as a DBA
What I know now that I wish I knew then
- SQL Shorts
How much space do my database files have?
Database files can fill up quickly. By the time someone notices, you're usually already in trouble.