Yesterday, I released my third book on SQL Server, titled ‘Developing with SQL Server’ 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.
How is the eBook Organized?
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.
Learn more about my eBook: “Developing with SQL Server”
Update 2018: This the second edition of the eBook.
If you are interested in SQL Programming in SQL Server, then this eBook is a must. The eBook is dedicated to developing with SQL Server and related technologies. It features a large number of articles on different topics, all with useful step-by-step examples. The eBook assumes at least intermediate-level experience with SQL Server development.
eBook Format: PDF
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, Former Microsoft Data Platform MVP (2009-2018)
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:
Reference: SQLNetHub.com (https://www.sqlnethub.com)
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).