sql-server-maintenance-solution
SQL Server Maintenance Solution (by olahallengren)
sql-server-password-secure
Securely storing passwords in SQL-Server for C# and verifying (by karenpayneoregon)
| sql-server-maintenance-solution | sql-server-password-secure | |
|---|---|---|
| 47 | 1 | |
| 2,763 | 1 | |
| - | - | |
| 0.0 | 10.0 | |
| 13 days ago | about 1 year ago | |
| TSQL | TSQL | |
| MIT License | - |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sql-server-maintenance-solution
Posts with mentions or reviews of sql-server-maintenance-solution.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-07-06.
- Rookie dba questions on maintenance
-
What are your SQL server best practices that you live by?
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
-
Securing SQL Standard 2019 server
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
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
Instead of trying to reinvent the wheel look at https://ola.hallengren.com/
-
Slow SCCM Server and Console Performance
Great advise. I tend to use this for SQL: https://ola.hallengren.com
-
Sccm, Wsus pros.
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
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?
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/
sql-server-password-secure
Posts with mentions or reviews of sql-server-password-secure.
We have used some of these posts to build our list of alternatives
and similar projects.
-
Passwords in SQL-Server C#
See the following GitHub repository which includes
What are some alternatives?
When comparing sql-server-maintenance-solution and sql-server-password-secure you can also consider the following projects:
dba-dash - DBA Dash - SQL Server Monitoring Tool
sp_whoisactive - sp_whoisactive
SQL-Server-First-Responder-Kit - sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
Sql-Server-DBA-Toolbox - A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
AdvancedSQLPuzzles - Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.
console-apps - Learn how to work with console application, beginner to advance topics
ef-core-transforming - Provides easy to follow transformations/conversions for EF Core
litestream - Streaming replication for SQLite.
sql-server-maintenance-solution vs dba-dash
sql-server-password-secure vs sp_whoisactive
sql-server-maintenance-solution vs SQL-Server-First-Responder-Kit
sql-server-password-secure vs Sql-Server-DBA-Toolbox
sql-server-maintenance-solution vs nocodb
sql-server-password-secure vs AdvancedSQLPuzzles
sql-server-maintenance-solution vs AdvancedSQLPuzzles
sql-server-password-secure vs console-apps
sql-server-maintenance-solution vs sp_whoisactive
sql-server-password-secure vs ef-core-transforming
sql-server-maintenance-solution vs litestream