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!