LEADER 03487nam 22005415 450 001 9910254749203321 005 20200704041527.0 010 $a9781484219430 010 $a1484219430 024 7 $a10.1007/978-1-4842-1943-0 035 $a(CKB)3710000000765485 035 $a(DE-He213)978-1-4842-1943-0 035 $a(MiAaPQ)EBC4614818 035 $a(CaSebORM)9781484219430 035 $a(PPN)194517373 035 $a(OCoLC)958879533 035 $a(OCoLC)ocn958879533 035 $a(EXLCZ)993710000000765485 100 $a20160727d2016 u| 0 101 0 $aeng 135 $aurnn|008mamaa 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aExpert Scripting and Automation for SQL Server DBAs /$fby Peter A. Carter 205 $a1st ed. 2016. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2016. 215 $a1 online resource (XVI, 284 p. 132 illus., 127 illus. in color.) 225 1 $aExpert's Voice in SQL Server 300 $aIncludes index. 311 08$a9781484219423 311 08$a1484219422 327 $aIntroduction -- 1. T-SQL Technique for DBAs -- 2. PowerShell Fundamentals -- 3. SQL Server Agent Multi-server Environments -- 4. Metadata Driven Automation.-5. Automation Techniques with SSIS -- 6. Building an Inventory Database -- 7. Automating Instance Builds -- 8. Driving Automation through Monitoring -- 9. Automating Routine Maintenance and Break/Fix Scenarios. . 330 $aAutomate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of your SQL Server enterprise. Expert Scripting and Automation for SQL Server DBAs shows how to automate the SQL Server build processes, monitor multiple instances from a single location, and automate routine maintenance tasks throughout your environment. You will also learn how to create automated responses to common or time consuming break/fix scenarios. The book helps you become faster and better at what you do for a living, and thus more valuable in the job market. 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. 410 0$aExpert's voice in SQL server. 517 3 $aAmplifying your personal productivity and impact as a database administrator 606 $aDatabase management 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 615 0$aDatabase management. 615 14$aDatabase Management. 676 $a005.74 700 $aCarter$b Peter A$4aut$4http://id.loc.gov/vocabulary/relators/aut$0921976 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910254749203321 996 $aExpert Scripting and Automation for SQL Server DBAs$92179945 997 $aUNINA