The series of free eBooks ''The SQL Server and .NET Blog eBook Series'' by Artemakis Artemiou (@artemakis) collects dozens of articles explaining how to solve practical problems in these areas: Database DevelopmentDatabase AdministrationPerformance Tuning Developing SQL Server (The SQL Server and .NET eBook Series)This ...

From Red-Gate website you can download (for free) the ebook SQL Server Hardware written by Glenn Berry (@GlennAlanBerry). This ebook will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server ...

From Red-Gate website you can download (for free) the ebook Performance Tuning with SQL Server Dynamic Management Views written by Louis Davidson (@drsql) and Tim Ford (@sqlagentman). DMVs are objects that publish information about the health state of a SQL Server instance. They allow you to monitor the heart of the system to diagnose ...