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,...
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,...
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 language,...
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 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...
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...
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...
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...
Wiley – IEEE Press, 2020. — 678 p. — ISBN: 978-1-119-60860-8. A guide to the practical issues and applications in database programming with updated Visual Basic.NET This book offers a guide to the fundamental knowledge and practical techniques for the design and creation of professional database programs that can be used for real-world commercial and industrial applications....
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...
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...
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, 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, 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. — 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...
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...
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...
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...
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 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 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: 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...
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, 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, 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, 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...
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-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 Server such as SQL Server Audit and Extended Events to track schema changes, permission changes, and changes to your data....
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 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 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, 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...
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...
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...
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...
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, 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, 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...
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...
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...
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...
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...
Apress, 2015. — Code Only. — ISBN13: 978-1-484207-11-6. Код примеров к выложенной здесь книге в формате PDF, EPUB, MOBI. 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...
Apress, 2015. - 168p.
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...
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...
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...
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...
Microsoft Corp., 2012. — 317 p. The Data Analysis Expressions (DAX) language is a library of functions and operators that can be combined to build formulas and expressions.
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....
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...
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-covers activity of your database sessions and transactions.
RonsNotes, 2017. - 63p. - 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 is...
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...
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,...
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....
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...
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...
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, 2017. — 201 р. — 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 р. — 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...
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...
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...
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...
2nd edition. — Sams Publishing, 2016. — 368 p. — (Sams Teach Yourself). — ISBN10: 0672337924; ISBN13: 978-0672337925. 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 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Microsoft...
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...
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...
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...
Pearson Education, Inc., 2009. — 510 p. — ISBN-13 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...
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 you 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 the broad view. Each one tackles a key area of database development,...
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...
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...
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...
2nd Edition. — Apress, 2015. — Code Only. — ISBN: 978-1-484211-19-9. Код примеров к выложенной здесь книге в формате PDF, EPUB, MOBI. 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....
3rd Edition. — Redgate Publishing, 2018. — 515 р. — ISBN: 978-1-910035-22-1. Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or...
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...
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...
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...
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...
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...
Packt Publishing, 2020. — 210 p. — ISBN: 978-1-83921-564-3. Code files only! 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...
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...
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...
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...
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...
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, 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...
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....
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...
Simple Talk Publishing, 2013. — 356 p. Jonathan Kehayias, Gail Shaw and Ted Krueger provide 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 'Troublshooting SQL Server' is on practical solutions for removing root...
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...
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, 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, 2014. — 776 p. Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work "under the hood," and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers.
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, 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, 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, troubleshoot the system in a holistic fashion, and properly...
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...
Red gate books, 2010. — 291 p. — ISBN-10: 1906434492, ISBN-13: 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...
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....
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...
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...
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. 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...
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...
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! Written...
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! Written...
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, 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...
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, 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...
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...
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...
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...
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...
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...
Packt Publishing, 2019. — 474 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...
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...
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...
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...
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...
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,...
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, 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...
Simple Talk Publishing, 2012. — 391 p. The duties and responsibilitie: s of a Database Administrator (DBA) make for 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...
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...
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...
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...
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...
Apress, 2021. — 406 p. — 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. - 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, 2016. — 213 p. — ISBN10: 1484222709. — ISBN13: 978-1484222706. Covers SQL Server instance-configuration for optimal performance Helps in configuring for virtualized environments such as VMWare Provides guidance toward monitoring and ongoing diagnostics Design and configure SQL Server instances and databases in support of high-throughput applications that are...
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...
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...
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...
Whitepaper, available at http://www.sqlbi.com. 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...
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, 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: 978-1-4842-5825-5. 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 business as they...
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...
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...
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. — 43 p. — (DBA Handbooks series). — ISBN-13: 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’...
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, 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. — 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...
Simple Talk Publishing, 2013. — 512 p. This book guides you through every phase of SQL Server FILESTREAM implementation, from enabling the feature to creating FILESTREAM tables, to manipulating FILESTREAM data through the streaming APIs. It also covers administration and troubleshooting of FILESTREAM databases and tables.
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, 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...
SimpleTalk Publishing, 2017. — 118 р. — 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...
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...
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...
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...
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...
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...
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...
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...
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...
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: 978-1-4842-5984-9. 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 Clusters to...
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...
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...
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...
Учебно-методическое пособие. — М.: Российский университет транспорта РУТ (МИИТ). 2020. — 31 с. В данном издании приведены краткие сведения об операторах MS SQL Server, необходимых для фильтрации данных. Это пособие является первым в серии, посвященной операторам SQL, необходимым для выполнения лабораторных работ по дисциплинам «Информационное обеспечение систем управления» для...
Москва: Русская редакция, 2003. — 400 с. — ISBN 5-7502-0234-8. Альманах представляет собой тематический сборник статей из журнала MSDN Magazine / Русская Редакция и Microsoft MSDN Library. Издание адресовано широкому кругу программистов, интересующихся современными и перспективными информационными технологиями. Первый том альманаха, посвященный работе с базами данных, состоит из...
Учебное пособие. - М.:МИФИ, 2009.-105с. Данное учебное пособие не является учебником по SQL и PL/SQL Oracle. Цель пособия – представить студентам образец выполнения лабораторных работ с тем, чтобы в соответствии с этим образцом они выполняли лабораторные работы на выдаваемой преподавателем другой предметной области, для каждого студента группы – отдельной, не совпадающей с...
Омск: ОмГТУ, 2015. — 136 с. — ISBN 978-5-8149-1923-6. Описана практическая работа с СУБД Microsoft SQL Server средствами языка Transact-SQL. Рассмотрен процесс создания и использования реляционной базы данных, включая реализацию запросов, представлений, транзакций, хранимых процедур, триггеров и курсоров. Предназначено для студентов, обучающихся по направлениям 09.03.01...
Пер. с англ. — М.: Вильямс, 2006. — 1056 с. Рассматривается весь состав программных средств, лежащих в основе SQL Server и показано, как работают и взаимодействуют ее многочисленные компоненты. В книге принят комплексный подход к изложению сведений по архитектуре, внутренней организации и настройке SQL Server, дополняющих существующие справочные руководства и официальную...
СПб.: Питер, 2005. — 560 с. — (Для профессионалов). —ISBN: 5-469-00257-8.
Книга предназначена для программистов. Она написана, чтобы помочь разработчикам создавать приложения, в которых используется Transact-SQL и посвящена разработке высококачественного Transact-SQL-кода независимо от того, для каких приложений он создается. В этой книге широко используются примеры баз данных...
М.: АСУ-61, 2019. — 772 с.: ил. Рассматриваются синтаксис и примеры использования конструкций языка Transact SQL при построении запросов к данным и написании программ в среде СУБД Micriosoft SQL Server. Издание будет полезно администраторам и разработчикам приложений баз данных, системным аналитикам и интеграторам, специалистам по анализу данных, студентам и преподавателям по...
Комментарии