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
career development
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
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
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
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 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,
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
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
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
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
sql203
Yeah, I used a pipe in my title. That's because indexes can help some things, but hurt others. The brief of it is indexing helps reads, but comes at a cost:
microsoft sql
Let's finish up with the SQL 210 series today with the APPLY operator. After you learn how to create your own functions, you're going to want to use them in new