Ben-Gan Itzik, Dejan Sarka, Adam Machanic, Kevin Farlee. — Microsoft Press, 2015. — 865 p. — ISBN: 978-0-7356-8504-8. T-SQL insiders help you tackle your toughest queries and query-tuning problems. Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced...
Microsoft Press, 2015. — 864 p. — ISBN10: 0735685045; ISBN13: 978-0735685048. T-SQL insiders help you tackle your toughest queries and query-tuning problems. Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing...
Microsoft Press, 2015. — 864 p. — ISBN10: 0735685045; ISBN13: 978-0735685048. T-SQL insiders help you tackle your toughest queries and query-tuning problems. Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing...
Microsoft Press, 2015. — 864 p. — ISBN10: 0735685045; ISBN13: 978-0735685048. T-SQL insiders help you tackle your toughest queries and query-tuning problems. Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing...
4th Edition. — Apress, 2015. — 972 p. + Code. — ISBN13: (electronic): 978-1-4842-0061-2, ISBN13: (pbk): 978-1-4842-0062-9. SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database...
4th ed. — Apress, 2015. — 670 p. — ISBN: 9781484202814, 9781484202807 Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL...
Packt Publishing, 2014. — 106 p. — ISBN10: 1782172416, ISBN13: 978-1-78217-241-3. На англ. языке. Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014 with this book and ebook. The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make...
Apress, 2014. — 593 p. — ISBN: 1430267437.
На англ. языке.
Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey’s book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance...
John Wiley & Sons, Inc., 2014. 936 p. — ISBN: 1118859138, I SBN: 978-1-118-85913-1. На англ. языке. Learn to take advantage of the opportunities offered by SQL Server 2014. Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here...
John Wiley & Sons, Inc., 2014. 936 p. — ISBN: 1118859138, I SBN: 978-1-118-85913-1. На англ. языке. Learn to take advantage of the opportunities offered by SQL Server 2014. Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here...
Wrox, 2014. — 912 p. — ISBN: 1118850874, 9781118850879
The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth...
Apress, 2014. — 776 p. — ISBN10: 1430259620, ISBN13: (electronic): 978-1-4302-5963-3. На англ. языке. Pro SQL Server Internals peels back the covers of SQL Server, explaining in detail how the database works in a way that allows you to immediately apply this knowledge to day-to-day tasks. It uncovers the product internals and, more importantly, demystifies how internal...
Apress, 2015. - 272p.
Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 – support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase...
2nd ed. — Apress, 2016. — 805 p. — ISBN: 978-1-4842-1964-5. Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work “under the hood,” and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You’ll...
Microsoft Press, 2014. — 144 p. — ISBN: 978-0-7356-8475-1.
На англ. языке.
Get a head start evaluating SQL Server 2014 - guided by two experts who have worked with the technology from the earliest beta. Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insights on how SQL Server 2014 can meet the needs...
Packt Publishing, 2019. — 564 р. — ISBN: 1789802598. This detailed book teaches you high availability and disaster recovery strategies and solutions available in SQL Server and helps you build highly available SQL Server to support the application needs.
Apress, 2016. — 316 p. — ISBN10: 1484220706. — ISBN13: 978-1484220702. This book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is an enterprise-level solution for high availability and disaster recovery. Always On provides a rich set of options that reduce overhead and resource...
Apress, 2015. — 408 p. — ISBN: 1430267739, ISBN13: (electronic): 978-1-4302-6772-0. На англ. языке. Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct...
Apress, 2015. — 408 p. — ISBN13: 978-1-4302-6772-0. Целевая аудитория: начинающие программисты. Healthy SQL - это книга о том, как проектировать правильные базы данных, как соблюдать нормальные формы структур таблиц и как справляться с большими нагрузками. Книга наполнена практическими советами и примерами правильно спроектированных баз данных. Также вы узнаете о таких...
Packt Publishing, 2015. — 760 p. — ISBN: 978-1-78528-332-1. Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity. PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities...
Packt Publishing, 2015. — 760 p. — ISBN: 978-1-78528-332-1. Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity. PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities...
CreateSpace Independent Publishing Platform, 2014. — 820 p. — ISBN10: 1499529597, ISBN13: 978-1499529593. SQL Server 2014 design & programming builds on achievements of decades in advanced relational database technology. Among the new SQL Server 2014 features is prominent: in-memory OLTP tables. Disk was always the slowest part of the computer system. Since memory is abundant,...
CreateSpace Independent Publishing Platform, 2014. — 820 p. — ISBN10: 1499529597, ISBN13: 978-1499529593. SQL Server 2014 design & programming builds on achievements of decades in advanced relational database technology. Among the new SQL Server 2014 features is prominent: in-memory OLTP tables. Disk was always the slowest part of the computer system. Since memory is abundant,...
Редактор: Кондукова Екатерина — СПб.: BHV, 2015. — 592 с. — (В подлиннике). — ISBN: 978-5-9775-3492-5. Книга посвящена установке, настройке, администрированию и разработке баз данных с помощью СУБД SQL Server 2014. Рассмотрено создание базы данных и основных ее объектов: таблиц, индексов, представлений, хранимых процедур и функций, триггеров и др. Показана работа средств...
Комментарии