Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity About This Book This book helps you build a strong foundation to get you comfortable using PowerShell with SQL Server, empowering you to create more complex *s for your day-to-day job The book provides numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes, or other components It offers easy-to-follow, practical recipes to help you get the most out of SQL Server and PowerShell Who This Book Is For If you are a SQL Server database professional (DBA, developer, or BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks, this books is for you. Prior knowledge of *ing would be helpful, but it is not necessary. What You Will Learn Explore database objects and execute queries on multiple servers Manage and monitor the running of SQL Server services and accounts Back up and restore databases Create an inventory of database properties and server configuration settings Maintain permissions and security for users Work with CLR assemblies, XML, and BLOB objects in SQL Manage and deploy SSIS packages and SSRS reports In Detail PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its *ing capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components. The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server administration tasks and then get to know about some security-related topics such as the authentication mode and assigning permissions. Moving on, you will explore different methods to back up and restore your databases and perform advanced administration tasks such as working with Policies, Filetables, and SQL audits. The next part of the book covers more advanced HADR tasks such as log shipping and data mirroring, and then shows you how to develop your server to work with BLOB, XML, and JSON. Following on from that, you will learn about SQL Server's BI stack, which includes SSRS reports, the SSIS package, and the SSAS cmdlet and database. Snippets not specific to SQL Server will help you perform tasks quickly on SQL servers. Towards the end of the book, you will find some useful information, which includes a PowerShell tutorial for novice users, some commonly-used PowerShell and SQL Server syntax, and a few online resources. Finally, you will create your own SQL Server Sandbox VMs. All these concepts will help you to efficiently manage your administration tasks. Style and approach SQL Server 2014 with PowerShell v5 Cookbook is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken and additional information about the task at hand. Working *s are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter or you can pick and choose which topics you need right away.

This book doesn't assume any prior experience with Dynamics NAV reporting. It is designed as an easy to follow guide, where each chapter builds upon the previous one, but can also be read completely separately. Basically this book is for everyone who is using Microsoft Dynamics NAV or has an interest on the reporting capabilities of NAV 2009. The book does not have major prerequisites, although it is mainly focused on Dynamics NAV 2009, RDLC and Business Intelligence. Whether you are a Dynamics NAV consultant, developer, customer, project manager, or just interested in the reporting capabilities of Dynamics NAV, this book can provide you with information from a helicopter view down to the smallest details, tips and tricks, and workarounds. Empowered with the information in this book you should be able to master, analyse and deliver the most challenging reporting requirements in Dynamics NAV.

This book is written in a cookbook-style format and provides practical, immediately usable task-based recipes that show you how to manage and maintain your Microsoft Exchange Server 2010 environment with Windows PowerShell 2.0. Each chapter of the book is written so that it can be used as a desktop reference, or it can be read from beginning to end, allowing you to build a solid foundation for building *s in your Exchange environment. This book is for messaging professionals who want to learn how to build real-world *s with Windows PowerShell 2.0 and the Exchange Management Shell. If you are a network or systems administrator responsible for managing and maintaining Exchange Server 2010, then this book is for you. The recipes in this cookbook touch on each of the core Exchange 2010 server roles and require a working knowledge of supporting technologies including Windows Server 2008 or Windows Server 2008 R2, Active Directory, and DNS. This book covers the latest additions to Exchange Server 2010 including Service Pack 1. A basic understanding of Exchange Server 2010 and Windows PowerShell 2.0 is highly recommended.

This book is part of Packt's Cookbook series. A Packt Cookbook contains step-by-step recipes for solutions to the most important problems you face when working with a topic. Inside this Cookbook you will find: A straightforward and easy-to-follow format, A selection of the most important tasks and problems ,Carefully organized instructions for solving the problem efficiently, Clear explanations of what you did Details for applying the solution to other situations If you are a JIRA developer or project manager who wants to fully exploit the exciting capabilities of JIRA, then this is the perfect book for you.

This book is a hands-on guide, describing concepts, ideas and terminology related to UAG and related technologies. The book starts with a discussion of terms that UAG technology is based on, and proceeds with step-by-step guidance for performing the various tasks related to UAG's core features. Each topic is preceded by a discussion of considerations that the administrator and the organization needs to go through to prepare for the task at hand, and includes plenty of screenshots illustrating what the administrator should expect to see on-screen, with real-life examples of configuration options. If you are a Networking or Security engineer who intends to integrate UAG into the organization network, then this book is for you. You need no experience with UAG or its predecessors, though basic understanding of Networking and Windows Server management and engineering is required. Experience with security systems like Firewalls would also help you to better understand some of the topics covered by this book.

Written in a cookbook style, this book offers solutions using a recipe-based approach. Each recipe contains step-by-step instructions followed by an analysis of what was done in each task and other useful information. The cookbook approach means you can dive into whatever recipes you want in no particular order.If you want to easily implement ADempiere in your organization, this book is for you. This book will also be beneficial to system users and administrators who wish to implement an ERP system. Only basic knowledge of ADempiere is required. This cookbook will build on that basic knowledge equipping you with the intermediate and advanced skills required to fully maximize ADempiere. A basic knowledge of accounting and the standard business workflow would be beneficial.

Written in a cookbook style, this book offers solutions using a recipe based approach. Each recipe contains step-by-step instructions followed by an analysis of what was done in each task and other useful information. If you are a software developer interested in content management systems, who wants to work with Alfresco or is already experienced in Alfresco, this cookbook will get you up and running quickly. If you want rapid implementation of Alfresco’s most important and effective features then this is the cookbook for you.

The book consists of a set of business scenarios and corresponding solution critiques. Each "use case" chapter is made up of a problem de*ion, assessment of implementation options, and the selection of the ideal solution candidate. We then construct the solution using the chosen Microsoft technology. This book is for architects, developers, and managers who need to improve their knowledge of the Microsoft application platform. This book will appeal to anyone who wants to get up to speed on selecting the most appropriate platform for a particular problem. Consultants and executive leadership will also find significant value in this book. A good understanding of the general Windows platform and development technologies would be helpful.

This book is a practical guide that not only shows you how to do things, but also makes you understand how things really work, so you'll be able to develop your own applications. It uses many screenshots, examples, and real-time "APEX code", some of which is documented for the first time. This book is for developers, in general, and web developers, in particular, who wish to learn how to develop data-centric web applications in the Oracle environment. It is also for novice APEX developers, who wish to learn how to use and best utilize the APEX environment, as well as for more experience APEX developers who wish to improve their knowledge and understanding of APEX and its capabilities, and learn from the experience of others. It assumes basic knowledge of HTML, SQL, and PL/SQL. Basic JavaScript understanding is an advantage, and in general can make your life much easier as an APEX developer.

This book covers building an application using the principles of BPM and SOA, using WPS and WESB. The various detailed aspects, features, and capabilities of the product are conveyed though examples. It also provides pragmatic guidance on various aspects in relation to building the SOA application. Every section has solutions to common problems and pitfalls. This book is for SOA architects, designers, and developers who have a basic understanding of SOA concepts and would like to learn more about building solutions and applications using IBM WebSphere Process Server and WebSphere Enterprise Service Bus.

Written in a practical and clear conversational style, this book is filled with real-life website performance scenarios. It is replete with lots of working code samples and practical advice, and just the right amount of theory you need to make sense of it all. This book is written for ASP.NET/SQL Server-based website developers who want to speed up their site using simple, proven tactics without going through a lot of unnecessary theoretical learning. If your website isn't performing well, this is the ideal book for you.

Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness. If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you’ll be able to easily follow the book.

This is a Cookbook with recipes aimed at all levels with lots of practical walkthroughs for virtualization techniques.This book is great for Dynamics CRM 2011 professionals who have a beginner level understanding of the system and are looking to get a good grounding in how to deploy, maintain, configure, and customize a Dynamics CRM 2011 application efficiently. It’s assumed that the reader has a basic level understanding of IT infrastructure topologies along with functional knowledge of Dynamics CRM 2011 Sales, Marketing, and Services modules.

Microsoft Dynamics GP 2013 Cookbook is a highly practical beginner to intermediate Cookbook to improve your efficiency and master your use of Microsoft Dynamics GP 2013. All the recipes are time-proven; real-world tested, and designed to be used immediately.If you’re a Dynamics GP partner or Dynamics GP user, primarily focused on delivering application optimizations, then "Microsoft Dynamics GP 2013 Cookbook" is for you.This book assumes that you have a basic knowledge of Microsoft Dynamics GP, a basic understanding of business management systems, and some exposure to Microsoft SQL Server.

This book is written in simple, easy to understand format with lots of screenshots and step-by-step explanations. If you are an IBM WebSphere Portal developer, looking to develop and enhance enterprise portals by understanding the complete portal project lifecycle, then this is the best guide for you. This book assumes that you have a fundamental knowledge of working in the WebSphere Portal environment.

This book has a tutorial approach that provides both theoretical explanations and practical step-by-step examples using familiar Oracle demo schemas. Step-by-step examples include use of both Enterprise Manager and the SQLPLUS command-line interface. The authors have combined their experiences of working with customers in Oracle Support, Oracle training and education, and Oracle consulting, to identify the most common areas of confusion and misinterpretation experienced by Oracle Streams users. This book highlights these areas and focuses on bringing clarity and understanding to the reader. This book is for users who have implemented, or are about to implement, a distributed database environment using Oracle Streams replication. The reader is expected to have an intermediate understanding of Oracle database technology. This book is mainly intended for use by: Oracle Database Administrators responsible for the implementation and maintenance of an Oracle Streamed environment, System and Database Architects responsible for the design of distributed database environments using Oracle Streams Readers with limited knowledge of basic Oracle database technology can benefit from Chapters 1 and 2, which cover Oracle Streams Components and Design Considerations.

As a Cookbook, this book enables you to create APEX web applications and to implement features with immediately usable recipes that unleash the powerful functionality of Oracle APEX 4.2. Each recipe is presented as a separate, standalone entity and the reading of other, prior recipes is not required.It can be seen as a reference and a practical guide to APEX development.This book is aimed both at developers new to the APEX environment and at intermediate developers. More advanced developers will also gain from the information at hand.If you are new to APEX you will find recipes to start development and if you are an experienced user you will find ways to improve your productivity and efficiency and make the most of APEX to enhance your applications.A little knowledge of PL/SQL, HTML and JavaScript is assumed.

Machine learning has become the new black. The challenge in today's world is the explosion of data from existing legacy data and incoming new structured and unstructured data. The complexity of discovering, understanding, performing analysis, and predicting outcomes on the data using machine learning algorithms is a challenge. This cookbook will help solve everyday challenges you face as a data scientist. The application of various data science techniques and on multiple data sets based on real-world challenges you face will help you appreciate a variety of techniques used in various situations. The first half of the book provides recipes on fairly complex machine-learning systems, where you'll learn to explore new areas of applications of machine learning and improve its efficiency. That includes recipes on classifications, neural networks, unsupervised and supervised learning, deep learning, reinforcement learning, and more. The second half of the book focuses on three different machine learning case studies, all based on real-world data, and offers solutions and solves specific machine-learning issues in each one. What You Will Learn ?Get equipped with a deeper understanding of how to apply machine-learning techniques ?Implement each of the advanced machine-learning techniques ?Solve real-life problems that are encountered in order to make your applications produce improved results ?Gain hands-on experience in problem solving for your machine-learning systems ?Understand the methods of collecting data, preparing data for usage, training the model, evaluating the model's performance, and improving the model's performance

Customize your NAV applications About This Book ?Gain from the insights and methods of industry-leading experts and tailor your applications to best suit the needs of your business ?Learn through the detailed explanations and useful examples that are presented in a logical, step-by-step manner ?This comprehensive guide is written with the goals of being used as a classroom text, a self-study text, and as a handy in-depth reference guide Who This Book Is For This book will appeal to all those who want to learn about NAV's powerful and extensive built-in development capabilities. It assumes that you understand programming and are familiar with business application software, although you aren't expected to have worked with NAV before. ERP consultants and managers of NAV development will also find the book helpful. What You Will Learn ?Productively and effectively use the development tools that are built into Dynamics NAV ?Understand the strengths of NAV's development tools and how they can be applied to address functional business requirements ?Introduction to programming using the C/AL language in the C/SIDE Development Environment ?Explore functional design and development using C/AL ?Leverage advanced NAV development features and tools ?Get to know the best practices to design and develop modifications of new functionality integrated with the standard NAV software In Detail Microsoft Dynamics NAV is a full business solution suite, and a complete ERP solution, which contains a robust set of development tools to support customization and enhancement. These

Over 100 powerful and effective recipes to help you solve real-world Dynamics GP problems About This Book Switch to Dynamics GP 2016 to take advantage of improved cloud support, workflow enhancements, and a more intuitive user experience Understand the various tips and tricks to master Dynamics GP, and improve your system’s stability in order to enable you to get work done faster Discover how to solve real-world problems in Microsoft Dynamics GP 2016 with easy-to-understand and practical recipes Who This Book Is For The book is for Dynamics GP users or Dynamics GP partners. It assumes that you have a basic understanding of business management systems and Microsoft Dynamics GP. What You Will Learn Explore the new enhancements in Dynamics GP 2016 Personalize Microsoft Dynamics GP to improve accessibility and efficiencies Maintain Dynamics GP and ensure proper operation of the system using optimum processes Efficiently organize Microsoft Dynamics GP to improve processes Leverage the power of SmartLists using proven tips and techniques and undocumented search functionalities Connect Microsoft Dynamics GP 2016 to Microsoft Office 2013 Enhance the usability of Microsoft Dynamics GP with hacks Expose the hidden features in Microsoft Dynamics GP to improve efficiency and get more from the system Deploy and use the Support Debugging tool to trace, locate, and resolve problems encountered by users Explore PowerBI and how it can be used with Dynamics GP 2016 In Detail The latest release of Dynamics GP 2016 offers a powerful, adaptable, and cloud enabled enterprise accounting software solution. The new version has experienced changes in serviced-based architecture, workflow, existing functionalities, and the introduction of plenty of new features. This book will help you get the most out of Dynamics GP quickly and effectively. This book picks up where implementation training leaves off. Whether you are new or experienced, you will find useful recipes to improve the way you use and work with Dynamics GP. The book starts with recipes designed to enhance the usefulness of Microsoft Dynamics GP by personalizing the look and feel of the application. Most of the recipes are designed to give you tips for a typical installation of Dynamics GP, including core financials and distribution modules. The book then moves through recipes that include automating Dynamics GP to allow users or administrators to focus on value adding tasks, connecting Dynamics GP to Microsoft Office, exposing hidden features in Dynamics GP, PowerBI, and much more! Style and approach This book follows a recipe-based approach with a problem-solution mind-set. Each recipe is independent of the others; real-world tested, and designed to be used immediately.

100 recipes that teach you how to perform various machine learning tasks in the real world About This Book Understand which algorithms to use in a given context with the help of this exciting recipe-based guide Learn about perceptrons and see how they are used to build neural networks Stuck while making sense of images, text, speech, and real estateThis guide will come to your rescue, showing you how to perform machine learning for each one of these using various techniques Who This Book Is For This book is for Python programmers who are looking to use machine-learning algorithms to create real-world applications. This book is friendly to Python beginners, but familiarity with Python programming would certainly be useful to play around with the code. What You Will Learn Explore classification algorithms and apply them to the income bracket estimation problem Use predictive modeling and apply it to real-world problems Understand how to perform market segmentation using unsupervised learning Explore data visualization techniques to interact with your data in diverse ways Find out how to build a recommendation engine Understand how to interact with text data and build models to analyze it Work with speech data and recognize spoken words using Hidden Markov Models Analyze stock market data using Conditional Random Fields Work with image data and build systems for image recognition and biometric face recognition Grasp how to use deep neural networks to build an optical character recognition system In Detail Machine learning is becoming increasingly pervasive in the modern data-driven world. It is used extensively across many fields such as search engines, robotics, self-driving cars, and more. With this book, you will learn how to perform various machine learning tasks in different environments. We’ll start by exploring a range of real-life scenarios where machine learning can be used, and look at various building blocks. Throughout the book, you’ll use a wide variety of machine learning algorithms to solve real-world problems and use Python to implement these algorithms. You’ll discover how to deal with various types of data and explore the differences between machine learning paradigms such as supervised and unsupervised learning. We also cover a range of regression techniques, classification algorithms, predictive modeling, data visualization techniques, recommendation engines, and more with the help of real-world examples. Style and approach You will explore various real-life scenarios in this book where machine learning can be used, and learn about different building blocks of machine learning using independent recipes in the book.