Expert Scripting and Automation for SQL Server DBAs Apress | Computer Science | August 28, 2016 | ISBN-10: 1484219422 | 284 pages | pdf | 15.06 mb
Authors: Carter, Peter A. Extensive coverage of automation using PowerShell and T-SQL Detailed discussion and examples on metadata-driven automation Comprehensive coverage of automated responses to break/fix scenarios
Microsoft SQL Server 2008 Administration with Windows PowerShell By Ananthakumar Muthusamy, Yan Pan 2009 | 576 Pages | ISBN: 0470477288 | PDF | 9 MB
If you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand.
SQL Server 2012 with PowerShell V3 Cookbook by Santos Donabel English | 25 Oct. 2012 | ISBN: 1849686467 | 634 Pages | PDF | 18 MB
This versatile book is a great work companion if you're a SQL Server database professional who wants to exploit the potential of PowerShell. Dip into the recipes or treat it like a training course - the choice is yours.
Working with temporal data in SQL Server is not supported out of the box. Learn how to implement temporal support in a SQL Server database with all of the constraints needed, and how to optimize your temporal queries.