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 ...

With best-in-class ease of use on the Windows platform, Microsoft SQL Server 2000 SP2 combines strong administration abilities with leading-edge XML support. Though it's still Windows-centric, ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

If you're considering moving your on-premises SQL Server databases to the Microsoft Azure cloud, you need to decide which of the different cloud options works best for you. You might not realize it to ...

The first step in learning how to avoid deadlocks in SQL Server databases is preparedness. Knowing about deadlocks -- in particular, what causes them -- is the key to preventing them and resolving ...