PowerShell for SQL Server Essentials

PowerShell for SQL Server Essentials9781784391492

PowerShell for SQL Server Essentials
by 作者: Donabel Santos
ISBN-10 书号: 1784391492
ISBN-13 书号: 9781784391492
Publisher Finelybook 出版日期: 2015-02-26
Pages: 183


Book Description
PowerShell for SQL Server Essentials helps us to manage and monitor server administration and application deployment. Use PowerShell along with SQL Server to perform common DBA tasks.Starting with a basic introduction to PowerShell,the initial chapters will provide the SQL Server professional PowerShell fundamentals,covering topics such as PowerShell notations and syntax,cmdlets,pipeline,and getting help. Succeeding chapters build upon these fundamentals,and illustrate how to administer and automate SQL Server. Tasks covered throughout include profiling the SQL Server instance,performing backup and restores,invoking T-SQL scripts using PowerShell,and monitoring jobs,security,and permissions.Packed with practical examples and numerous ready-to-use snippets,this book gets you to an intermediate level in using PowerShell for SQL Server.
Contents
1: GETTING STARTED WITH POWERSHELL
2: USING POWERSHELL WITH SQL SERVER
3: PROFILING AND CONFIGURING SQL SERVER
4: BASIC SQL SERVER ADMINISTRATION
5: QUERYING SQL SERVER WITH POWERSHELL
6: MONITORING AND AUTOMATING SQL SERVER

What you will learn
Create scripts using PowerShell to manage and monitor server administration and application deployment
Automate the creation of SQL Database objects through PowerShell with the help of the SQL Server module (SQLPS) and SQL Server snap-ins
Use PowerShell to work with SQL Server specific providers and cmdlets
Identify and manage SQL Server services,instances,settings,and confi gurations
Profile your SQL Server instances and export current configurations to a file
Monitor SQL Server jobs and alerts
Manage logins,database users,and instance security and permissions
Invoke T-SQL queries from PowerShell and export results
Accomplish tasks from your DBA daily/weekly/monthly/yearly checklists with PowerShell
Authors
Donabel Santos
Donabel Santos is a self-confessed data geek. She loves working with data,writing queries,and developing reports on her SQL Server databases,and exploring and visualizing data with Tableau.
She is the principal and senior Business Intelligence Architect at QueryWorks Solutions,a Tableau Learning and Alliance partner in Vancouver,BC,Canada providing consulting and training services. She has spent years in consulting and has developed a variety of solutions for clients in different verticals—finance,manufacturing,healthcare,legal,higher education,and local government.
Donabel is a multi-year Microsoft Data Platform MVP (previously known as SQL Server MVP) and has extensive experience in SQL Server in different areas,such as development,administration,data warehouse,reporting (SSRS),tuning,troubleshooting,XML,CLR,and integration with ERPs and CRMs using PowerShell,C#,SSIS,and Power BI.
One of Donabel's passions is teaching and sharing her love for data. She is a Tableau Certified Professional and a Tableau Accredited Trainer,delivering Tableau public and on-site client training. She is also the lead instructor for a number of courses at British Columbia Institute of Technology (BCIT),including Applied Database Administration and Design (ADAD) and Applied Data Analytics (ADA) programs. She teaches SQL Server Administration,Development,Integration (SSIS),Data Warehouse Foundations,and Visual Analytics with Tableau.
Donabel has also authored three other books with Packt Publishing: SQL Server 2012 with PowerShell V3 Cookbook,PowerShell for SQL Server Essentials,and SQL Server 2014 with PowerShell V5 Cookbook. She also contributed a chapter to Manning Publications' PowerShell Deep Dives. Her blog is located at http://www.sqlbelle.com and her Twitter handle is @sqlbelle.

下载地址 Download
打赏
未经允许不得转载:finelybook » PowerShell for SQL Server Essentials

相关推荐

  • 暂无文章

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

觉得文章有用就打赏一下

您的打赏,我们将继续给力更多优质内容

支付宝扫一扫打赏

微信扫一扫打赏