Oracle Enterprise Manager 12c Command-Line Interface shows how to use Enterprise Manager's powerful scripting language to automate your database administration work and save time by scripting routine tasks, and then executing those scripts across collections of databases and instances in your environment. This book is chock full of ready-made scripting examples contributed by the authors and leading members of the community. For example, you'll find scripts and examples of commands to: Remove an Enterprise Manager agent and its related targets Quickly create administrator accounts that are fully-configured with pre-expired passwords and all needed roles Invoke batch files to execute sequences of related commands with consistency against multiple targets Batch create large groups of user logins with a single command and more! The Enterprise Manager Command Line Interface (EM CLI) is the administrator's key to unlocking the power of Enterprise Manager 12c (EM12c) with scalability, repeatability, and confidence. In previous versions, most administrators ventured into the command-line interface only with the assistance of Oracle Support. But now there are many features in EM12c that are accessible only from the command-line. This is far from a disadvantage! Enterprise Manager is now a powerful tool for automation in the hands of a skilled database administrator. Enterprise Manager scripting offers potential for all administrators who manage Oracle's enterprise-level products in their environment. You can automate from the smallest, single-instance configuration all the way up to a broadly distributed enterprise-level rollout having database instances strewn across broad geographical distributions. The power of the EM CLI returns the administrator to the golden age, where the entire environment, from database to application to infrastructure, can often be managed from this powerful command line tool secured by the robust Enterprise Manager framework. Brings a golden-age of automation to Oracle Database administrators Provides ready-made scripts contributed by leading members of the community Covers advanced techniques involving Jython and Python

Conscious and unconscious bias, societal pressures, and discomfort with women's ambition are issues that women are confronted with in any male-dominated setting, and tech is no exception. Statistically, women are a disproportionately small percentage of the technology industry. How did we get here, what is changing, and what can future generations of women in STEM expect? In Crushing the IT Gender Bias, author Kellyn Pot'Vin-Gorman applies her two decades of experience in tech to these meaningful questions, plus many more. As a mentor and sponsor of women in the database and development communities, Pot'Vin-Gorman uses experience, visualizations of hard data, and industry interviews to describe the many challenges that women face in STEM. She then shows you how to inoculate against them. Small, positive changes like these are similar to a vaccine: they build individual immunity and thus create herd immunity to protect the most vulnerable. This shift is accomplished through increased representation of-and direct exposure to-successful role models in the industry. You'll get practical advice related to hiring practices, salary negotiations, and barriers to collaboration. After witnessing multiple female peers depart the tech world, Pot'Vin-Gorman has written Crushing the IT Gender Bias to make her voice heard and to start this necessary conversation productively so that women can thrive. Additionally, this book is for male professionals who desire to grow in their understanding and eliminate bias in their environments. Do not be content with mere survival. Read this book, practice the techniques, and, most importantly, learn how to pay it forward. By arming yourself with knowledge and facing bias head-on, you can be the meaningful change that you want to see in the tech industry. Who This Book Is For Women in any area of technology with a desire to make and lead positive change by eliminating conscious and unconscious bias along with strategically confronting the many issues facing women in a field dominated by cultural bias. The book appeals to those just starting a career through to seasoned professionals, and even to those entering the management tier. This book also welcomes men with a desire to grow in their understanding and eliminate bias in the world around them.

Enterprise Manager 12c (EM12c), Oracle's newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today's increasingly chaotic and change-driven IT environment. Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle's online knowledgebase.Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. * Provides example solutions to everyday problems through EM12c features. * Explains the changes in EM12c, included trusted extensions. * Focuses on advanced aspects of the EM12c interface. What you'll learn * Installation and agent employment * Patching and provisioning * Advanced techniques for managing and monitoring * Use of EM12c in cloud environments, with RAC, and for Exadata * Creation of EM12c plugins and metric extensions * High-availability and disaster-recovery options with EM12c * Incident Manager and EM12c job management Who this book is for Expert Oracle Enterprise Manager 12c is for database administrators who are ready to upgrade, or who have already upgraded to Enterprise Manager 12c. The book also appeals to system administrators who may have responsibility for helping support Oracle Database environments -- including RAC and Exadata -- at the enterprise level.

Expert SQL Server Practices 2012 Edition is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012.With an emphasis upon performance--but also branching into release management, auditing, and other issues--the book helps you deliver the most value for your company's investment in Microsoft's flagship database system * Goes beyond the manual to cover good techniques and best practices * Delivers knowledge usually gained only by hard experience * Focuses upon performance, scalability, reliability * Helps achieve the predictability needed to be in control at all times What you'll learn * Migrate to the new Extended Events framework for troubleshooting performance problems * Automate the tracking of key performance indicators such as available disk space, cpu utilization, index fragmentation, and more * Design performance into your database and its applications from the very beginning * Manage staged releases from development to test through to production * Diagnose resource and performance problems via dynamic management views * Analyze I/O patterns and plan reliably to obtain the performance you need Who this book is for Expert SQL Server Practices is aimed at SQL Server professionals who want to further their careers through expert-level practices in performance management, scalability, predictability, and security.Table of Contents * Jesper Johansen. Be Your Developer's Best Friend * Louis Davidson. Getting It Right: Designing for Database Performance * Gail Shaw. Hidden Performance Gotchas * Kellyn Pot'vin. Dynamic Management Views * Mladen Prajdic. From SQL Trace to Extended Events * Chris Shaw. The Utility Database * Jason Strate. Indexing Outside the Bubble * TJay Belt. Release Management * Jonathan Gardner. Compliance and Auditing * Jes Borland. Automating Administration * Wendy Pastrick. The Fluid Dynamics of SQL Server Data Movement * Herve Roggero. Windows Azure Features for DBAs * Jeremy Lowell. I/O: The Untold Story * Bradley Ball. Page and Row Compression * Glenn Berry. Selecting and Sizing the Server * Grant Fritchey. Backups and Restores Using Availability Groups * Carlos Bossy. Big Data for the SQL Server DBA * Ben DeBow. Tuning for Peak Load