The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity storage solutions. In this book, Robert Sheldon explains the many types of storage currently available and what's on the way.… Read more
Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by Simple Talk author Greg Larsen, will give developers an understanding of the basics of the TSQL language. Programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server. … Read more
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the … Read more
In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.… Read more
XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML. In this book, originally a series of articles on SQLServerCentral.com, Robert Sheldon flexes his talent to make the complicated seem simple.… Read more
After hearing from Grant Fritchey that "Anyone who wants to know what DevOps really means should read this" Claire Brooking picked up a copy of The Phoenix Project. This parable of an IT project on the brink of destruction is told with humor and insight. Claire reviews the book, finding that conflict, incidents and mistakes are inevitable - what counts is how the team members grow to manage and resolve them.… Read more
Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These 'code smells' are coding styles that, while not bugs, suggest design problems with the code. In this PDF, Phil's put together 119 of those code smells, some generic, and some particular to SQL Server, so you can see what to avoid and why.… Read more
For efficient team-based database development, and reliable and repeatable database deployments, source control is not optional. This book provides just the right combination of theory and practical example to get you started quickly.… Read more
This beginner's guide by Jonathan Kehayias and Erin Stellato covers the basics of using wait statistics; topics include the SQLOS scheduler, performance tuning, baselines, and more.… Read more
If you want to learn how to optimize and troubleshoot Hyper-V, then this book, written by Microsoft people whose day job is to assist customers with precisely with these issues, is a safe bet. It is not, however, a book for anyone struggling to come to grips with the basics of Hyper-V… Read more
Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book begins with a short overview that introduces you to the technologies that make up replication. In the following chapters, the book will walk you through setting up different replication scenarios. … Read more
It is a measure of the range of facilities that are available to the database developer nowadays that three different books on the same general topic of TSQL programming can actually complement each other. … Read more
Windows Server 2012 Hyper-V Cookbook is a comprehensive resource for administrators and consultants looking for practical examples of Hyper-V technology. Beginners unfamiliar with Hyper-V and those who have worked with earlier versions can benefit from this book.… Read more
A book on Relational Database Design and Implementation is always welcome, especially when written by one of Simple-Talk's most popular authors, Louis Davidson. Bob Sheldon casts the critical eye on the book and smiles upon what he sees.… Read more
Experienced DBAs have a wealth of experience to rely on when it's time to troubleshoot a problem, but it can be harder if you're just starting out. Brad McGehee reviews a book designed to get new and accidental DBAs up to speed on their troubleshooting skills.… Read more
When things go wrong, a DBA's reputation depends on an understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.
This book shows you how to control your transaction log, so that it doesn't control you.… Read more
FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, adminstration and troubleshooting of it.… Read more
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.… Read more
A broad topic requires a thick book. the Microsoft SQL Server 2012 Bible is the work of several authors and comes to 59 chapters, yet it has all been edited into a single work that provides most of what you need to know about SQL Server outside your own specialization. … Read more
Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide.… Read more