The following guides are available. They discuss general concepts and apply to all platforms that use the SQL Database Engine, unless stated otherwise in the respective guide. Use these guides to ...

msdb: used by SQL Agent, backups/restores, Service Broker, mail, alerts etc Details of how to move undamaged and damaged system databases (other than the master database) are given with step-by-step ...

Auditing an instance of the SQL Server Database Engine or an individual database involves tracking and logging events that occur on the Database Engine. SQL Server audit lets you create server audits, ...

In-Memory OLTP is the major new feature in SQL Server 2014. In this slim volume a notable internals expert endeavours to explain it all. Historically, memory has been expensive, so SQL Server was ...

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