Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
SQL Server 2012 with PowerShell V3 Cookbook

You're reading from   SQL Server 2012 with PowerShell V3 Cookbook

Arrow left icon
Product type Paperback
Published in Oct 2012
Publisher Packt
ISBN-13 9781849686464
Length 634 pages
Edition 1st Edition
Concepts
Arrow right icon
Author (1):
Arrow left icon
Donabel Santos Donabel Santos
Author Profile Icon Donabel Santos
Donabel Santos
Arrow right icon
View More author details
Toc

Table of Contents (21) Chapters Close

SQL Server 2012 with PowerShell V3 Cookbook
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
1. Getting Started with SQL Server and PowerShell FREE CHAPTER 2. SQL Server and PowerShell Basic Tasks 3. Basic Administration 4. Security 5. Advanced Administration 6. Backup and Restore 7. SQL Server Development 8. Business Intelligence 9. Helpful PowerShell Snippets SQL Server and PowerShell CheatSheet PowerShell Primer Resources Creating a SQL Server VM Index

What is PowerShell, and why learn another language


PowerShell is both a scripting environment and a scripting language meant to support administrators and developers alike in automating and integrating processes and environments.

You may already be familiar with other tools or languages that help accomplish your task, and you may be asking why you should even bother learning PowerShell. It is important to note that PowerShell is just another tool, but could be a very powerful one if used in the appropriate situations.

There are different reasons for using PowerShell:

  1. Running a script is faster than clicking around the UI:

    If we minimize clicks, or eliminate them in some cases, the task can potentially be done so much faster. Think about compressing, copying, archiving, and renaming multiple files. If we had to rely on the UI, this task may take much longer. However, if we can bake the logic into a script, and run the script once, then the task can be accomplished much faster and more efficiently.

  2. Learning, and mastering, one language instead of five or ten:

    Instead of using a duct-taped mishmash of scripting languages (batch file for some items, VBScript, Perl, COM), we can now use one single language to handle most tasks.

  3. Leveraging the .NET library:

    The .NET library provides a rich collection of classes that pretty much covers most programmatic items you can think of such as forms, database connectivity, networking, and the like.

  4. Taking advantage of the fact that PowerShell is baked into different products:

    More and more Microsoft products are being shipped with a growing number of PowerShell cmdlets because PowerShell scripting is part of Microsoft's Common Engineering Criteria program (http://www.microsoft.com/cec/en/us/cec-overview.aspx#man-windows). Windows Server, Exchange, Active Directory, SharePoint, SQL Server, to name a few, all have some PowerShell support.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image