T-SQL Tuesday #016 – Aggregation

It’s that time of month again, time for Adam Machanic’s (Twitter | Blog) T-SQL Tuesday blog party. This month the party...

An Overview of SQL Server AlwaysOn

One of the changes coming in SQL Server v11 (not sure what the name will actually be), also known as...

Avoiding Logging

It seems that some people think that you can perform actions in SQL Server without logging them in the transaction log. Steve Jones talks about this myth and says it's not even an option he'd like to have.

SQL Server Truncate Table Permissions

I saw a note recently where someone asked what permissions were needed for a user to execute TRUNCATE TABLE. In...

The Wisdom Department

Steve Jones talks about the way business ought to run, with more long term goals and objectives taking precedence over short term revenue. One idea that might help us is having a wisdom department that looks forward and tries to grow the business for the long term.

Back from the MVP Summit

Back home after three days in Seattle at the 2011 MVP Summit. As I wrote in an editorial this week,...

Coding Standards Part 2 - Formatting

The second part of Steve Jones' series on coding standards within SQL Server.

SLA Contracts

This Friday Steve Jones talks about the commitments and contracts that you may have with your customers. Do you know what they are? Is the contract explicitly spelled out? Take this Friday's poll and share your answer with everyone else.

RAID 10

Slow Fixes

Today we have an editorial reprinted from Jan 15, 2006 as Steve is on vacation. This one talks about the patching process at Microsoft, and why it sometimes is slower than we might like.