career development
New Job Postings for 05/17
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.#DEVELOPER in Fort Knox,
Latest
Your Schema Is an API: Design It Like One
A staging schema is a contract. It says: data arrives here, in this shape, from these sources, and the downstream systems can count on it being there. Most of us don't design it like a contract. We design it like a scratch pad — add columns as needed, rename
Database Health Checks When You Can't Touch the Box
A database health check used to mean RDP-ing to the server, checking Windows event logs, reviewing SQL Agent job history, running sp_Blitz, and having a look at perfmon counters while you were there. I ran these for clients regularly. Moving to Azure removed half of those touchpoints. The box
career development
New Job Postings for 05/15
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.Systems Administrator
career development
New Job Postings for 05/10
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.#JAVA #DEVELOPER in
career development
New Job Postings for 05/08
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.#dotNET #DEVELOPER in
microsoft sql
DATEPART(WK, DateColumn)
It's been a busy month since my last post. Moving from contracting to consulting requires a more work that I'd thought at first. In looking over the past
Apache Kafka: What It Is and Why SQL Developers Should Care
Apache Kafka is a distributed event log. That is the whole thing. Everything else — the producer API, the consumer API, the partitioning scheme, the replication — is infrastructure built to make that log fast, durable, and accessible to many readers simultaneously. If that sounds like SQL Server's transaction log,
Message Queues Aren’t Event Streams: The Distinction That Changes How You Architect Data Pipelines
Your message queue works. Data goes in, data comes out, everyone is happy. Until the day a downstream consumer crashes mid-read, the queue redelivers the message, and now you have a duplicate in your database that accounting is going to find in three weeks and blame on the ETL team.
DMVs Without the Hardware: What SQL Azure Monitoring Looks Like
The first time I needed to diagnose a slow query on a SQL Azure database, I opened SSMS and reached for sys.dm_os_wait_stats the way I always did. The query ran. The results were there. And then I spent ten minutes staring at wait stats that made
microsoft sql
Upgrade SQL Server
One of the most difficult projects to undertake as a DBA is upgrading your SQL Server from one version to another. The biggest reason that it's so difficult is
SQL102
World Backup Day
This past Saturday was World Backup Day, It's not an actual government recognized holiday, but as a DBA you should start celebrating it. Maybe celebrate isn't