I had lunch with an old friend last week. We hadn’t spoken in a while and we were catching up on everything that was going on in our lives. She mentioned that she was looking for a new job, and we got to talking about what she was looking for. “I want something that’s challenging.” […]
In an ideal world (well, a DBA’s ideal world, anyway) all database servers would have enough memory to hold every last byte of data we would need to store. We wouldn’t worry about disk latency, and PAGEIOLATCH waits would be nothing more than a distant memory. But you and I, we live in the real […]
Pop quiz: What does ACID stand for? That should be a pretty easy question for database professionals: Atomicity Consistency Isolation Durability It’s that last property, durability, that I want to talk about today. Durability guarantees that, when a transaction is committed, it stays committed. The changes made by that transaction are permanent, even in the […]
It’s a brand new year, so start it off right. Cleveland is hosting its third SQLSaturday on February 8, 2014 at Hyland Software in Westlake, OH. (Because where else would you rather be in February than Cleveland, Ohio?) This is one SQLSaturday you won’t want to miss. We’ve got some fantastic speakers lined up. SQL […]
Date: February 8, 2013 Title: SQL Audit – Auditing doesn’t have to be boring Abstract: Let’s face it, auditing isn’t fun. But if you’re a DBA, you need to know what’s going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we’ll cover what you can and can’t audit […]
