MeetCoogle.com, 2017. — 129 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,...
Simple-Talk Publishing, 2011. — 142 p. Writing good TSQL code is not an easy task. Then you submit the code to the query optimizer and strange things happen. The one good view you have into what the optimizer decided to do is provided by the execution plans. Understanding execution plans is a lot of work. Trust me on that. What you need to really understand your queries is as...
BPB Publications, 2021. — 496 p. — ISBN 978-93-90684-410. This book brings exciting coverage on establishing and managing data virtualization using polybase. This book teaches how to configure polybase on almost all relational and nonrelational databases. You will learn to set up the test environment for any tool or software instantly without hassle. You will practice how to...
Apress, 2018. — 316 p. — ISBN: 9781484234556. Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as the reliability and manageability of restoring from backups. In today’s data-driven world, the most important asset that a company has...
Third Edition. — Microsoft Press, 2016. — 1361 p. — ISBN: 978-1-5093-0200-0. Effectively query and modify data using Transact-SQL Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQLs roots and...
4th Edition. — Microsoft Press/Pearson Education, 2023. — 608 p. — (Developer Reference). — 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...
2nd Edition. — Microsoft Press, 2020. — 352 p. — ISBN: 978-0135861448. 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 Ben-Gan introduces breakthrough techniques for using them to handle many common...
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....
Apress, 2018. — 392 p. — ISBN: 1484239008. Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development...
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...
Microsoft Press, 2017. — 288 p. — ISBN: 978-0071835978. Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data...
6th edition. — Apress, 2020. — 1154 p. — ISBN 1484264967. Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features....
Apress, 2016. — 976 p. — ISBN: 1484219724 Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an...
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...
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...
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...
Addison-Wesley Professional, 2008. — 512 p. — ISBN10: 032195162X; ISBN13: 978-0321951625. “What Kevvie Fowler has done here is truly amazing: He has defined, established, and documented SQL Server forensic methods and techniques, exposing readers to an entirely new area of forensics along the way. This fantastic book is a much needed and incredible contribution to the incident...
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...
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, 2018. — 320 p. Master SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop. SQL Server’s...
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, 2023. — 402. Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis...
Apress, 2017. — 111 p. — ISBN: 978-1484229392. Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. If you already have a license for SQL Server, then you do not need to spend...
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, 2021. - 406p. - ISBN : 1484264908 Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent response times in the face of variations in numbers of users and query volumes. In this new edition, with over 100 pages of additional content, every original chapter has been updated for SQL Server...
Apress, 2021. — 308 p. — ISBN 978-1-4842-7172-8. Learn about business intelligence (BI) features in T-SQL and how they can help you with data science and analytics efforts without the need to bring in other languages such as R and Python. This book shows you how to compute statistical measures using your existing skills in T-SQL. You will learn how to calculate descriptive...
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...
Simple-Talk Publishing, 2010. — 44 p. SQL Server Statistics. What they are, What can go wrong, and what to do about it. A description of SQL Server's distribution statistics, and what can go wrong. In a perfect world, we should just be able to write queries and leave the RDBMS to decide the perfect strategy to get the data. Until then we have to understand the Query Optimizer...
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...
Wiley, 2023. — 415 p. — (Wiley EDGE Tech Skills Series). — ISBN 978-1-394-18104-9. Готовый к заданию SQL: Изучите самые важные навыки SQL и применяйте их в своей работе быстро и эффективно! Learn the most important SQL skills and apply them in your job—quickly and efficiently! SQL (Structured Query Language) is the modern language that almost every relational database system...
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...
Комментарии