Pro PowerShell for Database Developers
Pro PowerShell for Database Developers

Author: Bryan P. Cafferky

Publisher: Apress

Published: 2015-10-17

Total Pages: 419

ISBN-13: 1484205413

DOWNLOAD EBOOK

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.

Databases for Small Business
Databases for Small Business

Author: Anna Manning

Publisher: Apress

Published: 2015-11-21

Total Pages: 319

ISBN-13: 1484202775

DOWNLOAD EBOOK

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

Pro PowerShell for Microsoft Azure
Pro PowerShell for Microsoft Azure

Author: Sherif Talaat

Publisher: Apress

Published: 2015-11-24

Total Pages: 215

ISBN-13: 1484206657

DOWNLOAD EBOOK

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.

Pro Exchange 2013 SP1 PowerShell Administration
Pro Exchange 2013 SP1 PowerShell Administration

Author: Michel de Rooij

Publisher: Apress

Published: 2014-12-19

Total Pages: 628

ISBN-13: 1430268476

DOWNLOAD EBOOK

Pro Exchange 2013 SP1 PowerShell Administration is your one-stop resource for both basic and advanced administration of Exchange Server 2013 Service Pack 1 and Exchange Online, Microsoft's best-selling hosted Exchange service. The industry shift that is currently happening toward ‘the cloud’ is not just about hosting your applications somewhere else. It’s also driving automation and standardization of technical solutions, which in turn is leading to greater productivity. Embracing PowerShell will help you administer your existing environment more efficiently and also teach you valuable ‘cloud-ready’ skills as well. This book is your best-in-class companion for gaining a deep, thorough understanding of managing all facets of Exchange 2013 Service Pack 1 with PowerShell. Authors Michel de Rooij and Jaap Wesselius, both Microsoft messaging MVPs, take you through tips, tricks, and little known facts that will make your administration life simpler and more effective. Along with revealing what’s new in Exchange Server 2013, this well-paced, deeply engaging tutorial provides detailed deployment guidance, for upgraders and migrators as well as for organizations entirely new to the Exchange platform. The book details how all of the major Exchange components fit together, from SMTP messages to all kinds of clients. It also provides in-depth configuration examples with an eye toward creating scalable, reliable, and secure installations. Additionally, this guide covers the tools and techniques for monitoring an Exchange environment and troubleshooting when things go wrong. Discover how to automate time consuming management tasks, configure a Hybrid environment with an on-premises Exchange deployment, and more today with Pro Exchange 2013 SP1 PowerShell Administration. Teaches you the basics of PowerShell and provides a foundation for more advanced scripting Deploy an Office 365 tenant in hybrid mode with your existing Exchange servers Learn how to manage Exchange Online with Remote PowerShell

Professional SharePoint 2010 Development
Professional SharePoint 2010 Development

Author: Thomas Rizzo

Publisher: John Wiley & Sons

Published: 2012-03-06

Total Pages: 840

ISBN-13: 1118238680

DOWNLOAD EBOOK

Updated guidance on how to take advantage of the newest features of SharePoint programmability More than simply a portal, SharePoint is Microsoft's popular content management solution for building intranets and websites or hosting wikis and blogs. Offering broad coverage on all aspects of development for the SharePoint platform, this comprehensive book shows you exactly what SharePoint does, how to build solutions, and what features are accessible within SharePoint. Written by a team of SharePoint experts, this new edition offers an extensive selection of field-tested best practices that shows you how to leverage the vast power of this multi-faceted tool to build custom workflow and content management applications. Plus, you'll discover how to take advantage of the new features to roll out new SharePoint sites or upgrade existing sites. Keeps you thoroughly up to date on all the most recent changes to SharePoint 2010 Reveals broad and deep coverage of social media features, content management applications, enterprise search, business connectivity services, user experience development, and custom workflow Examines SharePoint Server 2010 vs. SharePoint Foundation Server Highlights ways you can take advantage of improvements to offline and mobile client capabilities, improvements to SQL Server table support, Cloud-based offerings with Azure integration, social networking additions, and more Professional SharePoint 2010 Development, Second Edition presents you with authoritative coverage on all aspects of development for the SharePoint platform.

Professional SQL Server 2012 Internals and Troubleshooting
Professional SQL Server 2012 Internals and Troubleshooting

Author: Christian Bolton

Publisher: John Wiley & Sons

Published: 2012-10-18

Total Pages: 578

ISBN-13: 1118240278

DOWNLOAD EBOOK

Hands-on troubleshooting methods on the most recent release of SQL Server The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server. Covers the core technical topics required to understand how SQL Server and Windows should be working Shares best practices so that you know how to proactively monitor and avoid problems Shows how to use tools to quickly gather, analyze, and effectively respond to the source of a system-wide performance issue Professional SQL Server 2012 Internals and Troubleshooting helps you to quickly become familiar with the changes of this new release so that you can best handle database performance and troubleshooting.

Professional Microsoft SQL Server 2008 Programming
Professional Microsoft SQL Server 2008 Programming

Author: Robert Vieira

Publisher: John Wiley & Sons

Published: 2010-09-29

Total Pages: 938

ISBN-13: 0470632097

DOWNLOAD EBOOK

This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Server 2005 and SQL Server 2000. These versions are old enough that there is little to no time spent on them except in passing. The book is oriented around developing on SQL server. Most of the concepts are agnostic to what client language you use although the examples that leverage a client language general do so in C#. For those who are migrating from early versions of SQL Server, some “gotchas” that exist any time a product has versions are discussed to the extent that they seem to be a genuinely relevant issue. This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused. While there is a quick reference-oriented appendix, there is very little coverage given to beginner level topics. It is assumed that you already have experience with data manipulation language (DML) statements and know the basics of the mainstream SQL Server objects (views, stored procedures, user defined functions, etc.). If you would like to brush up on your knowledge before diving into this book, the author recommends reading Beginning SQL Server 2008 Programming first. There is very little overlap between the Beginning and Professional books and they are designed to work as a pair.

Pro SQL Server Administration
Pro SQL Server Administration

Author: Peter Carter

Publisher: Apress

Published: 2015-11-16

Total Pages: 1008

ISBN-13: 1484207106

DOWNLOAD EBOOK

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

Pro PowerShell for Amazon Web Services
Pro PowerShell for Amazon Web Services

Author: Brian Beach

Publisher: Apress

Published: 2019-09-21

Total Pages: 539

ISBN-13: 1484248503

DOWNLOAD EBOOK

Amazon Web Services (AWS) is the leading public cloud platform. In this book you will learn to use Microsoft PowerShell to create, host, manage, and administer workloads using Amazon Web Services. You will learn how to create virtual machines, provision storage, configure networks, and more—all using your preferred Windows scripting language. CIOs everywhere are leading their organizations to the cloud, but there are few books available to help. This book focuses on moving Microsoft Windows workloads to the cloud using technologies familiar to enterprise Microsoft-based professionals. The completely revised and expanded Pro PowerShell for Amazon Web Services is written specifically for Windows professionals who already know PowerShell and want to learn to host Windows workloads on Amazon Web Services. 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. New chapters in this second edition cover: AWS Lambda, Amazon WorkSpaces, Amazon AppStream 2.0, AWS Directory Service, Amazon WorkDocs, and AWS System Manager. What You'll Learn Create and manage Windows servers on Elastic Compute Cloud (EC2) Configure and secure networks with Virtual Private Cloud (VPC) Leverage autoscaling to adjust resources as load changes Deploy and manage SQL Server using the Relational Database Service (RDS) Manage virtual desktops using WorkSpaces and AppStream Leverage AWS Systems Manager to manage Windows at scale Who This Book Is For Windows professionals who want to learn more about Amazon Web Services, with a focus on running Windows workloads and automated management at scale using PowerShell tools for AWS. The book assumes you have knowledge of Windows and PowerShell, but are new to AWS.

Automating Microsoft Windows Server 2008 R2 with Windows PowerShell 2.0
Automating Microsoft Windows Server 2008 R2 with Windows PowerShell 2.0

Author: Matthew Hester

Publisher: John Wiley & Sons

Published: 2011-05-04

Total Pages: 407

ISBN-13: 1118103084

DOWNLOAD EBOOK

Learn to automate the top server operating system, Windows Server 2008 R2 Windows PowerShell 2.0 allows you to automate nearly any task for managing Windows Server, going from dozens of clicks to a single command, and repeated tasks to automated tasks. Using screen shots and helpful exercises, this book walks you through the many benefits of automating Windows Server with PowerShell 2.0, such as allowing for scalable, flexible, and rapid deployments and changes; increasing cost effectiveness; providing a timely return on IT investment; lowering labor headcount; creating secure computing environments; and establishing reliable enterprise infrastructures. In addition, real-world examples provide reinforced learning, aimed at ensuring that you work as efficiently and effectively as possible by automating both simple and complex administrative tasks with Powershell 2.0. Explains how to automate both simple and complex tasks in Windows Server 2008 R2 with Powershell 2.0 Addresses how Windows Server 2008 R2 comes with more than 550 cmdlets, allowing you to automate nearly anything Offers numerous real-world examples, end-of-chapter exercises, and helpful screen shots to reinforce your learning process The power is in your hands! Start working smarter, not harder, by automating Windows Server 2008 R2 tasks with Powershell 2.0.