Название: Inside the SQL Server Query Optimizer
Автор: Benjamin Nevarez
Издательство: Simple Talk Publishing
Год: 2010
Формат: PDF
Страниц: 252
Размер: 11,46 МБ
Язык: English

This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.
The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to DBAs and Developers alike.

Название: SQL Server Source Control Basics
Автор: Robert Sheldon, Rob Richardson & Tony Davis
Издательство: Simple Talk Publishing
Год: 2014
Формат: PDF
Страниц: 296
Размер: 12,03 МБ
Язык: English

This book provides just the right combination of theory and practical example to get you started quickly.

Название: The SysAdmin Handbook: The Best of Simple Talk SysAdmin
Автор: Simple Talk
Издательство: Red Gate Books
Год: 2010
Формат: PDF
Страниц: 514
Размер: 23.05 МБ
Язык: English

Over the past two years, Simple-Talk has published articles on a variety of SysAdmin topics, from Exchange to Virtualization, and including everything from Powershell to Unified Messaging. We have brought the best of these articles together to form The SysAdmin Handbook. With over fifty articles packed into this book, it will be an essential reference for any Systems Administrator, whether you have years of experience or are just starting out.

Название: Defensive Database Programming with SQL Server
Автор: Alex Kuznetsov
Издательство: Simple Talk Publishing
Год: 2010
Формат: PDF
Страниц: 389
Размер: 10,46 МБ
Язык: English

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings. Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.

Название: Stairway to SQL Server XML
Автор: Robert Sheldon
Издательство: SimpleTalk Publishing
Год: 2017
Страниц: 118
Язык: английский
Формат: True PDF
Размер: 64.2 MB

Although XML is conceptually simple, its use as an equal partner datatype within a relational database, with full searching, validation and manipulation of data, is not intuitive. 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.

Название: Microsoft Exchange Server 2013: Databases, Services, & Management, Pocket Consultant
Автор: William R. Stanek
Издательство: Microsoft Press
Год: 2013
Формат: PDF, EPUB
Страниц: 400
Размер: 11,83 МБ
Язык: English

Portable and precise, this pocket-sized guide delivers ready answers for managing databases and services in Exchange Server 2013. Zero in on core tasks through quick-reference tables, instructions, and lists. You'll get the focused information you need to save time and get the job done-whether at your desk or in the field.

Название: Windows Server 2012 R2 Pocket Consultant Storage, Security, & Networking
Автор: William R. Stanek
Издательство: Microsoft Press
Год: 2014
Формат: PDF, EPUB
Страниц: 416
Размер: 12.16 МБ
Язык: English

Portable and precise, this pocket-sized guide delivers ready answers for administering storage, security, and networking features in Windows Server 2012 R2. Zero in on core tasks through quick-reference tables, instructions, and lists. You'll get the focused information you need to save time and get the job done - whether at your desk or in the field.

Название: Microsoft Visual C# 2013 Step by Step
Автор: John Sharp
Издательство: Microsoft Publishing
Год: 2013
Формат: PDF
Размер: 17 Мб
Язык: английский / English

Expand your expertise—and teach yourself the fundamentals of Microsoft Visual C# 2013. If you have previous programming experience but are new to Visual C# 2013, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques.

Название: Windows Server 2012 Inside Out
Автор: William R. Stanek
Издательство: Microsoft Press
Год: 2013
Формат: PDF
Страниц: 1584
Размер: 33,55 МБ
Язык: English

Dive in—and discover how to really put Windows Server 2012 to work! This supremely organized reference packs the details you need to plan and manage a Windows Server 2012 implementation—including hundreds of timesaving solutions, troubleshooting tips, and workarounds. Learn how the experts tackle Windows Server 2012—and challenge yourself to new levels of mastery.

Название: Optimizing Windows 7 Pocket Consultant
Автор: William R. Stanek
Издательство: Microsoft Press
Год: 2011
Формат: PDF
Страниц: 208
Размер: 11,03 МБ
Язык: English

Portable and precise, this pocket-sized guide delivers ready answers for optimizing the performance of your Windows 7-based PC. Zero in on core tuning, customization, and troubleshooting tasks using quick-reference tables, instructions, and lists. Topics include system boot and startup, software and hardware, search and indexing, system health, and personalizing the interface. You’ll get the focused information you need to solve problems and get the job done.