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?
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.