My first eBook on SQL Server has been released. The title of the book is “Tuning SQL Server” and it is part of “The SQL Server and .NET Blog eBook Series!“.
How is the eBook Organized?
This book is organized as follows. Chapter 1 discusses the usage of indexes and the derived benefits of using them along with techniques to maintain them healthy in order to ensure performance. Chapter 2 discusses ways of managing log files as well as how to ensure that their growth will not create issues during the execution of heavy set-based operations. Chapter 3 discusses how you can monitor locking and tracking blocking cases in SQL Server as well as other locking-related topics. Chapter 4 discusses topics having to do with maintaining the good health and performance of the tempdb database as well as retrieving information from tempdb’ s data structures.
Learn more about my eBook: “Tuning SQL Server”
Update 2018: This the second edition of the eBook.
This eBook can help you learn more about SQL Server performance tuning. It suggests several techniques that can be used for ensuring performant and tuned SQL Server instances and assumes intermediate-level experience with knowledge of basic database principles (i.e. indexing, locking, etc.).
eBook Format: PDF
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, Former Microsoft Data Platform MVP (2009-2018)
See Inside this Book:
Table of Contents
Sample Chapter
Check our latest software releases!
Easily generate SQL code snippets with Snippets Generator!
Convert static T-SQL to dynamic and vice versa with Dynamic SQL Generator.
Secure your SQL Server instances with DBA Security Advisor.
Benchmark SQL Server memory-optimized tables with In-Memory OLTP Simulator.
Rate this article: 
(No Ratings Yet)
Loading...
Reference: SQLNetHub.com (https://www.sqlnethub.com)
© SQLNetHub
Artemakis Artemiou, a distinguished Senior Database and Software Architect, brings over 20 years of expertise to the IT industry. A Certified Database, Cloud, and AI professional, he earned the Microsoft Data Platform MVP title for nine consecutive years (2009-2018). As the founder of SQLNetHub and GnoelixiAI Hub, Artemakis is dedicated to sharing his knowledge and democratizing education on various fields such as: Databases, Cloud, AI, and Software Development. His commitment to simplicity and knowledge sharing defines his impactful presence in the tech community.