DNN Connect 2023 Schedule

Keep your SQL database clean and performant - Part 2

Ola Hallengren's Maintenance Solution and Brent Ozar's First Responder Kit on SQL Server Express

Michael Tobisch
Beginners - Intermediates
Date and Time
5/26/2023 2:00 PM
Room 1

Ola Hallengren's SQL Server Maintenance Solution and Brent Ozar's First Responder Kit are great, free and wide-spread open source tools to keep an SQL Server up and performant. Using PowerShell and the Windows Task Scheduler, I will show you how to
- back up databases
- checking the database integrity
- optimize indexes and
- restore a database
I will discuss some aspects of backup strategies, and other tools provided by the two solutions.

About the speakers

Michael Tobisch
I am an experienced ASP/ASP.Net programmer and using DotNetNuke since some early 3.x version. The main focus of my work is custom modules and integration, SQL Server optimization and security. I have contributed to the community for a long time by answering questions, trying to help people in the forums and the Community Exchange, in workshops etc. I was involved in various DNN events as a speaker, e.g. DNN Connect 2019, Champéry, Switzerland (2019), DNN Connect 2022, Millau, France (2022), DotNetNuke 7 Roadshow, Munich, Germany and Vienna, Austria (2013), German Usergroup Meeting, Stuttgart, Germany (2011), European Day of DotNetNuke, Paris, France (2010), and German Usergroup Meeting, Berlin, Germany (2010). In 2020 and 2021 I was the local co-organizer for the DNN Connect conference (planned in Obergurgl/Austria and cancelled due to the COVID-19 pandemic :-( ) I am also an active member in the DNN Connect Association and the German Speaking Usergroup. I have been a DNN★MVP since 2013.