SQL Server

2nd Edition. — Microsoft Press, 2020. — 570 p. — ISBN: 978-0135861448. Use window functions to write simpler, better, more efficient T-SQL queries Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik...

2nd Edition. — Apress, 2015. — 432 p. — ISBN: 978-1-484211-19-9. Код примеров к книге выложен здесь. This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and...

O’Reilly Media, Inc., 2022. — 444 p. — ISBN 978-1-098-10186-2. This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly...

Apress, 2018. — 605 p. — ISBN13: 978-1-4842-4127-1. 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 inside look at how SQL Server for Linux works...

Manning Publications, 2025. — 408 р. — ISBN: 978-1633437401. All the mistakes you might make with SQL Server—and how to avoid them! 100 SQL Server Mistakes and How to Avoid Them prepares you for the pitfalls database professionals often encounter—from administration to development, availability, and security. You'll learn to sidestep common errors that slow down your T-SQL code...

Apress, 2015. — 1032 p. — ISBN13: 978-1-484207-11-6. Код примеров к книге выложен здесь. This book brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL...

Syncfusion Inc, 2014. — 136 p. Categories: Database The massive amount of data collected by businesses often creates a lot of work without doing much good. To make data work for them, businesses need solutions that summarize and organize it in ways that will influence the decisions they make each day. With SQL Server Analysis Services Succinctly by Stacia Misner, you will learn...

O’Reilly Media, Inc., 2013. — 983 p. Explore the core engine of Microsoft SQL Server 2012 — and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases — whether you’re a...

HiTeX Press, 2024. — 440 p. — ASIN: B0DDXVJVSG. Mastering SQL Server: From Basics to Expert Proficiency" is an essential resource for anyone looking to gain a comprehensive understanding of SQL Server. This meticulously crafted book takes readers on a journey from fundamental concepts to advanced techniques, ensuring they build a solid foundation before diving into more complex...

2nd Edition. — Apress, 2020. — 277 p. — ISBN13: (electronic): 978-1-4842-5985-6. Use this guide to one of SQL Server 2019’s most impactful features―Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will know how to use Big Data...

4th Edition. — Microsoft Press, 2023. — 608 p. — ISBN-13 978-0-13-810210-4. Query and modify data effectively with the latest T-SQL features. Master Transact-SQL’s fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. Long-time Microsoft...

Apress Media LLC, 2023. — 1068 p. — ISBN 13: 978-1-4842-8667-8. Learn window function foundational concepts through a cookbook-style approach, beginning with an introduction to the OVER() clause, its various configurations in terms of how partitions and window frames are created, and how data is sorted in the partition so that the window function can operate on the partition...

Apress, 2020. — 236 p. — ISBN13: (electronic): 978-1-4842-5581-0. Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported...

Apress Media LLC, 2022. — 307 р. — ISBN-13: 978-1-4842-8634-0. Track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows you how to use key features in SQL Server such as SQL Server Audit and Extended Events to track schema changes, permission changes, and changes to your data....

5th Edition. — Pearson Edacution Ins., 2020. — 438 p. — ISBN13: 978-0-13-518279-6. Sams Teach Yourself SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 22 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of the SQL language. Lessons cover IBM DB2, Microsoft SQL Server and SQL...

Packt Publishing, 2020. — 210 p. — ISBN: 978-1-83921-564-3. Learn to exploit vulnerable database applications using SQL injection tools and techniques, while understanding how to effectively prevent attacks SQL injection (SQLi) is probably the most infamous attack that can be unleashed against applications on the internet. SQL Injection Strategies is an end-to-end guide for...

Manning Publications, 2025. — 304 p. — ISBN-13: 978-1633438576. Use SQL to get the data you need in no time at all! Learn to read and write basic queries, troubleshoot common problems, and control your own business data in just 24 short lessons–no programming experience required! SQL has been designed to be as close to English as possible—anyone can learn it! Learn SQL in a...

Apress, 2020. — 411 p. — ISBN: 9781484262122. Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server Integration Services (SSIS). Bring all the power of Transact-SQL (T-SQL) and Microsoft .NET to bear on your repetitive data, data integration, and ETL processes. Do this for no added cost over what you’ve already...

Packt Publishing, 2019. — 527 p. — ISBN: 978-1-78934-881-1. Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Transact-SQL (T-SQL) is Microsoft’s proprietary extension to the SQL language that is used with Microsoft SQL Server and Azure SQL Database. This book will be a useful guide to learning the art of writing efficient...

Simple-Talk Publishing, 2009. — 268 p. For as long as there has been something to communicate between two persons there has been data. Today, vast volumes of it are gathered about almost every individual and business. It is the information that we provide when we sign up for an account at our favorite website, fill out a job application, or apply for a mortgage. These valuable,...

Apress, 2020. — 362 p. — ISBN13: (electronic): 978-1-4842-5826-2. Get introduced to the world of Docker containers from a SQL Server DBA’s perspective. This book explains container technology and how it can improve the deployment of your SQL Server databases without infrastructure lock-in. You will be equipped with the right technical skills to guide stakeholders in your...