SQL Server

MeetCoogle.com, 2017. — 126 p. — (SQL Server Tips and Tricks). — ASIN B07193FQ3N. SQL Server - Tips and Tricks book has solutions of some real time SQL Server problems that a developer face in most of the real time projects. All solutions are written with best practices and comes with complete to-the-point description and source code. You know the basics of the SQL query language,...

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...

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...

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...

Amazon Digital Services LLC, 2017. — 103 p. — ASIN B077SNZLK3. This book is all about the SELECT statement, which is often tested in job interviews. It is made up of SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We'll look at when you would use each, and how to remember the order of these clauses. We'll then look at how you can retrieve SELECT statements, saving them as...

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....

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...

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...

Sams Publishing, 2016. — 368 p. — ISBN13: 978-0672337925. This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 30...

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...

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, 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...

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...

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...

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...

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...