Expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions About This Book * Build and deploy Tabular Model projects from relational data sources * Leverage DAX and create high-performing calculated fields and measures * Create ad-hoc reports based on a Tabular Model solution * Useful tips to monitor and optimize your tabular solutions Who This Book Is For This book is for SQL BI professionals and Architects who want to exploit the full power of the new Tabular models in Analysis Services. Some knowledge of previous versions of Analysis services would be helpful but is not essential. What You Will Learn * Learn all about Tabular services mode and how it speeds up development * Build solutions using sample datasets * Explore built-in actions and transitions in SSAS 2016 * Implement row-column, and role-based security in a Tabular Data model * Realize the benefits of in-memory and DirectQuery deployment modes * Get up to date with the new features added to SQL Server 2016 Analysis Services * Optimize Data Models and Relationships Usage In Detail SQL Server Analysis Service (SSAS) has been widely used across multiple businesses to build smart online analytical reporting solutions. It includes two different types of modeling for analysis services: Tabular and Multi Dimensional. This book covers Tabular modeling, which uses tables and relationships with a fast in-memory engine to provide state of the art compression algorithms and query performance. The book begins by quickly taking you through the concepts required to model tabular data and set up the necessary tools and services. As you learn to create tabular models using tools such as Excel and Power View, you'll be shown various strategies to deploy your model on the server and choose a query mode (In-memory or DirectQuery) that best suits your reporting needs. You'll also learn how to implement key and newly introduced DAX functions to create calculated columns and measures for your model data. Last but not least, you'll be shown techniques that will help you administer and secure your BI implementation along with some widely used tips and tricks to optimize your reporting solution. By the end of this book, you'll have gained hands-on experience with the powerful new features that have been added to Tabular models in SSAS 2016 and you'll be able to improve user satisfaction with faster reports and analytical queries. Style and approach This book takes a practical, recipe-based approach where each recipe lists the steps to address or implement a solution. You will be provided with several approaches to creating a business intelligence semantic model using analysis services.

Implement and administer successful database solution with SQL Server 2017 About This Book * Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution * Design and configure, manage, and secure a rock-solid SQL server * Comprehensive guide in keeping your SQL server disaster proof and all-time availability Who This Book Is For This book targets database administrators with an interest in SQL Server 2017 administration. Readers are expected to have some experience with previous SQL Server versions. What You Will Learn * Learn about the new features of SQL Server 2017 and how to implement them * Build a stable and fast SQL Server environment * Fix performance issues by optimizing queries and making use of indexes * Perform a health check of an existing troublesome database environment * Design and use an optimal database management strategy * Implement efficient backup and recovery techniques in-line with security policies * Combine SQL Server 2017 and Azure and manage your solution by various automation techniques Perform data migration, cluster upgradation and server consolidation In Detail Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution. You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics - such as migration, upgrading, and consolidation - are covered in detail. Integration with Azure is also covered in depth. Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017. Style and approach A comprehensive guide for database professionals, covering a wide range of topics from installation, maintenance, and configuration to managing systems for operational efficiency and high availability; best practices for maintaining a highly reliable database solution are also supplied from industry experts.

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book * Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features * Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe * Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016's features and capabilities. What You Will Learn * Key capabilities, architecture, and components of Reporting Services * New features that have been added to Reporting Services * Design the architecture for reporting solutions * Design the architecture for BI solutions * Implement reporting solutions using Reporting Services * Improve the performance, availability, and scalability of the reporting solution * Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You'll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you'll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.

Over 150 recipes to help you administer your PostgreSQL database more efficiently About This Book * Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently * Monitor, tune, secure and protect your database * A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with ease Who This Book Is For This book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience. What You Will Learn * Implement PostgreSQL features for performance and reliability * Harness the power of the latest PostgreSQL 9.6 features * Manage open source PostgreSQL versions 9.5 and 9.6 on various platforms * Discover advanced technical tips for experienced users * Explore best practices for planning and designing live databases * Select and implement robust backup and recovery techniques * Explore concise and clear guidance on replication and high availability * See the latest details on Logical Replication and Bi-Directional Replication In Detail PostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational, text search, Geographical Info Systems, analytical tools for big data and JSON/XML document management. Starting with short and simple recipes, you will soon dive into core features, such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters, from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics such as high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance. By the end of this book, you will have all the knowledge you need to run, manage, and maintain PostgreSQL efficiently. Style and approach This book takes a step-by-step, recipe-based approach, where each recipe focuses on a particular challenge faced by a PostgreSQL administrator while administering his/her database. Explained in a very easy to follow manner, every task is supported with best practices, tips and tricks.

