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

When you decide to undertake your own benchmarking project, it’s a strongly recommended best practice to write up a benchmarking plan. For example, the dev architect might propose that the main OLTP ...

The SQL Server architecture is essentially the same on either platform. One difference is that the new feature of SQL Server 2008 R2 named Master Data Services is only available with the 64-bit ...

General availability on newer Linux distributions and CU1 signal a push toward stability, security and production readiness.

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

Microsoft today released SQL Server 2022, the latest version of its database software, which originally launched more than 33 years ago. Microsoft describes this release as the “most Azure-enabled ...