Pro SQL Server 2019 Administration, 2nd Edition

Pro SQL Server 2019 Administration, 2nd Edition

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new…

SQL Server 2019 Revealed

SQL Server 2019 Revealed

Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine learning (ML), big data analytics, Linux, containers, Kubernetes, Java, and data virtualization to Azure. This is not a book on…

Query Store for SQL Server 2019

Query Store for SQL Server 2019

Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server. Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to…

Pro SQL Server 2019 Wait Statistics

Pro SQL Server 2019 Wait Statistics, 2nd Edition

Here is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Learn to identify precisely why your queries are running slowly. Measure the amount of time consumed by each bottleneck so that you can focus attention on making the largest improvements first. This edition…

SQL For Dummies, 6th Edition

SQL For Dummies, 6th Edition

See how SQL interfaces with today’s environments Start building and using relational databases with SQL’s newest features The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through…

Microsoft SQL Server 2008, Second Edition

Microsoft SQL Server 2008, Second Edition

From the author and series editor of the immensely popular ADMINISTRATOR’S POCKET CONSULTANT series from Microsoft Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals. Microsoft® SQL Server® 2008 Administrator’s Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you’ll want with you…

Dynamic SQL

Dynamic SQL, 2nd Edition

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have…

Effective MySQL Replication Techniques in Depth

Effective MySQL Replication Techniques in Depth

Publisher’s Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. The Essential Guide to Scaling Your Business Solution Written by Oracle ACE Director and MySQL expert Ronald Bradford, with coauthor Chris Schneider, Effective…

SQL For Dummies, 9th Edition

SQL For Dummies, 9th Edition

Get ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working…

Pro SQL Server on Linux

Pro SQL Server on Linux

Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an…