Thursday, November 5, 2015

My Third Book Titled 'Developing SQL Server' is Now Out!

Yesterday, I released my third book on SQL Server, titled ‘Developing SQL Server’.  This eBook is the third and the last one of “The SQL Server and .NET Blog eBook Series” and it is dedicated to SQL Server development but don’t worry, there are more books to come! :)

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

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

The book is available as a free download at Artemiou SQL Books website.

Feel free to provide your feedback!

Check out my latest eBooks on SQL Server:
Administering SQL Server - Ebook Tuning SQL Server - Ebook

Easily secure your SQL Server instances! Try out DBA Security Advisor!
DBA Security Advisor for SQL Server by SQLArtBits
DBA Security Advisor was developed by SQLArtBits. The tool was being carefully developed for an entire year and it contains comprehensive security checks and recommendations based on proven SQL Server security best practices. Feel free to download and use the Community Edition which is free and if you find it useful, you can consider upgrading to the Enterprise Edition!

Artemakis Artemiou [MVP]

Author & Editor

Artemakis Artemiou is a Senior SQL Server Architect, Software Developer and Microsoft Data Platform MVP. He is also an author, regular blogger, president of Cyprus.NET User Group and CY Country leader of INETA-EU. He is also the creator of DBA Security Advisor and In-Memory OLTP Simulator. Artemakis is a frequent guest author of worldwide well-respected online journals where he writes articles focusing on many SQL Server topics.

Reference: The SQL Server and .NET Hub (