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.
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...
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...
Wiley, 2023. — 415 p. — (Wiley EDGE Tech Skills Series). — ISBN: 978-1-394-18104-9. 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 supports for adding data, retrieving data, and modifying data in a database. Although basic visual tools...
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...
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...
6th ed. — Apress, 2022. — 730 p. — ISBN: 1484288904. Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book...
Apress Media LLC, 2022. — 307 p. — ISBN13: 978-1-4842-8633-3. 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 Servers such as SQL Server Audit and Extended Events to track schema changes, permission changes, and changes to your data....
Springer, 2022. — 683 p. — ISBN: 3030926869. This textbook covers both fundamental and advanced Java database programming techniques for beginning and experienced students as well as programmers (courses related to database programming in Java with Apache NetBeans IDE 12 environment). A sample SQL Server 2019 Express database, CSE_DEPT, is created and implemented in all example...
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...
O’Reilly Media, 2022. — 500 p. — ISBN: 978-1-098-10192-3. 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, holistically troubleshoot the system, and properly prioritize tuning...
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...
Pearson Education, Inc., 2009. — 510 p. — 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 response and forensic...
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, 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...
4th ed. — Apress, 2020. — 706 p. — ISBN: 1484266056. Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the...
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...
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. — 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...
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...
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...
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...
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, 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, 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, 2020. — 236 p. — ISBN13: 978-1-4842-5580-3. 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 in current...
Learn Coding Fast, 2018. — 175 p. — (Learn Coding Fast with Hands-On Project. Book 5). — ISBN10: 1731039662. ISBN13: 9781731039668. Learn SQL (using MySQL) Fast and Learn It Well. Master SQL Programming with a unique Hands-On Project The information era is upon us and the ability to organize and make sense of data has become an invaluable skill. Have you been hearing about...
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, 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...
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...
Red Gate Books, 2011. — 370 p. — ISBN10: 1906434786; ISBN13: 978-1906434786. We spend much of our working life trying to help people solve SQL Server-related performance problems, either hands-on, during consulting, or on various online community forums. Over the years, we've been exposed to a few weird-and-wonderful SQL Server issues but, mainly, we've seen the same problems...
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, 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...
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...
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...
SimpleTalk Publishing, 2017. — 118 p. — ISBN: 978-1-910035-14-6. Although XML is conceptually simple, its use as an equal partner datatype within a relational database, with full searching, validation and manipulation of data, is not intuitive. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return...
Simple Talk Publishing, 2017. — 201 p. — ISBN: 978-1-910035-19-1. This book, SQL Server Internals: In-Memory OLTP is a true gem for modern data developers and data professionals. It contains an unprecedented level of details about the in-memory technology of SQL Server. In my many conversations with customers, I often hear a confusion between the terms "In-Memory" and...
Simple Talk Publishing, 2017. — 201 p. — ISBN: 978-1-910035-19-1. This book, SQL Server Internals: In-Memory OLTP is a true gem for modern data developers and data professionals. It contains an unprecedented level of details about the in-memory technology of SQL Server. In my many conversations with customers, I often hear a confusion between the terms "In-Memory" and...
Apress, 2018. — 354 p. Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and countermeasures, and provides an introduction to compliance that is useful for meeting regulatory requirements such as the GDPR. The multi-layered approach in this...
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...
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...
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...
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...
Apress, 2008. — 342 p. — (Pro). — ISBN10: 1590599675; ISBN13: 978-1590599679. This book explains how to implement an effective disaster recovery strategy for SQL Server 2005 and 2008 databases. It details powerful tools and features for data backup and disaster recovery present in SQL Server 2005 and enhanced in SQL Server 2008. Users of SQL Server 2000 will find that the...
CreateSpace Independent Publishing, 2018. — 146 p. — ISBN: 1720358672. Creating a full database application from scratch can be a challenge. You need to understand the basics of database design, as well as the specific Relational Database Management System (RDBMS) and its SQL. You need somehow to interface to this from your application which, by the way, you also need to...
CreateSpace Independent Publishing, 2018. — 146 p. — ISBN: 1720358672. Creating a full database application from scratch can be a challenge. You need to understand the basics of database design, as well as the specific Relational Database Management System (RDBMS) and its SQL. You need somehow to interface to this from your application which, by the way, you also need 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...
Second Edition. — Apress 2004. — 352 p. This book takes an in-depth look at what you can do to secure data in SQL Server, shows how to authenticate access to data on the server, and authorizes what users can and can't do with that data, in versions 6.5, 7.0, and 2000. A Security Roadmap Authenticating Logins Database Security in SQL Server 6.5 Database Security in SQL Server...
GoalKicker.com, 2018. — 285 p. The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective...
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...
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...
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...
Apress, 2018. — 289 p. Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of...
New York: Apress, 2017. — 484 p. Learn Business Intelligence Markup Language (Biml) for automating much of the repetitive, manual labor involved in data integration. We teach you how to build frameworks and use advanced Biml features to get more out of SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), and SQL Server Analysis Services (SSAS) than you ever thought...
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...
Second Edition. — Apress, 2017. — 314 p. — ISBN: 978-1-4842-2771-8. Take a deep dive into one of the most significant SQL Server features–support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, columnstore indexes and operational analytics, changes in programmability and native compilation, and more. This...
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...
MeetCoogle.com, 2017. — 137 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...
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...
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...
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...
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...
RonsNotes, 2017. - 63 p. - ASIN: B06X3W16YL This RonsNotes is designed to allow you to understand the tasks and challenges of creating user friendly mobile reports. Microsoft through its purchase of DataZen and the incorporating of it into SQL 2016 has positioned SQL 2016 at the forefront of Mobile Reports. How important are mobile reports to business users? A better question...
Simple Talk Publishing, 2012. — 487 p. — ISBN: 978-1-906434-88-5 A Quick Start Guide for developers and administrators. This book attempts to guide you, step-by-step, through every phase of FILESTREAM implementation, from enabling the feature, to creating FILESTREAM tables, to manipulating FILESTREAM data through the streaming APIs, to handling FILESTREAM data in simple ASP.NET...
Whitepaper. Published: Version 2.0 Revision 1 — October 10, 2011. This paper describes how to leverage the many-to-many dimension relationships, a feature that debuted available with Analysis Services 2005 and is now available by using DAX in the new BISM Tabular available in Analysis Services “Denali”. After introducing the main concepts, the paper discusses various...
2nd ed. — Apress, 2016. — 212 p. — ISBN: 978-1484223963. Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate...
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...
Apress, 2016. — 271 p. — ISBN: 978-1-4842-2297-3. Learn how to develop powerful data analytics applications quickly for SQL Server database administrators and developers. Organizations will be able to sift data and derive the business intelligence needed to drive business decisions and profit. The addition of R to SQL Server 2016 places a powerful analytical processor into an...
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...
Apress, 2016. — 173 p. — ISBN: 1484222644. Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that...
ZPL Concept, 2016. — 288 p. in color. — ASIN: B01LVWTR2I Learn SQL Server Intuitively is a complete, hands-on and practical guide to everything you will ever need to know about the basics of Microsoft SQL Server relational database management systems. From the basics, ideal for beginners with their own PC, through to more complex ideas for big business, Learn SQL Server...
Apress, 2016. — 223 p. — ISBN: 9781484220825 Learn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise environment. Pro SQL Server...
Apress, 2016. — 223 p. — ISBN10: 148422082X. — ISBN13: 978-1484220825 Learn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise...
Apress, 2016. — 297 p. — ISBN: 9781484219423 The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of...
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...
Syncfusion Inc, 2014. — 122 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...
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...
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...
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...
Apress, 2015. — Code Only. — 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...
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...
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...
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...
2nd Edition. — Apress, 2015. — Code Only. — 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...
Apress, 2015. - 168 p. Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter's Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime. Begin with an introduction to...
Simple Talk Publishing, 2014. — 296 p. For efficient team-based database development, and reliable and repeatable database deployments, going without source control isn’t really optional any more. Quite apart from making it easier to work together, roll back, and share changes, it’s the cornerstone of better change management and continuous integration. SQL Server Source...
Apress, 2015. — 416 p. — ISBN13: 978-1-484214-20-6. Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You’ll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server. Do you quake at the sight of a...
Apress, 2015. — 336 p. Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding of how wait statistics are generated and what they can mean for your SQL Server's performance. Besides...
Wiley-Interscience, 2006. — 320 p. — ISBN: 978-0-470-04828-3. A breakthrough sourcebook to the challenges and solutions for mobile database systems/ This text enables readers to effectively manage mobile database systems (MDS) and data dissemination via wireless channels. The author explores the mobile communication platform and analyzes its use in the development of a...
Course Technology PTL, 2002. — 520 p. With this book as your guide, you can progress from basic database design to the more advanced techniques of database communication in just one weekend. On Friday evening, start with the basics of SQL as you set up a sample database. On Saturday, practice database communications as you cover queries, the SELECT command, and relational...
Manning, 2014. — 258 p. — ISBN: 9781617292132 Microsoft SQL Server is used by millions of businesses, ranging in size from Fortune 500s to small shops worldwide. Whether you're just getting started as a DBA, supporting a SQL Server-driven application, or you've been drafted by your office as the SQL Server admin, you do not need a thousand-page book to get up and running. Learn...
Wiley, 2013. — 312 p. —ISBN: 111864719X, 9781118647196 Discover how to maintain and update balanced scorecards and performance dashboards with SQL Server Reporting Services Complementing the bestselling Balanced Scorecards and Operational Dashboards with Microsoft Excel (9780470386811), this indispensable book shows you how to create maintainable and dynamically updated...
Red Gate, 2012. — 220 p. — ISBN: 978-1-906434-94-6 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...
McGraw-Hill Osborne Media, 2000. — 510 p. — ISBN: 0072124105 Provides real-world information for database administrators to develop, manage, plan and implement a data protection solution. Coves advanced tools and technologies for increasing uptime and performance, including clustering, replication, stand-by servers and advanced backup and recovery. Also reviews related...
Red gate books, 2009. — 262 p. — ISBN10: 1906434271, ISBN13: 978-1906434274. 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...
7th Edition. — Addison Wesley Professional, 2006. — 1128 p. — (Best Practice Architectures and Examples). Since 1994 when he wrote his first Hitchhiker’s Guide, William Vaughn has been providing developers all over the world the intimate details of how SQL Server can be accessed and managed from RAD languages like Visual Basic and Visual Basic .NET. With the 7th Edition, Bill...
O’Reilly Media, 2002. — 302 p. — ISBN: 1-56592-756-7, 9780596552039. Table of Context: Pivot Tables. Using a Pivot Table. Sets. The Students Example. Implementing Set Difference. Comparing Two Sets for Equality. Implementing Partial Intersection. Implementing Full Intersection. Classifying Subsets. Summarizing Classes of Sets. Aggregating Aggregates. Summarizing Aggregated...
Syngress, 2011. - 250 p. - ISBN: 1597496251 There is a lot at stake for administrators taking care of servers, since they house sensitive data like credit cards, social security numbers, medical records, and much more. In Securing SQL Server you will learn about the potential attack vectors that can be used to break into your SQL Server database, and how to protect yourself...
Simple-Talk Publishing, 2010. — 43 p. — (DBA Handbooks series). — ISBN13: 9781906434618. Why should we be interested in SQL Server Statistics, when we just want to get data from a database? The answer is ‘performance’. The better the information that SQL Server has about the data in a database, the better its choices will be on how it executes the SQL. Statistics are its’ chief...
Red gate books, 2010. — 291 p. — ISBN10: 1906434492, ISBN13: 978-1906434496. Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to...
Comments