000759858 000__ 03352cam\a2200469Ii\4500 000759858 001__ 759858 000759858 005__ 20230306141936.0 000759858 006__ m\\\\\o\\d\\\\\\\\ 000759858 007__ cr\cn\nnnunnun 000759858 008__ 160729s2016\\\\caua\\\\o\\\\\001\0\eng\d 000759858 020__ $$a9781484219430$$q(electronic book) 000759858 020__ $$a1484219430$$q(electronic book) 000759858 020__ $$z9781484219423 000759858 0247_ $$a10.1007/978-1-4842-1943-0$$2doi 000759858 035__ $$aSP(OCoLC)ocn954214905 000759858 035__ $$aSP(OCoLC)954214905 000759858 040__ $$aN$T$$beng$$erda$$epn$$cN$T$$dYDXCP$$dIDEBK$$dEBLCP$$dGW5XE$$dAZU$$dCOO$$dOCLCF 000759858 049__ $$aISEA 000759858 050_4 $$aQA76.6 000759858 08204 $$a005.13$$223 000759858 08204 $$a004 000759858 1001_ $$aCarter, Peter A.$$eauthor. 000759858 24510 $$aExpert scripting and automation for SQL Server DBAs$$h[electronic resource] /$$cPeter A. Carter. 000759858 264_1 $$a[Berkeley, CA] :$$bApress,$$c2016. 000759858 264_2 $$aNew York, NY :$$bDistributed to the book trade worldwide by Springer, 000759858 264_4 $$c©2016. 000759858 300__ $$a1 online resource :$$billustrations. 000759858 336__ $$atext$$btxt$$2rdacontent 000759858 337__ $$acomputer$$bc$$2rdamedia 000759858 338__ $$aonline resource$$bcr$$2rdacarrier 000759858 500__ $$aIncludes index. 000759858 5050_ $$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. . 000759858 506__ $$aAccess limited to authorized users. 000759858 520__ $$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. 000759858 588__ $$aOnline resource; title from PDF title page (SpringerLink, viewed August 9, 2016). 000759858 63000 $$aSQL server. 000759858 650_0 $$aScripting languages (Computer science) 000759858 77608 $$iPrint version:$$z9781484219423 000759858 852__ $$bebk 000759858 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-1943-0$$zOnline Access$$91397441.1 000759858 909CO $$ooai:library.usi.edu:759858$$pGLOBAL_SET 000759858 980__ $$aEBOOK 000759858 980__ $$aBIB 000759858 982__ $$aEbook 000759858 983__ $$aOnline 000759858 994__ $$a92$$bISE