Developers working with SQL Server often treat indexing as a DBA's domain--something happening "under the hood" that doesn't require much attention unless performance takes a hit. But ignoring the ...

SQL Server 2005 also promises better performance. I didn’t run performance benchmarks for this review, but in addition to allowing DBAs to partition the database to balance load, Microsoft has done a ...

Described as an advanced course designed for advanced SQL Server professionals, the course will feature detailed demonstrations of SQL Server internals, as well as tuning techniques, utilizing SQL ...

Recently, I was speaking at a SQL Saturday event (www.sqlsaturday.com), when I encountered a question that I've been getting more and more often. It went something like this: "I know that I can look ...