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 ...
Windows PowerShell in Action, 3rd Edition
In 2006, Windows PowerShell reinvented the way administrators and developers interact with Windows. Today, PowerShell is required knowledge for Windows admins and devs. This powerful, dynamic language provides command-line control of the Windows OS and most Windows servers, such as Exchange and SCCM. And because it's a first-class .NET language, you can build amazing shell scripts and tools without reaching for VB or C#. Windows PowerShell in Action, 3rd Edition is an end-to-end revision of the definitive guide to PowerShell. Written by language designer Bruce Payette and MVP Richard Siddaway, this rich book offers a crystal-clear introduction to the language along with its essential everyday use cases. Beyond the basics, you'll find detailed examples on deep topics like performance, module architecture, and parallel execution. ...
In 2006, Windows PowerShell reinvented the way administrators and developers interact with Windows. Today, PowerShell is required knowledge for Windows admins and devs. This powerful, dynamic language provides command-line control of the Windows OS and most Windows servers, such as Exchange and SCCM. And because it's a first-class .NET language, you can build amazing shell scripts and tools without reaching for VB or C#. Windows PowerShell in Action, 3rd Edition is an end-to-end revision of the definitive guide to PowerShell. Written by language designer Bruce Payette and MVP Richard Siddaway, this rich book offers a crystal-clear introduction to the language along with its essential everyday use cases. Beyond the basics, you'll find detailed examples on deep topics like performance, module architecture, and parallel execution. ...
SQL Queries for Mere Mortals, 4th Edition
SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think "outside the box". In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all y ...
SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think "outside the box". In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all y ...
Oracle WebLogic Server 12c Administration | Exam 1Z0-133
Use this comprehensive guide to study for the Oracle WebLogic Server 12c Administration I Exam 1Z0-133. This book is a unique introductory resource to the WebLogic Server certification for new Oracle Fusion Middleware administrators and a valuable resource for veteran WebLogic Server administrators seeking to update their skills for the 12c certification topics. It is common sense that passing a certification exam requires a good command of the subject matter, understanding the intricacies surrounding its practice, and having sufficient experience working with the concepts. This book aims to accelerate the process by providing an accurate review of all exam topics, suggesting hands-on practices to gain or reinforce experience working with WebLogic Server, and introducing questions to help candidates become familiar with the format and style of questions found on the actual certification exam. Oracle WebLogic Server 12c Administration I Exam 1Z0-133 covers the associate level cert ...
Use this comprehensive guide to study for the Oracle WebLogic Server 12c Administration I Exam 1Z0-133. This book is a unique introductory resource to the WebLogic Server certification for new Oracle Fusion Middleware administrators and a valuable resource for veteran WebLogic Server administrators seeking to update their skills for the 12c certification topics. It is common sense that passing a certification exam requires a good command of the subject matter, understanding the intricacies surrounding its practice, and having sufficient experience working with the concepts. This book aims to accelerate the process by providing an accurate review of all exam topics, suggesting hands-on practices to gain or reinforce experience working with WebLogic Server, and introducing questions to help candidates become familiar with the format and style of questions found on the actual certification exam. Oracle WebLogic Server 12c Administration I Exam 1Z0-133 covers the associate level cert ...
Quicken for Windows, Eighth Edition
Take control of your personal finances using the best practices and time-saving tips in Quicken 2018 for Windows The Official Guide! Find out the most effective methods for tracking your income, expenses, savings, transactions, investments, and so much more. Endorsed by the makers of Quicken, this practical resource shows you, step by step, how to take full advantage of the software's powerful features, including the Quicken mobile app. You'll also get professional advice to help you reduce debt, stay on budget, save money, invest wisely, and plan for a secure financial future. Customize Quicken for your preferences; Track income and expenses; Automate transactions and tasks; Record bank and credit card transactions; Use online banking features; Reconcile checking, savings, and credit card accounts; Track investments and optimize your portfolio; Monitor your assets, loans, and net worth; Evaluate your financial position; Reduce debt, save money, and plan for retirement; Simplify ...
Take control of your personal finances using the best practices and time-saving tips in Quicken 2018 for Windows The Official Guide! Find out the most effective methods for tracking your income, expenses, savings, transactions, investments, and so much more. Endorsed by the makers of Quicken, this practical resource shows you, step by step, how to take full advantage of the software's powerful features, including the Quicken mobile app. You'll also get professional advice to help you reduce debt, stay on budget, save money, invest wisely, and plan for a secure financial future. Customize Quicken for your preferences; Track income and expenses; Automate transactions and tasks; Record bank and credit card transactions; Use online banking features; Reconcile checking, savings, and credit card accounts; Track investments and optimize your portfolio; Monitor your assets, loans, and net worth; Evaluate your financial position; Reduce debt, save money, and plan for retirement; Simplify ...
Windows 10 Development with XAML and C# 7, 2nd Edition
Benefit from a nuts-and-bolts examination of how XAML and C# 7 fit together and obtain a foundation for getting up and running with Windows 10. Once you have a good understanding of the basics, you progress to more advanced topics steadily increasing your understanding as a whole. This holistic knowledge is essential to get the most out of Windows 10 development. Each topic is covered clearly and concisely and is packed with the details you need to code effectively. The most important features are given a no-nonsense, in-depth treatment and chapters contain examples that demonstrate both the power and the subtlety of Windows 10. Windows 10 Development with XAML and C# 7 focuses on the features that you need for your project and brings your existing C# coding knowledge to bear. ...
Benefit from a nuts-and-bolts examination of how XAML and C# 7 fit together and obtain a foundation for getting up and running with Windows 10. Once you have a good understanding of the basics, you progress to more advanced topics steadily increasing your understanding as a whole. This holistic knowledge is essential to get the most out of Windows 10 development. Each topic is covered clearly and concisely and is packed with the details you need to code effectively. The most important features are given a no-nonsense, in-depth treatment and chapters contain examples that demonstrate both the power and the subtlety of Windows 10. Windows 10 Development with XAML and C# 7 focuses on the features that you need for your project and brings your existing C# coding knowledge to bear. ...
Windows 10 Plain & Simple, 2nd Edition
Navigate Windows 10 Fall Creators Update quickly, easily, and efficiently; Get online with the sleek Microsoft Edge web browser; Make the most of the Cortana personal assistant; Efficiently manage your email, calendar, photos, and more; Access your files from anywhere with Microsoft OneDrive; Help secure your computer and protect your data. Jump in wherever you need answers; Follow easy steps and screenshots to see exactly what to do; Get handy tips for new techniques and shortcuts; Use Try This! exercises to apply what you learn right away. ...
Navigate Windows 10 Fall Creators Update quickly, easily, and efficiently; Get online with the sleek Microsoft Edge web browser; Make the most of the Cortana personal assistant; Efficiently manage your email, calendar, photos, and more; Access your files from anywhere with Microsoft OneDrive; Help secure your computer and protect your data. Jump in wherever you need answers; Follow easy steps and screenshots to see exactly what to do; Get handy tips for new techniques and shortcuts; Use Try This! exercises to apply what you learn right away. ...
Pro PowerShell Desired State Configuration, 2nd Edition
Use Windows PowerShell Desired State Configuration (DSC) to configure your infrastructure on-premises and in the cloud. In an environment where changes and deployments are happening all the time, DSC makes the necessary adjustments to the system so you don't have to. Pro Desired State Configuration shows you how. PowerShell Desired State Configuration (DSC) is a powerful configuration management platform that makes it easier than ever to perform configuration management of your infrastructure, whether on-premises or in the cloud. With Pro PowerShell Desired State Configuration, Ravikanth Chaganti revises and significantly expands his previous edition, bringing you a complete in-depth reference for applying this evolving technology in your day-to-day work. Get up-to-date, in-depth guidance on DSC in the data center; Understand the central role that DSC plays in DevOps today; Understand how DSC can be integrated into build and release management tools; Learn to think and act like a ...
Use Windows PowerShell Desired State Configuration (DSC) to configure your infrastructure on-premises and in the cloud. In an environment where changes and deployments are happening all the time, DSC makes the necessary adjustments to the system so you don't have to. Pro Desired State Configuration shows you how. PowerShell Desired State Configuration (DSC) is a powerful configuration management platform that makes it easier than ever to perform configuration management of your infrastructure, whether on-premises or in the cloud. With Pro PowerShell Desired State Configuration, Ravikanth Chaganti revises and significantly expands his previous edition, bringing you a complete in-depth reference for applying this evolving technology in your day-to-day work. Get up-to-date, in-depth guidance on DSC in the data center; Understand the central role that DSC plays in DevOps today; Understand how DSC can be integrated into build and release management tools; Learn to think and act like a ...
Node Cookbook, 2nd Edition
Node Cookbook Second Edition shows you how to transfer your JavaScript skills to server-side programming. It will talk you through the various server-side scenarios, often saving you time and effort by demonstrating best practices and showing you how to avoid security faux pas. Beginning with making your own web server, the recipes are designed to allow smooth progression through Node in order to help you design full web applications, command-line applications, and Node modules. There's also extensive coverage on using popular frameworks such as Express 4 and Socket.IO, writing your own Node modules and different ways to take your apps live. ...
Node Cookbook Second Edition shows you how to transfer your JavaScript skills to server-side programming. It will talk you through the various server-side scenarios, often saving you time and effort by demonstrating best practices and showing you how to avoid security faux pas. Beginning with making your own web server, the recipes are designed to allow smooth progression through Node in order to help you design full web applications, command-line applications, and Node modules. There's also extensive coverage on using popular frameworks such as Express 4 and Socket.IO, writing your own Node modules and different ways to take your apps live. ...
Pro Microsoft HDInsight
Pro Microsoft HDInsight is a complete guide to deploying and using Apache Hadoop on the Microsoft Windows Azure Platforms. The information in this book enables you to process enormous volumes of structured as well as non-structured data easily using HDInsight, which is Microsoft's own distribution of Apache Hadoop. Furthermore, the blend of Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings available through Windows Azure lets you take advantage of Hadoop's processing power without the worry of creating, configuring, maintaining, or managing your own cluster. With the data explosion that is soon to happen, the open source Apache Hadoop Framework is gaining traction, and it benefits from a huge ecosystem that has risen around the core functionalities of the Hadoop distributed file system (HDFS) and Hadoop Map Reduce. ...
Pro Microsoft HDInsight is a complete guide to deploying and using Apache Hadoop on the Microsoft Windows Azure Platforms. The information in this book enables you to process enormous volumes of structured as well as non-structured data easily using HDInsight, which is Microsoft's own distribution of Apache Hadoop. Furthermore, the blend of Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings available through Windows Azure lets you take advantage of Hadoop's processing power without the worry of creating, configuring, maintaining, or managing your own cluster. With the data explosion that is soon to happen, the open source Apache Hadoop Framework is gaining traction, and it benefits from a huge ecosystem that has risen around the core functionalities of the Hadoop distributed file system (HDFS) and Hadoop Map Reduce. ...