Title: SQL Server 2014 with PowerShell v5 Cookbook
Publisher: Packt Publishing
Publication Date: 2015
Language: English
ISBN 10: 1785283324
ISBN 13: 9781785283321
Binding: Taschenbuch
Condition: Neu
Dimensions: 235 millimeters width by 191 millimeters height by 41 millimeters depth
Weight: 1392 grams

About this title

Synopsis

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.

About the Author

Donabel Santos

Donabel Santos (SQL Server MVP) is a business intelligence architect, trainer/instructor, consultant, author, and principal at QueryWorks Solutions (http://www.queryworks.ca/), based in Vancouver, Canada. She works primarily with SQL Server for database/data warehouse, reporting, and ETL solutions. She scripts and automates tasks with T-SQL and PowerShell and creates corporate dashboards and visualizations with Tableau and Power BI. She is a Microsoft Certified Trainer (MCT) and an accredited Tableau trainer. She provides consulting and corporate training to clients and also conducts some of Tableau's fundamental and advanced classes in Canada. She is the lead instructor for SQL Server and Tableau (Visual Analytics) courses at British Columbia Institute of Technology (BCIT) Part-time Studies (PTS). She is a self-professed data geek. Her idea of fun is working with data, SQL Server, PowerShell, and Tableau. She authored two books from Packt Publishing: SQL Server 2012 with PowerShell v3 Cookbook, and PowerShell and SQL Server Essentials. She has also contributed to PowerShell Deep Dives, Manning Publications. She blogs at http://sqlbelle.com/ and tweets at @sqlbelle.

"About this title" may belong to another edition of this title.

Store Description

Das Unternehmen AHA-BUCH GmbH: Seit der Gr�ndung von AHA-BUCH im Juli 2005 ist unser Hauptziel, zufriedenen Kunden so schnell und so preisg�nstig wie m�glich ihren B�cherwunsch zu erf�llen. Unsere Firma besch�ftigt 16 Mitarbeiter, die nur ein Ziel kennen: den Kunden und seine W�nsche! Auf �ber 3700 m2 Fl�che haben wir �ber 100.000 B�cher, Modernes Antiquariat und Spiele auf Lager.

Visit Seller's Storefront

Seller's business information

AHA-BUCH GmbH
Garlebsen 48, Einbeck, 37574, Germany

Sale & Shipping Terms

Terms of Sale

General Terms and Conditions and Customer Information / Privacy Policy

I. General Terms and Conditions

� 1 Basic provisions

(1) The following terms and conditions apply to all contracts that you conclude with us as a provider (AHA-BUCH GmbH) via the Internet platforms AbeBooks and/or ZVAB. Unless otherwise agreed, the inclusion of any of your own terms and conditions used by you will be objected to

(2) A consumer within the meaning of the following regulations is any natural person who concludes...

More Information

Right of cancellation

**Right of withdrawal for consumers **

(A consumer is any natural person who concludes a legal transaction for purposes that can predominantly be attributed neither to their commercial nor their independent professional activity.)

Cancellation
Withdrawal
You have the right to revoke this contract within fourteen days without giving reasons.
The revocation period is fourteen days from the day,

on which you or a third party named by you, who is not the carrier, has taken possession of the goods, provided that you have ordered one or more goods within the framework of a uniform order and these are or will be delivered uniformly;
on which you or a third party named by you, who is not the carrier, has taken possession of the last goods, provided that you have ordered several goods within the framework of a single order and these are delivered separately;
on which you or a third party named by you, who is not the carrier, has taken possession of the last partial shipment or the last piece, provided that you have ordered goods that are delivered in several partial shipments or pieces;

In order to exercise your right of withdrawal, you must inform us (AHA-BUCH GmbH, Garlebsen 48, 37574 Einbeck, telephone number: 05563 9996039, fax number: 05563 9995974, e-mail address: service@aha-buch.de) of your decision to revoke this contract by means of a clear declaration (e.B. a letter sent by post, fax or e-mail). You can use the attached model withdrawal form, but this is not mandatory.

To comply with the revocation period, it is sufficient that you send the notification of the exercise of the right of revocation before the expiry of the revocation period.

Consequences of revocation

If you withdraw from this contract, we shall reimburse you all payments that we have received from you, including delivery costs (with the exception of the additional costs resulting from the fact that you have chosen a different type of delivery than the cheapest standard delivery offered by us), immediately and at the latest within fourteen days from the day on which we received the notification of your revocation of this contract.
For this repayment, we will use the same means of payment that you used for the original transaction, unless expressly agreed otherwise with you; in no case will you be charged any fees for this repayment.

We may withhold reimbursement until we have received the goods back or until you have provided proof that you have returned the goods, whichever is the earlier.

You must return or hand over the goods to us immediately and in any case at the latest within fourteen days from the day on which you inform us of the revocation of this contract. The deadline is met if you send the goods before the expiry of the period of fourteen days.

You bear the direct costs of returning the goods.

You only have to pay for any loss of value of the goods if this loss of value is due to handling of the goods that is not necessary to check the nature, characteristics and functioning of the goods.

Reasons for exclusion or extinction

The right of revocation does not apply to contracts

for the delivery of goods which are not prefabricated and for the manufacture of which an individual choice or determination by the consumer is decisive or which are clearly tailored to the personal needs of the consumer;
for the delivery of goods that can spoil quickly or whose expiry date would be exceeded quickly;
for the delivery of alcoholic beverages, the price of which was agreed at the time of conclusion of the contract, but which can be delivered at the earliest 30 days after conclusion of the contract and whose current value depends on fluctuations in the market over which the entrepreneur has no influence;
for the delivery of newspapers, magazines or magazines with the exception of subscription contracts.

The right of revocation expires prematurely in the case of contracts

for the delivery of sealed goods that are not suitable for return for reasons of health protection or hygiene, if their seal has been removed after delivery;
for the delivery of goods if they have been inseparably mixed with other goods after delivery due to their nature;
for the delivery of sound or video recordings or computer software in a sealed package, if the seal has been removed after delivery.

Sample withdrawal form

(If you want to cancel the contract, please fill out this form and send it back.)

To AHA-BUCH GmbH, Garlebsen 48, 37574 Einbeck, fax number: 05563 9995974, e-mail address: service@aha-buch.de :
I/we () hereby revoke the contract concluded by me/us () for the purchase of the following goods ()/
the provision of the following service ()
Ordered on ()/ received on ()
Name of the consumer(s)
Address of the consumer(s)
Signature of the consumer(s) (only in case of notification on paper)
Date

(*) Delete as appropriate.

Shipping Terms

We ship your order after we received them
for articles on hand latest 24 hours,
for articles with overnight supply latest 48 hours.
In case we need to order an article from our supplier our dispatch time depends on the reception date of the articles, but the articles will be shipped on the same day.

Our goal is to send the ordered articles in the fastest, but also most efficient and secure way to our customers.

Shipping rates from Germany to U.S.A.

Shipping rates from Germany to U.S.A.
Order quantity	30 to 40 business days	7 to 14 business days
First item	� 58.36	� 67.07

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.

Detailed Seller Information