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…

PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies

PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies

Get the basics on four key web programming tools in one great book! PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management….

SQL Server 2017 Query Performance Tuning, 5th Edition

SQL Server 2017 Query Performance Tuning, 5th Edition

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them….

SQL for IBM i

SQL for IBM i

This book aims to give IBM i technical users basic to intermediate SQL knowledge and tools they can use to get more out of the IBM i database. The book can be useful to veteran IBM i programmers, who have RPG and COBOL roots, system administrators looking to…