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...
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...
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...
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...
2nd. ed. - Birmingham: Packt Publishing, 2024. - 450 p. - ISBN: 1837638993. Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers. Key Features A definitive guide to mastering the techniques of writing efficient T-SQL code. Learn query optimization fundamentals, query analysis, and how...
2nd Edition - Simple-Talk Publishing, 2012. — 332 p. Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: - Which indexes are being used, and where no indexes are being used at all. - How the data is being retrieved, and joined, from the tables...
Simple-Talk Publishing, 2010. — 302 p. The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads and survives predictable changes to database schemas and settings. Inside...
Simple-Talk Publishing, 2011. — 265 p. The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high-performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly complex result of decades of research, learning how it works its magic is not...
Simple-Talk Publishing, 2013. — 209 p. When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log,...
Simple-Talk Publishing, 2009. — 492 p. This book will help you learn and use XML Schema collections in SQL Server. Prior knowledge of XSD is not required to start with this book, although any experience with XSD will make your learning process easier. This book starts with the basics of XML schemas and then walks you through everything you need to know, with examples and labs,...
Simple-Talk Publishing, 2011. — 142. 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...
Simple-Talk Publishing, 2011. — 79 p. Relational databases place heavy demands on their underlying hardware and many of these databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server...
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, 2023. — 402 p. 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. 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 an...
Simple-Talk Publishing, 2009. — 91 p. As a developer, DBA, or manager, you may not want to know all about XML, replication, or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is from the ‘jungle roof’. Crib Sheets aim to give you a broad view. Each one tackles a key area of database development,...
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...
Simple-Talk Publishing, 2009. — 232 p. For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain. During such...
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...
Simple Talk Publishing, 2012. — 391 p. The duties and responsibilities: s of a Database Administrator (DBA) make for a long and dynamically changing list, ranging from offering query tuning advice to cutting stored procedures, all the way through to system process design and implementation for high availability. A DBA's tasks, from day to day, are rarely constant; with one...
Simple Talk Publishing, 2013. — 356 p. Jonathan Kehayias, Gail Shaw, and Ted Krueger provide a fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views, and server-side tracing. The focus of 'Troubleshooting SQL Server' is on practical solutions for removing root...
Manning Publications, 2009. — 852 p. SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you'll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or...
Simple Talk Publishing, 2010. — 326 p. Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA’s troubleshooting armory, laying bare previously unavailable information regarding the under-the-cover activity of your database sessions and transactions.
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...
Red Gate Books, 2013. — 202 p. This book explores how SQL Server uses locks to avoid concurrency problems, and advice on the to control locking with hints and bound connections. It also walks you through how row versioning works, and how to troubleshoot excessive blocking and deadlocking.
Simple Talk Publishing, 2009. — 372 p. SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and take full advantage of its potential for troubleshooting SQL Server problems. All the...
Packt, 2020. - 475p. - ISBN: 9781800204768. Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services and create models to support your business. Key Features Explore tips and tricks to design, develop, and optimize end-to-end data analytics solutions using Microsoft's technologies. Learn tabular modeling and multi-dimensional cube design...
Wiley, 2004 - 620 p. - ISBN: 0-7645-6878-7. SQL Server Reporting Services is a serious reporting platform that delivers real business intelligence to knowledge workers and business decision-makers. It can render reports in many different formats and also execute those reports on demand, cache, archive, or automatically deliver them to users. Whether you need reports to extend a...
Wiley 2013 - 532 p. - ISBN: 978-1-118-47958-2. if you’ve picked up this book, Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer, you’ve decided to learn one of SQL Server’s most exciting applications, SQL Server Integration Services (SSIS). SSIS is a platform to move data from nearly any data source to nearly any destination and helps you by orchestrating...
LeMaire Chrissy, Sewell Robl, Pomfret Jess, Silva Cláudio. — Manning Publications Co., 2022. — 401 p. — ISBN: 978-1617296703. An effective DBA is an efficient DBA. And if you work with SQL Server, dbatools is a lifesaver. With over 500 commands, this free and open-source PowerShell module has the horsepower to automate just about every task you can imagine — and then some!...
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, 2023. — 1068 p. — ISBN: 1484286677. 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 data sets. You will...
Boca Raton: CRC Press, 2023. — 670 p. — ISBN: 1032334770. Databases have become an integral part of modern-day life. We live in an information-driven society and database technology has a direct impact on our daily lives. Decisions are routinely made by organizations based on the information collected and stored in the databases. Because databases play such an important role in...
Microsoft Press/Pearson Education, 2023. — 1953 p. Conquer SQL Server 2022 and Azure SQL administration from the inside out! Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure...