Pro PowerShell for Database Developers

Author: Bryan P. Cafferky

Publisher: Apress

ISBN: 1484205413

Category: Computers

Page: 407

View: 2553

Pro PowerShell for Database Developers helps you master PowerShell application development by continuing where other books leave off. There are no "Hello World" functions here, just real-world examples that get down to business. Develop and deploy database and ETL applications in a reusable framework. Read from any data source and write to any destination. Integrate PowerShell with SQL Server. Pro PowerShell for Database Developers shows how to dive into the PowerShell environment and customize it to your needs. Learn about CmdletBinding and its use in extending functions with powerful new features. Also learn to package functions into libraries called modules that are loaded automatically on demand. PowerShell is about automation and getting work done when you’re not around to perform it. To that end you’ll see how to schedule PowerShell applications using SQL Agent and the scheduled job cmdlets. And for when you are around to run automated processes in person, you’ll learn to add a Windows GUI to your applications to give them that professional polish. Other exciting topics include: Creating objects with custom methods and properties and extending them with PowerShell-style inheritance. Implementing function polymorphism using parameter sets. Using PowerShell as an ETL tool surpassing even SSIS. Creating distributed, interruptible, and multithreaded programs using PowerShell's workflow engine and the .Net Windows Workflow Foundation. All these topics are explained using real-world examples encapsulated into modules you can immediately put to use in your organization. You’ll reap even more as you come to grips with all that PowerShell can do. Begin the journey toward deep expertise and amazing productivity. Buy and read Pro PowerShell for Database Developers today.

Pro PowerShell for Amazon Web Services

DevOps for the AWS Cloud

Author: Brian Beach

Publisher: Apress

ISBN: 1430264527

Category: Computers

Page: 316

View: 4051

Pro PowerShell for Amazon Web Services is written specifically for Windows professionals who already know PowerShell and want to learn to host Windows workloads in the Amazon Elastic Cloud Compute (EC2) cloud service. The cloud offers information technology workers significant cost savings and agility unimaginable even just a few years ago. Tasks that traditionally took weeks of work, costing thousands of dollars, can be completed in minutes for a fraction of a penny. This book is a resource for using Microsoft's powerful scripting language, PowerShell, to create, host, manage, and administer workloads using a service widely recognized as the industry leader in cloud computing. Inside, find scripts to create and manage virtual machines, provision storage, configure networks with agility, and more--all using your preferred Windows scripting language. Use your PowerShell knowledge to harness the power of Amazon EC2 today!

Pro PowerShell Desired State Configuration

An In-Depth Guide to Windows PowerShell DSC

Author: Ravikanth Chaganti

Publisher: Apress

ISBN: 1484234839

Category: Computers

Page: 577

View: 4459

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 PowerShell 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. What’s new in this edition? Get up-to-date, in-depth guidance on DSC in the data center Understand the central role that DSC plays in DevOps today Integrate DSC into build and release management tools Learn to think and act like a developer when automating your configuration management, creating a testable, robust process that you can use again and again Find out why and how DSC has an important role to play in public and private cloud deployments Apply DSC in the cloud with Microsoft Azure or Amazon Web Services or Google Cloud Platform Who This Book Is For IT administrators, developers and DevOps engineers working in Windows-based data center environments. With a little prior PowerShell scripting experience, this book can be used as an in-depth reference to creating, customizing, and extending DSC in Windows. IT administrators with limited scripting experience will also find this book a useful overview of what DSC offers and how to use DSC resources to automate configuration management and deployment.

Microsoft SQL Server 2008 Administration with Windows PowerShell

Author: Ananthakumar Muthusamy,Yan Pan

Publisher: John Wiley & Sons

ISBN: 1118058674

Category: Computers

Page: 580

View: 7036

The definitive guide to automating SQL Server admnistration with Powershell scripts If you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. This nuts-and-bolts guide shows you how to create Windows PowerShell scripts to administer almost every aspect of SQL Server. You'll get a thorough introduction to PowerShell basics and all the PowerShell components that have been integrated into SQL Server 2008, as well as actual administration tasks. The book provides complete scripts that have been tested and proven, saving you hours of effort. The new release of Microsoft SQL Server 2008 now includes Windows PowerShell, allowing administrators of large-scale enterprise databases to automate many tasks SQL Server 2008 Administration with Windows PowerShell introduces you to PowerShell, covering its components in detail as well as providing basic instruction in using scripts to administer the database The book includes numerous examples of SQL tasks that have been automated and also provides completed scripts that you can put to use immediately The Companion Web site includes complete code scripts If you're a database administrator, the scripts and techniques in SQL Server 2008 Administration with Windows PowerShell will save you hours of effort.

SQL Server 2014 with PowerShell v5 Cookbook

Author: Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1785283618

Category: Computers

Page: 760

View: 9665

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.

SQL Server 2017 Developer’s Guide

A professional guide to designing and developing enterprise database applications

Author: William Durkin,Miloš Radivojević,Dejan Sarka

Publisher: Packt Publishing Ltd

ISBN: 1788479939

Category: Computers

Page: 816

View: 1562

Build smarter and efficient database application systems for your organization with SQL Server 2017 Key Features Build database applications by using the development features of SQL Server 2017 Work with temporal tables to get information stored in a table at any time Use adaptive querying to enhance the performance of your queries Book Description Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017’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 enhancements in the Transact-SQL language and new database engine capabilities 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. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you’ll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You’ll also learn to integrate Python code in SQL Server and graph database implementations along with deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. What you will learn Explore the new development features introduced in SQL Server 2017 Identify opportunities for In-Memory OLTP technology Use columnstore indexes to get storage and performance improvements Exchange JSON data between applications and SQL Server Use the new security features to encrypt or mask the data Control the access to the data on the row levels Discover the potential of R and Python integration Model complex relationships with the graph databases in SQL Server 2017 Who this book is for Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well. Some basic understanding of database concepts and T-SQL is required to get the best out of this book.

Windows PowerShell for Developers

Enhance Your Productivity and Enable Rapid Application Development

Author: Douglas Finke

Publisher: "O'Reilly Media, Inc."

ISBN: 1449322662

Category: Computers

Page: 210

View: 2080

Want to perform programming tasks better, faster, simpler, and make them repeatable? Take a deep dive into Windows PowerShell and discover what this distributed automation platform can do. Whether you’re a .NET developer or IT pro, this concise guide will show you how PowerShell’s scripting language can help you be more productive on everyday tasks. Quickly learn how to create PowerShell scripts and embed them into your existing applications, write "little languages" to solve specific problems, and take charge of your code. This book includes example scripts that you can easily pull apart, tweak, and then use in your own PowerShell and .NET solutions. Slice and dice text, XML, CSV, and JSON with ease Embed PowerShell to provide scripting capabilities for your C# apps Create GUI applications five to ten times faster with less code Leverage PowerShell’s capabilities to work with the Internet Interact with DLLs and create objects, automatically display properties, and call methods in live interactive sessions Build domain-specific languages (DSLs) and vocabularies to express solutions more clearly Work with Microsoft Office via the Component Object Model (COM) Discover PowerShell v3 features included with Windows 8 and Windows Server 2012

Pro PowerShell for Microsoft Azure

Author: Sherif Talaat

Publisher: Apress

ISBN: 1484206657

Category: Computers

Page: 201

View: 6239

This book is written for Windows professionals who are familiar with PowerShell and want to learn to build, operate, and administer their Windows workloads in the Microsoft cloud. Pro PowerShell for Microsoft Azure is packed with practical examples and scripts, with easy-to-follow explanations for a wide range of day-to-day needs and essential administration tasks. Author Sherif Talaat begins by explaining the fundamental concepts behind the Microsoft Azure platform and how to get started configuring it through PowerShell. Readers will find out how to deploy, configure and manage the various components of the Azure platform, from storage and virtual networks to Azure Web Sites, HDInsight clusters and the Azure SQL Database. Workload automation, scheduling and resource management are covered in depth to help build efficiency in everyday tasks, and administrators will gain full control over Azure identity and access rights using Azure Active Directory and Rights Management Services. Put your PowerShell skills to good use and ensure that your applications and data are available anywhere at any time, with Pro PowerShell for Microsoft Azure. What You'll Learn Create and manage virtual networks and VPNs using PowerShell. Configure and maintain Azure Storage accounts, blobs, and containers. Provision and manage a redundant Windows or Linux server. Deploy and configure your sites in the cloud using Microsoft Azure Web Sites. Provision Apache Hadoop clusters in the cloud using Azure HDInsight. Deploy, configure and manage a Microsoft Azure SQL Database. Protect and secure identities and resources with Azure Active Directory and Azure Rights Management Services. Who This Book Is For This is book is for the intermediate to advanced Windows professional who is ready to make the leap to the cloud.

SQL Server 2012 with PowerShell V3 Cookbook

Author: Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1849686475

Category: Computers

Page: 634

View: 5109

SQL Server 2012 with PowerShell V3 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, This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.

Essential PowerShell

Author: Holger Schwichtenberg

Publisher: Pearson Education

ISBN: 9780132715195

Category: Computers

Page: 504

View: 3247

Use PowerShell to Streamline and Automate Your Most Time-Consuming Windows Administration Tasks With Windows PowerShell, Microsoft brings innovative console-based system administration and scripting to Windows clients and servers. PowerShell combines the best features of traditional UNIX shells with the immense power of the .NET Framework, offering a consistent and easy-to-use replacement for both the Windows command line and the Windows Script Host. In Essential PowerShell, noted expert Holger Schwichtenberg gives Windows sysadmins all the knowledge and sample scripts they need to successfully administer production systems with PowerShell. Schwichtenberg begins by introducing the innovative PowerShell architecture, along with crucial PowerShell concepts such as pipelining and navigation. Next, he introduces the PowerShell Script Language, shows the secure execution of command sequences as scripts, and demonstrates how to use PowerShell to access essential operating system interfaces such as COM, WMI, ADSI, and ADO.NET. After you’ve mastered the fundamentals, Schwichtenberg presents an extensive collection of PowerShell solutions for virtually every area of day-to-day administration. For each topic, he presents dozens of self-contained examples, all downloadable from a companion Web site. He covers both Microsoft’s standard PowerShell commandlets and the free commandlets available as PowerShell Community Extensions. He also presents a full chapter of tips, tricks, and troubleshooting solutions. Coverage includes Understanding PowerShell’s components and features Setting up your PowerShell scripting environment Creating and using commandlets Using object-oriented pipelining for filtering, sorting, grouping, comparisons, calculations, and more Mastering PowerShell’s uniform navigation model and using it with all types of data Programming command sequences with the PowerShell Script Language Making the most of the PowerShell console and third-party tools Managing processes, event logs, and registry entries Controlling networking, printing, and software installation Manipulating Active Directory and other enterprise services with PowerShell Using PowerShell to enforce stronger system and network security Storing data in files, documents, and databases Preface xv Part I: Getting Started with PowerShell 1: First Steps with Windows PowerShell 3 2: Commandlets 25 3: Pipelining 43 4: Advanced Pipelining 59 5: The PowerShell Navigation Model 81 6: The PowerShell Script Language 89 7: PowerShell Scripts 115 8: Using Class Libraries 129 9: PowerShell Tools 151 10: Tips, Tricks and Troubleshooting 171 Part II: Windows PowerShell in Action 11: File Systems 205 12: Documents 235 13: Registry and Software 253 14: Processes and Services 267 15: Computers and Hardware 281 16: Networking 295 17: Directory Services 313 18: User and Group Management in the Active Directory 335 19: Searching in the Active Directory 349 20: Additional Libraries for Active Directory Administration 361 21: Databases 373 22: Advanced Database Operations 389 23: Security Settings 401 24: Advanced Security Administration 413 PartIII: Appendices Appendix A: PowerShell Commandlet Reference 429 Appendix B: PowerShell 2.0 Preview 445 Appendix C: Bibliography 449 Index 453

Pro ASP.NET Web API Security

Securing ASP.NET Web API

Author: Badrinarayanan Lakshmiraghavan

Publisher: Apress

ISBN: 1430257830

Category: Computers

Page: 416

View: 3251

ASP.NET Web API is a key part of ASP.NET MVC 4 and the platform of choice for building RESTful services that can be accessed by a wide range of devices. Everything from JavaScript libraries to RIA plugins, RFID readers to smart phones can consume your services using platform-agnostic HTTP. With such wide accessibility, securing your code effectively needs to be a top priority. You will quickly find that the WCF security protocols you’re familiar with from .NET are less suitable than they once were in this new environment, proving themselves cumbersome and limited in terms of the standards they can work with. Fortunately, ASP.NET Web API provides a simple, robust security solution of its own that fits neatly within the ASP.NET MVC programming model and secures your code without the need for SOAP, meaning that there is no limit to the range of devices that it can work with – if it can understand HTTP, then it can be secured by Web API. These SOAP-less security techniques are the focus of this book.

PowerShell for SQL Server Essentials

Author: Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1784397105

Category: Computers

Page: 186

View: 4668

This book is written for SQL Server administrators and developers who want to leverage PowerShell to work with SQL Server. Some background with scripting will be helpful but not necessary.

Pro Windows PowerShell

Author: Hristo Deshev

Publisher: Apress

ISBN: 9781430205463

Category: Computers

Page: 493

View: 2604

Here is your best companion to the capabilities and power that PowerShell offers. Inside this book, you’ll discover the object-oriented features of the shell and how they help in extracting and manipulating data. You’ll then learn how to use those features to solve real-world problems: manipulating files, working with text, monitoring systems, and performing operations over the network. In addition, you’ll find freely available tools and extensions that help you get results with Windows PowerShell fast.

SQL Server 2017 Administration Inside Out

Author: William Assaf,Randolph West,Sven Aelterman,Mindy Curnutt

Publisher: Microsoft Press

ISBN: 0135185394

Category: Computers

Page: 704

View: 3244

Conquer SQL Server 2017 administration—from the 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 masking • Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing • Establish SQL Server IaaS network security groups and user-defined routes • Administer SQL Server user security and permissions • Efficiently design tables using keys, data types, columns, partitioning, and views • Utilize BLOBs and external, temporal, and memory-optimized tables • Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans • Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals • Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert • Prerequisites: Basic understanding of database administration procedures

Microsoft Azure SQL Database Step by Step

Author: Leonard Lobel,Brian Reynolds,Eric D. Boyd

Publisher: Pearson Education

ISBN: 0735679428

Category: Computers

Page: 370

View: 5431

Your hands-on guide to Azure SQL Database fundamentals Expand your expertise—and teach yourself the fundamentals of Windows Azure SQL Database. If you have previous programming experience but are new to Azure, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques. Discover how to: Perform Azure setup and configuration Explore design and security considerations Use programming and reporting services Migrate data Backup and sync data Work with scalability and high performance Understand the differences between SQL Server and Windows Azure SQL Database

Pro SQL Server 2008 Policy-Based Management

Author: Ken Simmons,Colin Stasiuk,Jorge Segarra

Publisher: Apress

ISBN: 1430229101

Category: Computers

Page: 268

View: 6023

Pro SQL Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own custom policies to enforce consistent rules across your organization. Provides in-depth treatment of policy-based management in a single source Provides practical usage scenarios for policy-based management Provides guidance to help meet growing regulatory compliance needs What you’ll learn Learn about policy-based management and why you should implement it. Create policies to maintain a consistent, predictable environment throughout your organization. Audit organizational compliance with policies automatically, across any number of servers. Help ensure compliance with PCI rules, HIPAA rules, and other government regulations. Configure and receive alerts for policy violations. View and report on the state of your policies. Who this book is for This book is for database administrators who wish to apply consistent management practices across dozens and even hundreds of database servers. Table of Contents Introduction to Policy-Based Management Creating Policies Evaluating Policies Policy-Based Management Using PowerShell Receiving Alerts for Policy Violations Policy-Based Management Internals Practical Uses of Policy-Based Management Reporting Enforcing Compliance Where to Go from Here

Databases for Small Business

Essentials of Database Management, Data Analysis, and Staff Training for Entrepreneurs and Professionals

Author: Anna Manning

Publisher: Apress

ISBN: 1484202775

Category: Computers

Page: 318

View: 7924

This book covers the practical aspects of database design, data cleansing, data analysis, and data protection, among others. The focus is on what you really need to know to create the right database for your small business and to leverage it most effectively to spur growth and revenue. Databases for Small Business is a practical handbook for entrepreneurs, managers, staff, and professionals in small organizations who are not IT specialists but who recognize the need to ramp up their small organizations’ use of data and to round out their own business expertise and office skills with basic database proficiency. Anna Manning—a data scientist who has worked on database design and data analysis in a computer science university research lab, her own small business, and a nonprofit—walks you through the progression of steps that will enable you to extract actionable intelligence and maximum value from your business data in terms of marketing, sales, customer relations, decision making, and business strategy. Dr. Manning illustrates the steps in the book with four running case studies of a small online business, an engineering startup, a small legal firm, and a nonprofit organization. Databases for Small Business teaches non-techie entrepreneurs and professionals how to: Design a small business database from scratch Extract the maximum profit from your data Follow guidance on data protection law Effectively use data collection and data cleansing techniques Train staff to leverage your data

Extending SSIS with .NET Scripting

A Toolkit for SQL Server Integration Services

Author: Joost van Rossum,Regis Baccaro

Publisher: Apress

ISBN: 148420638X

Category: Computers

Page: 472

View: 7424

Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. All examples are in both C# and VB.NET, and work for all current versions of SSIS. SSIS is one of the leading ETL, Data Consolidation, and Data Transformation tools in today’s market. SSIS is used by ETL Developers, DBAs and Data Analysts to transform data as required for different ETL processes. There are many built-in components and tasks to help developers to perform actions. For example, there are tasks for sending and receiving files through FTP, sending an email, and for accessing a wide range of database management systems. Yet there are times when developers require a task or component that does not exist and it would make their life much easier if they could create that task or component, and that is what this book it is about. It shows how to write .NET scripts and use the powerful Microsoft .NET library to implement new functionality as needed. Provides a timeless scripting toolkit for all current SSIS versions Gives a comprehensive explanation of scripting in SSIS Offers a wide array of readymade examples for everyday problems

Learning PowerShell

Author: Jonathan Hassell

Publisher: Walter de Gruyter GmbH & Co KG

ISBN: 1501506676

Category: Business & Economics

Page: 215

View: 1511

Learning PowerShell is a custom-built, handcrafted, painstakingly curated book designed to get you from total PowerShell newbie to confident PowerShell user in as little as four weeks. This book assumes no prior knowledge, perfect for non-developers and GUI addicts who recognize that PowerShell is the future but need a good bit of handholding to achieve mastery. It is also a simple guide for the hundreds of thousands of PowerShell users who have not attained the level of PowerShell knowledge that they really need. With Learning PowerShell at your side, you will see that you don't have to be a developer to use PowerShell and you don't need to be a scripting wizard to derive value from integrating PowerShell into your daily administrative activities. The book is a learning resource that covers every topic worth discussing for a PowerShell beginner, with a depth of explanation unparalleled by any book currently on the market. With this book, you don't have to have a lot of time to learn the language and you can begin applying what you master almost immediately. Even skeptics of PowerShell, and command lines in general, will come away with a renewed sense of respect for the language and ideas on how to put it to use.

Pro SQL Server Administration

Author: Peter Carter

Publisher: Apress

ISBN: 1484207106

Category: Computers

Page: 1004

View: 7587

Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014. You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator. Extensive coverage of hybrid cloud environments involving Azure SQL Database Detailed discussions on all new, key features, including AlwaysOn and in-memory support Comprehensive coverage of key skills, such as monitoring, maintenance and indexing