{"title":"Louis Davidson","description":null,"products":[{"product_id":"exam-ref-70-762-developing-sql-databases-book-louis-davidson-9781509304912","title":"Exam Ref 70-762 Developing SQL Databases","description":"Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.       Focus on the expertise measured by these objectives:   • Design and implement database objects   • Implement programmability objects   • Manage database concurrency   • Optimize database objects and SQL infrastructure       This Microsoft Exam Ref:   • Organizes its coverage by exam objectives   • Features strategic, what-if scenarios to challenge you   • Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases       About the Exam   Exam 70-762 focuses on skills and knowledge for building and implementing databases across organizations and ensuring high levels of data availability.       About Microsoft Certification   Passing this exam earns you credit toward a Microsoft Certified Solutions Associate   (MCSA) certification that demonstrates your mastery of modern database   development. Exam 70-761 (Querying Data with Transact-SQL) is also required for MCSA: SQL 2016 Database Development. See full details at: microsoft.com\/learning","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49551917252881,"sku":"CIN1509304916G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49571019194641,"sku":"GOR009650941","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50671261647121,"sku":"GOR013445667","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51330625667345,"sku":"CIN1509304916VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1509304916.jpg?v=1751242847"},{"product_id":"pro-sql-server-relational-database-design-and-implementation-book-louis-davidson-9781484264966","title":"Pro SQL Server Relational Database Design and Implementation","description":"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. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations.  Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to \"getit right\" in SQL Server database design and lay a solid groundwork for the future use of valuable business data.  What You Will Learn  Develop conceptual models of client data using interviews and client documentation Implement designs that work on premises, in the cloud, or in a hybrid approach Recognize and apply common database design patterns Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Understand the concepts of concurrency    Who This Book Is For Programmers and database administrators of all types who want to use SQL Server to store transactional data. The book is especially useful to those wanting to learn the latest database design features in SQL Server 2019 (features that include graph objects, in-memory OLTP, temporal data support, and more). Chapters on fundamental concepts, the language of database modeling, SQL implementation, and the normalization process lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2019.","brand":"WoB","offers":[{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49577896280337,"sku":"GOR012491039","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ GARDNERS","offer_id":49795100999953,"sku":"NGR9781484264966","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51029346582801,"sku":"NIN9781484264966","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":51332427710737,"sku":"CIN1484264967G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1484264967.jpg?v=1751053461"},{"product_id":"pro-sql-server-2008-relational-database-design-and-implementation-book-louis-davidson-9781430208662","title":"Pro SQL Server 2008 Relational Database Design and Implementation","description":"Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data.        Solid foundation in best practices and relational theory  Maximize SQL Server features to enhance security, performance, scalability  Thorough treatment from conceptual design to an effective, physical implementation","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49591825269009,"sku":"GOR005690674","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52422670385425,"sku":"NLS9781430208662","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/143020866X.jpg?v=1751424621"},{"product_id":"pro-sql-server-2012-relational-database-design-and-implementation-book-louis-davidson-9781430236955","title":"Pro SQL Server 2012 Relational Database Design and Implementation","description":"Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to \"get it right\" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. * Gives a solid foundation in best practices and relational theory * Covers the latest implementation features in SQL Server * Takes you from conceptual design to an effective, physical implementation What you'll learn * How to develop conceptual models of client data using interviews and client documentation * How to recognize and apply common database design patterns * How to normalize data models to enhance scalability and the long term use of valuable data * How to translate conceptual models into high--performing SQL Server databases * How to secure and protect data integrity as part of meeting regulatory requirements * How to create effective indexing to speed query performance Who this book is for Pro SQL Server 2012 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2012 to store data. Chapters on fundamental concepts, the language of database modeling, SQL implementation, and of course, the normalization process, lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the very latest in physical implementation features that SQL Server has to offer. Table of Contents * The Fundamentals * Introduction to Requirements * The Language of Data Modeling * Initial Data Model Production * Normalization * Physical Model Implementation Case Study * Data Protection with Check Constraints and Triggers * Patterns and Anti-Patterns * Table structures and Indexing * Coding for Concurrency * Reusable Standard Database Components * Standardized Data Models * Considering Data Access Strategies * Reporting Design * Appendix A * Appendix B","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49761426669841,"sku":"CIN1430236957G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1430236957.jpg?v=1751019296"},{"product_id":"dynamic-management-views-book-louis-davidson-9781906434472","title":"Dynamic Management Views","description":"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. Why, then, aren't all DBAs using them? Why do many DBAs continue to ignore them in favour of tried and trusted tools such as sp_who2, DBCC OPENTRAN, and so on, or make do with the ready made reports built into SSMS? Why do even those that do use the DMVs speak wistfully about good old sysprocesses? There seem to be two main factors at work. Firstly, some DBAs are simply unaware of the depth and breadth of the information that is available from the DMvs, or how it might help them troubleshoot common issues. This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system. Secondly, the DMVs have a reputation of being difficult to use. In the process of exposing as much useful data as possible, sysprocesses has been de-normalized, and many new views and columns have been added. This fact, coupled with the initially-baffling choices of what columns will be exposed where, has lead to some DBAs to liken querying DMVs to collecting mystic spells. In fact, however, once you start to write your own scripts, you'll see the same tricks, and similar join patterns, being used time and again. As such, a relatively small core set of scripts can be readily adapted to suit any requirement. This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and patterns that you need to master, and will provide a core set of scripts that you can use and adapt for your own systems, including how to: * Root out the queries that are causing memory or CPU pressure on your system * Investigate caching, and query plan reuse * Identify index usage patterns * Track fragmentation in clustered indexes and heaps * Get full details on blocking and blocked transactions, including the exact commands being executed, and by whom. * Find out where SQL Server is spending time waiting for resources to be released, before proceeding * Monitor usage and growth of tempdb The DMVs don't make existing, built-in, performance tools obsolete. On the contrary, they complement these tools, and offer a flexibility, richness and granularity that are simply not available elsewhere. Furthermore, you don't need to master a new GUI, or a new language in order to use them; it's all done in a language all DBAs know and mostly love: T-SQL.","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49789403169041,"sku":"CIN1906434476G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49797177508113,"sku":"GOR007725267","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50270243029265,"sku":"CIN1906434476VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":50907361181969,"sku":"GOR014118280","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":51055128641809,"sku":"NIN9781906434472","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52453538136337,"sku":"NLS9781906434472","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1906434476.jpg?v=1751124659"},{"product_id":"sql-server-2000-stored-procedure-handbook-book-louis-davidson-9781861008251","title":"SQL Server 2000 Stored Procedure Handbook","description":null,"brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50393312624913,"sku":"CIN1861008252G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1861008252.jpg?v=1750964384"},{"product_id":"practical-graph-structures-in-sql-server-and-azure-sql-book-louis-davidson-9781484294581","title":"Practical Graph Structures in SQL Server and Azure SQL","description":"Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data that go beyond classic relationships.   The graph examples in the book are useful for analyzing social media relationships, complex product-to-customer relationships, and any other type of data analysis in which indirect connections that otherwise might be missed using conventional techniques can be mined for their insight and business value.      Tree structures are covered, with emphasis on a structure commonly used by organizations to aggregate data at different levels of an organization. The book provides code examples of SQL Graph objects as well as an alternate tree implementation technique. Included is sample data (and data generators) for you to test for performance and choose the implementation approach that best suits your needs and that of your application.     If your job involves analyzing or storage of data elements that are connected in a networked topology, then this is the book that will help you bring the power of SQL Server to bear on that data and take advantage of your existing knowledge.     What You Will Learn  Understand the graph model and the associated terms used in graph analysis  Store highly connected data in SQL Server and Azure SQL alongside existing relational data Make full use of the graph table feature that is refined and enhanced in SQL Server 2019 Implement high performance tree structures that will make storing and querying tree data possible Report on data associated with a tree structure to aggregate results at different levels    Who This Book Is For","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":51029228847377,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":51029233795345,"sku":"NIN9781484294581","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52688400154897,"sku":"NLS9781484294581","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1484294580.jpg?v=1751273716"},{"product_id":"pro-sql-server-2000-database-design-book-louis-davidson-9781590593028","title":"Pro SQL Server 2000 Database Design","description":"Database design is one of the most contentious issues in computer science. There is always a delicate balance to be struck between the strict academic rules that govern the design of relational databases and the real-world techniques that programmers apply to get the job done in a certain time frame. This book's goal is to coverfrom a \"real-world\" point of viewall of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.    Author Louis Davidson explains the process of implementing a database—from generating tables and allowing access to these tables using Microsoft SQL Server 2000. This includes tackling data modeling (focusing on the IDEF1X notation), requirements gathering, normalization (beyond the Third Normal Form), and implementing tables, constraints, triggers, procedures, user-defined functions, and so on. Davidson provides a full and realistic case study that clearly illustrates the entire process, from the initial discussions of a client's needs, through development of a logical model, to a complete implementation of the system.","brand":"WoB","offers":[{"title":"GB \/ NEW \/ INGRAM","offer_id":52135232667921,"sku":"NLS9781590593028","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":52858962116881,"sku":"NIN9781590593028","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9781590593028.jpg?v=1757547953"},{"product_id":"pro-sql-server-2000-database-design-book-louis-davidson-9781430253303","title":"Pro SQL Server 2000 Database Design","description":null,"brand":"WoB","offers":[{"title":"GB \/ NEW \/ INGRAM","offer_id":52667258732817,"sku":"NLS9781430253303","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9781430253303.jpg?v=1762282096"}],"url":"https:\/\/www.worldofbooks.com\/en-ie\/collections\/author-books-by-louis-davidson.oembed","provider":"World of Books ","version":"1.0","type":"link"}