Master the techniques and sophisticated analytics used to construct Spark-based solutions that scale to deliver production-grade data science products About This Book * Develop and apply advanced analytical techniques with Spark * Learn how to tell a compelling story with data science using Spark's ecosystem * Explore data at scale and work with cutting edge data science methods Who This Book Is For This book is for those who have beginner-level familiarity with the Spark architecture and data science applications, especially those who are looking for a challenge and want to learn cutting edge techniques. This book assumes working knowledge of data science, common machine learning methods, and popular data science tools, and assumes you have previously run proof of concept studies and built prototypes. What You Will Learn * Learn the design patterns that integrate Spark into industrialized data science pipelines * See how commercial data scientists design scalable code and reusable code for data science services * Explore cutting edge data science methods so that you can study trends and causality * Discover advanced programming techniques using RDD and the DataFrame and Dataset APIs * Find out how Spark can be used as a universal ingestion engine tool and as a web scraper * Practice the implementation of advanced topics in graph processing, such as community detection and contact chaining * Get to know the best practices when performing Extended Exploratory Data Analysis, commonly used in commercial data science teams * Study advanced Spark concepts, solution design patterns, and integration architectures * Demonstrate powerful data science pipelines In Detail Data science seeks to transform the world using data, and this is typically achieved through disrupting and changing real processes in real industries. In order to operate at this level you need to build data science solutions of substance -solutions that solve real problems. Spark has emerged as the big data platform of choice for data scientists due to its speed, scalability, and easy-to-use APIs. This book deep dives into using Spark to deliver production-grade data science solutions. This process is demonstrated by exploring the construction of a sophisticated global news analysis service that uses Spark to generate continuous geopolitical and current affairs insights.You will learn all about the core Spark APIs and take a comprehensive tour of advanced libraries, including Spark SQL, Spark Streaming, MLlib, and more. You will be introduced to advanced techniques and methods that will help you to construct commercial-grade data products. Focusing on a sequence of tutorials that deliver a working news intelligence service, you will learn about advanced Spark architectures, how to work with geographic data in Spark, and how to tune Spark algorithms so they scale linearly. Style and approach This is an advanced guide for those with beginner-level familiarity with the Spark architecture and working with Data Science applications. Mastering Spark for Data Science is a practical tutorial that uses core Spark APIs and takes a deep dive into advanced libraries including: Spark SQL, visual streaming, and MLlib. This book expands on titles like: Machine Learning with Spark and Learning Spark. It is the next learning curve for those comfortable with Spark and looking to improve their skills.

Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization About This Book * Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications * Work with temporal tables to get information about data stored in the table at any point in time * A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience Who This Book Is For This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed. What You Will Learn * Explore the new development features introduced in SQL Server 2016 * Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016 * Use columnstore indexes to get significant storage and performance improvements * Extend database design solutions using temporal tables * Exchange JSON data between applications and SQL Server in a more efficient way * Migrate historical data transparently and securely to Microsoft Azure by using Stretch Database * Use the new security features to encrypt or to have more granular control over access to rows in a table * Simplify performance troubleshooting with Query Store * Discover the potential of R's integration with SQL Server In Detail Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. This book introduces you to new features of SQL Server 2016 which will open a completely new set of possibilities for you as a developer. It prepares you for the more advanced topics by starting with a quick introduction to SQL Server 2016's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. The last chapters concentrate on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. You will finally be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. Style and approach This book is a detailed guide to mastering the development features offered by SQL Server 2016, with a unique learn-as-you-do approach. All the concepts are explained in a very easy-to-understand manner and are supplemented with examples to ensure that you-the developer-are able to take that next step in building more powerful, robust applications for your organization with ease.

Master the new and improved features of Oracle Database 12c Release 2 Maximize the benefits of the powerful features available in Oracle Database 12c Release 2 using the hands-on information contained in this authoritative guide from Oracle Press. You will find everything you need to know to get up and running quickly on the latest Oracle Database release-and to fully utilize every new tool. Oracle Database 12c Release 2 New Features starts by showing, step-by-step, how to handle the installation, configuration, migration, and upgrade processes. From there, you will learn to effectively deploy new enhancements to Oracle Multitenant, Oracle In-Memory, and big data analytics. Improvements to security, availability, and performance are fully covered. The book offers thorough discussions of sharding, diagnostics, performance tuning, and the powerful new cloud capabilities of Oracle Database 12c Release 2. * Contains a plethora of unique content focused on Oracle Database 12c Release 2 * Features subjective reviews of usefulness and functionality * Authored by an Oracle ACE with years of database experience

