The Enterprise Scripting Workshop

CBus PASS

<H3>About this Session</H3>
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 the 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.
<UL>
<LI>
Enterprise philosophy: Tackle simple tasks with the whole environment in mind.
</LI>
<LI>
Single data store: Define the benefits and uses of a single central database for common-use data and metadata.
</LI>
<LI>
Choice of tools: Choose the best tool (e.g., PowerShell, T-SQL, SSIS) for the job.
</LI>
<LI>
Environment ground work: Prepare your environment for enterprise scripting.
</LI>
<LI>
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 class
</LI>
</UL>
This session is for data professionals. A basic understanding of PowerShell is helpful, but not required. 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.
<H3>Agenda</H3>
The morning will be spent largely in discussion and lecture, so the attendee has solid scripting principles to build upon. The afternoon session will be spent largely in actual enterprise script development.
Morning: 
<UL>
<LI>
Introducing your enterprise
</LI>
<LI>
Enterprise philosophy
</LI>
<LI>
The ideal SQL shop
</LI>
<LI>
Elements of enterprise scripts
</LI>
</UL>
Afternoon: 
<UL>
<LI>
T-SQL and regular expressions
</LI>
<LI>
Developing the Script
</LI>
<LI>
Applying RegEx
</LI>
</UL>
<H3>About the Presenters</H3>
Sean McCown is a Certified Master in SQL Server and a SQL Server MVP with 20 years of experience in high-end databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight. He is also an international speaker and the creator and author of the wildly popular (and free) Minion Maintenance tools and is President of MinionWare, LLC. 
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, co-hosts the DBAs@Midnight webshow, blogs, reviews, and podcasts. Jen is also an international speaker and co-writes the MinionWare flagship product, Minion Enterprise.

Quest Business Center

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

The Enterprise Scripting Workshop

More events from CBus PASS

Discover more events from CBus PASS, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Columbus and filter by date, category, and more to find the perfect fit.

The Enterprise Scripting Workshop

More events from CBus PASS

Discover more events from CBus PASS, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Columbus and filter by date, category, and more to find the perfect fit.