- Status
- Accepted
- Level
- Beginners - Intermediates
- Capacity
- 25
- Date and Time
- 5/26/2023 2:00 PM
- Location
- 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.