SQL Server 2014 with PowerShell v5 Cookbook

4 valoración promedio
( 1 valoraciones por Goodreads )
 
9781785283321: SQL Server 2014 with PowerShell v5 Cookbook

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.

"Sinopsis" puede pertenecer a otra edición de este libro.

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.

"Sobre este título" puede pertenecer a otra edición de este libro.

Comprar nuevo Ver libro

Gastos de envío: EUR 4,38
De Reino Unido a Estados Unidos de America

Destinos, gastos y plazos de envío

Añadir al carrito

Los mejores resultados en AbeBooks

1.

Santos, Donabel
Editorial: Packt Publishing (2016)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Paperback Cantidad: 1
Impresión bajo demanda
Librería
Ria Christie Collections
(Uxbridge, Reino Unido)
Valoración
[?]

Descripción Packt Publishing, 2016. Paperback. Estado de conservación: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Nº de ref. de la librería ria9781785283321_lsuk

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 53,08
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 4,38
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Donabel Santos
Editorial: Packt Publishing Limited, United Kingdom (2015)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Paperback Cantidad: 10
Impresión bajo demanda
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción Packt Publishing Limited, United Kingdom, 2015. Paperback. Estado de conservación: New. Language: English . Brand New Book ***** Print on Demand *****.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, 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 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. Nº de ref. de la librería AAV9781785283321

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 57,54
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Donabel Santos
Editorial: Packt Publishing Limited, United Kingdom (2015)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Paperback Cantidad: 10
Impresión bajo demanda
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción Packt Publishing Limited, United Kingdom, 2015. Paperback. Estado de conservación: New. Language: English . Brand New Book ***** Print on Demand *****. 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, 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 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. Nº de ref. de la librería AAV9781785283321

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 59,02
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Donabel Santos
Editorial: Packt Publishing Limited (2015)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Cantidad: > 20
Impresión bajo demanda
Librería
Pbshop
(Wood Dale, IL, Estados Unidos de America)
Valoración
[?]

Descripción Packt Publishing Limited, 2015. PAP. Estado de conservación: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Nº de ref. de la librería IQ-9781785283321

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 57,88
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Donabel Santos
Editorial: Packt Publishing Limited (2015)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Cantidad: > 20
Impresión bajo demanda
Librería
Books2Anywhere
(Fairford, GLOS, Reino Unido)
Valoración
[?]

Descripción Packt Publishing Limited, 2015. PAP. Estado de conservación: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Nº de ref. de la librería LQ-9781785283321

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 52,26
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 10,16
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Donabel Santos
Editorial: Packt Publishing (2015)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Tapa blanda Cantidad: 1
Impresión bajo demanda
Librería
Valoración
[?]

Descripción Packt Publishing, 2015. Estado de conservación: New. This item is printed on demand for shipment within 3 working days. Nº de ref. de la librería GM9781785283321

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 65,58
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,99
De Alemania a Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Santos, Donabel
Editorial: Packt Publishing - ebooks Acco (2017)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Paperback Cantidad: > 20
Impresión bajo demanda
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción Packt Publishing - ebooks Acco, 2017. Paperback. Estado de conservación: New. Never used! This item is printed on demand. Nº de ref. de la librería 1785283324

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 67,57
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,70
A Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Donabel Santos
Editorial: Packt Publishing - ebooks Account (2015)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Paperback Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción Packt Publishing - ebooks Account, 2015. Paperback. Estado de conservación: New. book. Nº de ref. de la librería M1785283324

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 76,34
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Santos, Donabel
Editorial: Packt Publishing - ebooks Account
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos PAPERBACK Cantidad: > 20
Librería
Russell Books
(Victoria, BC, Canada)
Valoración
[?]

Descripción Packt Publishing - ebooks Account. PAPERBACK. Estado de conservación: New. 1785283324 Special order direct from the distributor. Nº de ref. de la librería ING9781785283321

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 78,97
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 5,96
De Canada a Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Donabel Santos
Editorial: Packt Publishing Limited, United Kingdom (2015)
ISBN 10: 1785283324 ISBN 13: 9781785283321
Nuevos Paperback Cantidad: 10
Librería
Book Depository hard to find
(London, Reino Unido)
Valoración
[?]

Descripción Packt Publishing Limited, United Kingdom, 2015. Paperback. Estado de conservación: New. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. 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, 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 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. Nº de ref. de la librería LIE9781785283321

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 85,78
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda