
SESSION DETAILS
Abstract:
The database administrator (DBA) life can be frustrating: You rarely have time to innovate because the same tasks fill up your time day after day. Your users are unhappy about how long it takes to resolve “simple” tickets. You need to put big items on hold to manage special requests. As careful as you are, mistakes creep in the busier you get.
In this pre-conference workshop, learn how to develop enterprise scripts with a huge range of uses. A good set of reusable scripts can reduce task time from hours or days to just a few minutes, and eliminate mistakes from your environment.
• Enterprise philosophy: Tackle simple tasks with the whole environment in mind.
• Single data store: Define the benefits and uses of a single central database for common-use data and metadata.
• Choice of tools: Choose the best tool (e.g., PowerShell, T-SQL, SSIS) for the job.
• Environment ground work: Prepare your environment for enterprise scripting.
• Real-world scripts: Work through dozens of enterprise scripting issues (e.g., alerting, error handling, multiple SQL versions) as you develop a real enterprise script in classThis session is for DBAs with a basic understanding of PowerShell. It’s for anyone who touches backups or security, maintains databases, troubleshoots performance, monitors disk space, or any of a hundred other DBA tasks. Enterprise scripting is for anyone who has more tasks than time.
Session Title: The Enterprise Scripting Workshop
Session Code: DBA-298-P
Session Date: 10/27/2015
Session Room: 6A
PRE-CONFERENCE SCHEDULE:
7:30 – 8:30 | Continental Breakfast |
8:30 – 10:00 | Pre-conference Sessions |
10:00 – 10:15 | Refreshment Break |
10:15 – 12:00 | Pre-conference Sessions |
12:00 – 13:00 | Lunch |
13:00 – 14:30 | Pre-conference Sessions |
14:30 – 14:45 | Refreshment Break |
14:45 – 16:30 | Pre-conference Sessions |
*May not be exactly 100. Might not be actual closest friends, yet.