Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition
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 SQL Server's T-SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, JSON, and much more. Learn how to: Use T-SQL in the Microsoft SQL Server environment; Construct complex T-SQL statements using multiple clauses and operators; Filter data so you get the information you need quickly; Retrieve, sort, and format database contents; Join two or more related tables; Make SQL Server work for you with globalization and localization; Create subqueries to pinpoint your data; Automate your workload with triggers; Create and alter database t ...
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 SQL Server's T-SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, JSON, and much more. Learn how to: Use T-SQL in the Microsoft SQL Server environment; Construct complex T-SQL statements using multiple clauses and operators; Filter data so you get the information you need quickly; Retrieve, sort, and format database contents; Join two or more related tables; Make SQL Server work for you with globalization and localization; Create subqueries to pinpoint your data; Automate your workload with triggers; Create and alter database t ...
Pro SQL Server Wait Statistics
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 the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server's performance. ...
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 the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server's performance. ...
SQL Server 2017 Administration Inside Out
Dive into SQL Server 2017 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks - and challenge yourself to new levels of mastery. Install, customize, and use SQL Server 2017's key administration and development tools; Manage memory, storage, clustering, virtualization, and other components; Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations; Provision SQL Server and Azure SQL databases; Secure SQL Server via encryption, row-level security, and data mas ...
Dive into SQL Server 2017 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks - and challenge yourself to new levels of mastery. Install, customize, and use SQL Server 2017's key administration and development tools; Manage memory, storage, clustering, virtualization, and other components; Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations; Provision SQL Server and Azure SQL databases; Secure SQL Server via encryption, row-level security, and data mas ...
Exam Ref 70-765 Provisioning SQL Databases
Prepare for Microsoft Exam 70-765 - and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, 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: Implement SQL in Azure; Manage databases and instances; Manage storage. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills. ...
Prepare for Microsoft Exam 70-765 - and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, 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: Implement SQL in Azure; Manage databases and instances; Manage storage. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills. ...
SQL Server T-SQL Recipes, 4th Edition
SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, managing indexes, error handling, and query performance. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth descripti ...
SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, managing indexes, error handling, and query performance. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth descripti ...
Beginning DAX with Power BI
Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges. Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. Turbocharge your Power BI model by adding advanced DAX programming techniques; Know when to use calculated measures versus calculate ...
Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges. Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. Turbocharge your Power BI model by adding advanced DAX programming techniques; Know when to use calculated measures versus calculate ...
Oracle SQL Revealed
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle's power in implementing business logic, thereby maximizing return from your company's investment in Oracle Database products. Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace. This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. ...
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle's power in implementing business logic, thereby maximizing return from your company's investment in Oracle Database products. Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace. This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. ...
macOS High Sierra: The Missing Manual
With High Sierra, Apple has taken its macOS operating system to new heights. From Apple's efficient new file system to improved video streaming and support for virtual reality, this latest macOS version provides features improve your experience. And once again, David Pogue brings his humor and expertise to the #1 bestselling Mac book. Whether you're a developer or a home-user, this guide offers a wealth of detail on Apple's macOS 10.13 operating system, this new edition covers everything High Sierra has to offer. Perfect for newcomers: Get crystal-clear, jargon-free introductions to the best and brightest macOS apps, including Siri, Safari, iCloud, FaceTime, and AirDrop. Get the whole picture: Learn more efficient ways to navigate, organize, and edit your photos with new features in the Photos app. Go in-depth: Take advantage of Apple's new graphics technology, and its support for virtual reality. Gain real insight: David Pogue doesn't just tell you how to use macOS features. You ...
With High Sierra, Apple has taken its macOS operating system to new heights. From Apple's efficient new file system to improved video streaming and support for virtual reality, this latest macOS version provides features improve your experience. And once again, David Pogue brings his humor and expertise to the #1 bestselling Mac book. Whether you're a developer or a home-user, this guide offers a wealth of detail on Apple's macOS 10.13 operating system, this new edition covers everything High Sierra has to offer. Perfect for newcomers: Get crystal-clear, jargon-free introductions to the best and brightest macOS apps, including Siri, Safari, iCloud, FaceTime, and AirDrop. Get the whole picture: Learn more efficient ways to navigate, organize, and edit your photos with new features in the Photos app. Go in-depth: Take advantage of Apple's new graphics technology, and its support for virtual reality. Gain real insight: David Pogue doesn't just tell you how to use macOS features. You ...
Competing with High Quality Data
Data is rapidly becoming the powerhouse of industry, but low-quality data can actually put a company at a disadvantage. To be used effectively, data must accurately reflect the real-world scenario it represents, and it must be in a form that is usable and accessible. Quality data involves asking the right questions, targeting the correct parameters, and having an effective internal management, organization, and access system. It must be relevant, complete, and correct, while falling in line with pervasive regulatory oversight programs. Competing with High Quality Data takes a holistic approach to improving data quality, from collection to usage. ...
Data is rapidly becoming the powerhouse of industry, but low-quality data can actually put a company at a disadvantage. To be used effectively, data must accurately reflect the real-world scenario it represents, and it must be in a form that is usable and accessible. Quality data involves asking the right questions, targeting the correct parameters, and having an effective internal management, organization, and access system. It must be relevant, complete, and correct, while falling in line with pervasive regulatory oversight programs. Competing with High Quality Data takes a holistic approach to improving data quality, from collection to usage. ...
Create Web Charts with D3
Create Web Charts with D3 shows how to convert your data into eye-catching, innovative, animated, and highly interactive browser-based charts. This book is suitable for developers of all experience levels and needs: if you want power and control and need to create data visualization beyond traditional charts, then D3 is the JavaScript library for you. By the end of the book, you will have a good knowledge of all the elements needed to manage data from every possible source, from high-end scientific instruments to Arduino boards, from PHP SQL databases queries to simple HTML tables, and from Matlab calculations to reports in Excel. ...
Create Web Charts with D3 shows how to convert your data into eye-catching, innovative, animated, and highly interactive browser-based charts. This book is suitable for developers of all experience levels and needs: if you want power and control and need to create data visualization beyond traditional charts, then D3 is the JavaScript library for you. By the end of the book, you will have a good knowledge of all the elements needed to manage data from every possible source, from high-end scientific instruments to Arduino boards, from PHP SQL databases queries to simple HTML tables, and from Matlab calculations to reports in Excel. ...