This practical Oracle Press guide teaches cutting-edge techniques for building, configuring, and managing a secure private database cloud with Oracle Enterprise Manager 13c. The book also explains how to use the RESTful API for DBaaS, SCHaaS and PDBaaS, and gives step by step instructions to set up the Oracle Database Hybrid Cloud.This hands-on volume lays out ready-to-deploy roadmaps for the design and maintenance of high-performance private database clouds using Oracle Enterprise Manager 13c. Learn best practices for a wide variety of different approaches-Database as a Service, Snap Clone as a Service, Schema as a Service, and Pluggable Database as a Service. Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control thoroughly explains how to architect, configure, and manage every component in a private database cloud lifecycle. You will get an insider's solutions for securing your cloud-based infrastructure, generating reliable RMAN backups, and protecting your mission-critical enterprise information using Oracle Data Guard. This comprehensive volume from Oracle Press features detailed, step-by-step instructions with multiple screen shots and diagrams that illustrate each technique along the way. Real-world examples and case studies illustrate applications in various industriesOffers essential skills for cloud administrators and DBAsAuthor is an Oracle Certified Master, previous ACE director, and experienced computing writer

Extend SQLite with mobile development skills to build great apps for iOS devices About This Book * Implement Swift code using SQLite statements * Learn the background to SQL and SQLite for mobile development, its statements, and command features through practical examples * Extend the standard SQLite functionality and increase your software creation portfolio Who This Book Is For This book is intended for those who want to learn about SQLite and how to develop apps in Swift or HTML5 using SQLite. Whether you are an expert Objective-C programmer or new to this platform, you'll learn quickly, grasping the code in real-world apps to use Swift. What You Will Learn * Explore Swift's basic language statements * Connect to SQLite and execute SQL statements * Extend the SQLite language to create your own software extensions * Use HTML5 with Phonegap on iOS * Set up a Swift project using XCode with SQLite * Administer SQLite databases in an easy and effective way In Detail The ability to use SQLite with iOS provides a great opportunity to build amazing apps. Apple's iOS SDK provides native support for SQLite databases. This combination offers the potential to create powerful, data-persistent applications. This book starts with the architecture of SQLite database and introduces you to concepts in SQL . You will find yourself equipped to design your own database system, administer it, and maintain it. Further, you will learn how to operate your SQLite databases smoothly using SQL commands. You will be able to extend the functionality of SQLite by using its vast arsenal of C API calls to build some interesting, exciting, new, and intelligent data-driven applications. Understand how Xcode, HTML5, and Phonegap can be used to build a cross-platform modern app which can benefit from all these technologies - all through creating a complete, customizable application skeleton that you can build on for your own apps. Style and approach This book is a practical and comprehensive guide to developing applications using SQLite and iOS.

Develop programmatic functions to create powerful database applications About This Book * Write complex SQL queries and design a robust database design that fits your application's need * Improve database performance by indexing, partitioning tables, and query optimizing * A comprehensive guide covering the advanced PostgreSQL concepts without any hassle Who This Book Is For If you are a PostgreSQL developer with a basic knowledge of PostgreSQL development and you're want deeper knowledge to develop applications, then this book is for you. As this book does not cover basic installation and configurations, you should have PostgreSQL installed on your machine as a prerequisite. What You Will Learn * Write more complex queries with advanced SQL queries * Design a database that works with the application exactly the way you want * Make the database work in extreme conditions by tuning, optimizing, partitioning, and indexing * Develop applications in other programming languages such as Java and PHP * Use extensions to get extra benefits in terms of functionality and performance * Build an application that does not get locked by data manipulation * Explore in-built db functions and data type conversions In Detail PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it's difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQL You will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database. The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts Style and approach Every chapter follows a step by step approach that first explains the concept , then shows you how to execute it practically so that you can implement them in your application.

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book * Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination * Build robust and secure applications in Oracle PL/SQL using the best practices * Packed with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12c Who This Book Is For This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL. What You Will Learn * Learn and understand the key SQL and PL/SQL features of Oracle Database 12c * Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c * Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling * Implement Virtual Private Databases to prevent unauthorized data access * Trace, analyze, profile, and debug PL/SQL code while developing database applications * Integrate the new application development features of Oracle Database 12c with the current concepts * Discover techniques to analyze and maintain PL/SQL code * Get acquainted with the best practices of writing PL/SQL code and develop secure applications In Detail Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience. Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions, and prepares you for the upcoming advanced concepts. The next chapter introduces you to the new features of Oracle Database 12c, not limited to PL/SQL. In this chapter, you will understand some of the most talked about features such as Multitenant and Database In-Memory. Moving forward, each chapter introduces advanced concepts with the help of demonstrations, and provides you with the latest update from Oracle Database 12c context. This helps you to visualize the pre- and post-applications of a feature over the database releases. By the end of this book, you will have become an expert in PL/SQL programming and will be able to implement advanced concepts of PL/SQL for efficient management of Oracle Database. Style and approach The book follows the structure of the Oracle Certification examination but doesn't restrict itself to the exam objectives. Advanced concepts have been explained in an easy-to-understand style, supported with feature demonstrations and case illustrations.

