SQL Server often requires the need to run tasks during low peak times as well as the automation of tasks such as for data loading, maintenance tasks, and more. The use of SQL Server Agent is key to setting up automation, but what are the best practices and techniques for setting up and managing your scheduled tasks?
Sheehan is a multi-talented technologist with 10 years experience on Oracle RAC running on Linux, UNIX, and Windows. He brings extensive experience performance tuning applications including those migrated to Oracle Exadata Machines. Sheehan also leverages his own development background to guide application developers through code changes to improve application performance.
Herold is a SQL Server, Powershell and automation expert. She’s spoken at several industry events across the country, on topics ranging from SQL Server Best Practices to serving as a panelist for Women In Technology sessions. Her most recent presentations include: Deadlock, Block & Two Smoking Barrels: Breaking Down Blocking and Deadlocks, Beginning Automation with Powershell and Making the Leap from Developer to DBA.