Donabel Santos

PowerShell for SQL Server Essentials (eBook, PDF)

• Format: PDF

Produktbeschreibung

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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Packt Publishing
• Seitenzahl: 186
• Erscheinungstermin: 25. Februar 2015
• Englisch
• ISBN-13: 9781784397104
• Artikelnr.: 56794489

Autorenporträt

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, 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 in Manning Publications' PowerShell Deep Dives. Her blog is located at www.sqlbelle.com and her Twitter handle is @sqlbelle.