Sql-server-maintenance-solution Alternatives

sql-server-maintenance-solution reviews and mentions

• Rookie dba questions on maintenance
  1 project | /r/SQLServer | 7 Dec 2023
• What are your SQL server best practices that you live by?
  2 projects | /r/sysadmin | 6 Jul 2023

  100% this. Separating tempdb has a huge impact, and Ola’s scripts are a must, for anyone who doesn’t know: https://ola.hallengren.com

  1 project | /r/DBA | 6 Jul 2023
• Securing SQL Standard 2019 server
  1 project | /r/sysadmin | 3 Jul 2023

  Since you are new to SQL - https://ola.hallengren.com/ and http://whoisactive.com/downloads/ + https://www.sqlshack.com/monitoring-activities-using-sp_whoisactive-in-sql-server/ will make your SQL experience night and day. Learn these SPs/Tooling.

• Windows environmental variables and maintenance plans
  1 project | /r/MSSQL | 29 Jun 2023

  First, don't use maintenance plans. Full Stop. Use Ola Hallengren's Maintenance Solution or Minion Backup. dbatools even has a way to install and schedule Ola's jobs, including backups. Quick and easy.

• To create a custom text log file using MS SQL server
  1 project | /r/SQL | 26 Jun 2023

  Instead of trying to reinvent the wheel look at https://ola.hallengren.com/

• Slow SCCM Server and Console Performance
  1 project | /r/SCCM | 16 May 2023

  Great advise. I tend to use this for SQL: https://ola.hallengren.com

• Sccm, Wsus pros.
  1 project | /r/SCCM | 6 May 2023

  Ya I use https://ola.hallengren.com for my DB maintenance. I typically have to fix existing non maintained WSUS / SUSDB Sups. I found one the other day with about 20K updates lol

• Automatic backup to Azure blob
  1 project | /r/SQL | 24 Apr 2023

  Install Ola Hallengren's Maintenance Solution and schedule the Agent jobs to run the backups when you need them (and make sure you understand the difference between FULL, LOG and DIFF backups, and when you should use each). Configure it with the URL for your Azure Blob Storage. You will also need to create a Credential for SQL Server to use to authenticate to Azure Blob Storage.

• Hired in to "fix" SCCM. Their build is running without issue (albeit fairly slow) but is quite messy. Where would you start looking to make improvements?
  1 project | /r/SCCM | 12 Apr 2023

  SQL Server database maintenance. You don't need to be a SQL expert - just set it and forget it with this: https://ola.hallengren.com/

• A note from our sponsor - SaaSHub
  www.saashub.com | 26 Apr 2024

  SaaSHub helps you find the best software and product alternatives Learn more →