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: Developing SQL Server

Developing SQL ServerThis book is for database developers and architects who develop SQL Server databases and related database processes. The book features tens of articles that provide detailed information on how to develop in SQL Server. However, the book is not intended to be a step-by-step comprehensive guide. Additionally, it assumes at least intermediate-level experience with SQL Server development and knowledge of basic database principles.

This book is organized as follows. Chapter 1 discusses different programmability topics on SQL Server and ways to handle different problems you might encounter while developing database operations. Chapter 2 discusses how you can work with unstructured data in different versions of SQL Server. Chapter 3 introduces SQL Server’s In-Memory OLTP Engine and discusses how you can identify if you have a workload that could significantly benefit by using this technology. Chapter 4 presents In-Memory OLTP Simulator which is an application I developed, with which you can simulate virtually any workload against SQL Server’s In-Memory OLTP Engine and get rich analytics as well as real-time performance statistics. Chapter 5 discusses about PowerPivot; an add-in for Excel which enables the user to perform Self-Service Business Intelligence against millions of records of data within minutes. Chapter 6 discusses Data Access topics like the ADO.NET Entity Framework and WCF Data Services. Chapter 7 contains T-SQL tips for performing specific tasks. Chapter 8 features several special topics on SQL Server like where programmability objects are stored and how to retrieve information about them. Finally, chapter 9 discusses miscellaneous topics on SQL Server and on generic database-related topics.

  -Release Date: November 4, 2015 New Release
  -Level: Intermediate-Level SQL Server development experience.
  -Price: Free

  -Feedback: Please use this link.
  -Subscribe (*recommended): Please use this link.

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

  Table of Contents:


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