The Guru's Guide to SQL Server Architecture and Internals helps SQL Server power users manage their complex enterprise systems. This valuable reference manual goes far beyond the product's base ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

After reading SQL Server Forensic Analysis, you can answer "Yes, I can!" The other useful SQL Server book I've been digesting recently is Microsoft SQL Server 2008 Reporting Services Unleashed (SAMS ...

When I am teaching a class I always emphasize the importance of SQL Server Books Online. This Help system is, in my opinion, the best in the business. The proof is that even the experts use it on a ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).