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...
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 of 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 understand your queries is as much...
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. — ISBN-13 (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, 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 p. — 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...
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 Server, including Columnstore indexes and...
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...
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 further into the book, you will look...
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 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, 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...
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,...
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...
Comments