About Artemiou SQL Books

On this page you can find my published books and tutorials on SQL Server and related technologies. All these resources are free for download.

 SQL Books



The eBooks and tutorials authored by Artemakis Artemiou and are provided via this website or any other channels, express the author’s views and opinions. The information contained in these eBooks and tutorials is provided without any express, statutory, or implied warranties. Neither the author, nor distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by these eBooks and tutorials.

SQL Server MVP Artemakis Artemiou INETA EU

Cyprus .NET User Group The SQL Server and .NET TV Artemakis on Twitter The SQL Server and .NET Blog



  The SQL Server and .NET eBook Series: Tuning SQL Server

Tuning SQL Server by Artemakis ArtemiouThis book is for database administrators and architects who monitor and tune SQL Server instances in order to keep them operating to the maximum possible performance and stability. The book suggests several techniques that can be used for ensuring a performant SQL Server instance.

This book is organized in 4 chapters. 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.

Release Date: October 1, 2013
Level: Intermediate-level experience with knowledge of basic database principles (i.e. indexing, locking, etc.).
  -Price: Free
  -Feedback: Please use this link.

Subscribe (*recommended): Please use this link.

Download Download the eBook here! || Total Downloads: 2648

  Table of Contents:


Download Download the eBook here! || Total Downloads: 2648