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

OK, so we’re still evaluating SQL Server 2014, but are you ready now to explore Microsoft SQL Server 2016? No rest for the weary! Community Technology Preview (CTP) 2.2 is now available as a public ...

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

One of the big challenges for SQL Server admins has always been scaling databases to accommodate heavier data processing workloads. Complicating matters, Microsoft provides many different SQL Server ...

SQL Server configuration settings at the instance-level, database-level, and connection-level. Also be sure to catalog the sp_configure settings, as well as the sp_dboptions settings for the user ...

Cloud migration has moved far beyond test environments and secondary workloads. Enterprises are now moving the databases behind payments, patient systems, factory operations, retail platforms and ...