Some letters get all the love. Take ‘C’ for example. You’ve got collation, clustering, compression, constraints, change data capture… Colleen. And what about ‘A’? Atomnicity, authentication, automation, auditing, Azure, and so on. But not ‘K’. What does poor little ‘K’ get? Kill? Keywords? Meh. So today I’m talking about Kerberos. I’ll tell you a little […]
Querying a single table at a time will only get you so far. Eventually, you’re going to need to combine that data, to “join” it, to get more meaningful information. Joins put the relationships into relational databases. Today I want to talk about the various types of joins that SQL Server performs. I don’t mean […]
In the SQL Server database, isolation levels determine how concurrent transactions play with each other. They control the locking behavior of a transaction, including what kind of locks, if any, are requested on a resource, as well as how long those locks are maintained. The isolation level also controls how we see data that is […]
How time flies! It’s T-SQL Tuesday Wednesday and this month’s festivities are being hosted by Adam Mechanic (blog | twitter). The topic – “Crap Code: Outing Your Inner Suckage”. Nice. I like to think that a good part of my job is helping coworkers fix their own crap code. But that doesn’t mean I’m not […]
Happy Monday, SQL peeps. I hope everyone had a great weekend. I, for one, had so much fun on Saturday, that I spent Sunday recovering. When did I get old? Anyway, time for another installment of SQL Server A to Z. Today we’re talking about heaps. What is a heap? A heap is a table […]