Faculty at Indiana University's world-renowned Kelley School of Business present this essential introductory guide to the role of computers and other information technologies in business. Highlights include instruction and applied practice in two of the most widely used commercial software packages: Microsoft Access and Microsoft Excel. Students learn, via hands-on examples, many of the powerful tools contained in these two platforms, with emphasis on how to analyze real business problems to help make important decisions.

Build real-world, industry-strength data storage solutions with time-tested design methodologies using Cassandra About This Book * Explore design patterns which co-exist with legacy data stores, migration from RDBMS, and caching technologies with Cassandra * Learn about design patterns and use Cassandra to provide consistency, availability, and partition tolerance guarantees for applications * Handle temporal data for analytical purposes Who This Book Is For This book is intended for big data developers who are familiar with the basics of Cassandra and wish to understand and utilize Cassandra design patterns to develop real-world big data solutions. Prior knowledge of RDBMS solutions is assumed. What You Will Learn * Enable Cassandra to co-exist with RDBMS and other legacy data stores * Explore various design patterns to build effective and robust storage solutions * Migrate from RDBMS-based data stores and caching solutions to Cassandra * Understand the behaviour of Cassandra when trying to balance the needs of consistency, availability, and partition tolerance * Deal with time stamps related to data effectively * See how Cassandra can be used in analytical use cases * Apply the design patterns covered in this book in real-world use cases In Detail There are many NoSQL data stores used by big data applications. Cassandra is one of the most widely used NoSQL data stores that is frequently used by a huge number of heavy duty Internet-scale applications. Unlike the RDBMS world, the NoSQL landscape is very diverse and there is no one way to model data stores. This mandates the need to have good solutions to commonly seen data store design problems. Cassandra addresses such common problems simply. If you are new to Cassandra but well-versed in RDBMS modeling and design, then it is natural to model data in the same way in Cassandra, resulting in poorly performing applications and losing the real purpose of Cassandra. If you want to learn to make the most of Cassandra, this book is for you. This book starts with strategies to integrate Cassandra with other legacy data stores and progresses to the ways in which a migration from RDBMS to Cassandra can be accomplished. The journey continues with ideas to migrate data from cache solutions to Cassandra. With this, the stage is set and the book moves on to some of the most commonly seen problems in applications when dealing with consistency, availability, and partition tolerance guarantees. Cassandra is exceptionally good at dealing with temporal data and patterns such as the time-series pattern and log pattern, which are covered next. Many NoSQL data stores fail miserably when a huge amount of data is read for analytical purposes, but Cassandra is different in this regard. Keeping analytical needs in mind, you'll walk through different and interesting design patterns. No theoretical discussions are complete without a good set of use cases to which the knowledge gained can be applied, so the book concludes with a set of use cases you can apply the patterns you've learned. Style and approach This book is written in very simple language and an engaging style complete with examples in every chapter and real-world use cases at the end of the book.

If you are a developer or DevOps engineer who understands the basics of Cassandra and are ready to take your knowledge to the next level, then this book is for you. An understanding of the essentials of Cassandra is needed.

As part of the Pocket Primer series, this book was designed for someone like you who needs to master Access programming fundamentals without spending too much time. All you need is a short book to get you started. It will show you only the things you need to know to feel at home with VBA. What you learn in this book on Access programming will also apply to, say, Excel programming. The book is divided into nine chapters that progressively introduce you to programming Microsoft Access 2016. Features: Includes a companion disc with all of the hands-on files needed to complete the chapter projects and all the images from the text Introduces you to programming Microsoft Access 2016

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 scripts 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 scripting 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 scripting 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 scripts 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.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. A practical roadmap for database upgrade, migration, and transformationThis Oracle Press guide provides best practices for migrating between different operating systems and platforms, transforming existing databases to use different storage or enterprise systems, and upgrading databases from one release to the next. Based on the expert authors' real-world experience, Oracle Database Upgrade, Migration & Transformation Tips & Techniques will help you choose the best migration path for your project and develop an effective methodology. Code examples and detailed checklists are included in this comprehensive resource. Leverage the features of Oracle Data Guard to migrate an Oracle Database Use Oracle Recovery Manager, transportable tablespace sets, and transportable database toolsets to migrate between platforms Migrate databases with export/import Use Oracle GoldenGate for zero or near-zero downtime migrations Take advantage of the Cross-Platform Transportable Tablespace Set utility Migrate to new storage platforms using the features of Oracle Automatic Storage Management Upgrade to Oracle Database 12c with the Database Upgrade Assistant tool Move seamlessly to Oracle's engineered systems Migrate to the cloud