AdvancedSQLPuzzles vs sql-server-maintenance-solution

Our great sponsors

InfluxDB - Power Real-Time Data Analytics at Scale

WorkOS - The modern identity platform for B2B SaaS

SaaSHub - Software Alternatives and Reviews

Our great sponsors

AdvancedSQLPuzzles		sql-server-maintenance-solution
	Project
16	Mentions	47
490	Stars	2,756
-	Growth	-
9.2	Activity	0.0
about 1 month ago	Latest Commit	3 days ago
TSQL	Language	TSQL
-	License	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.

AdvancedSQLPuzzles

Posts with mentions or reviews of AdvancedSQLPuzzles. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-02-15.

Not using window functions?
1 project | /r/dataengineering | 4 Jul 2023

Try advancedsqlpuzzles.com
I don't see the point in these problems.
1 project | /r/SQL | 10 May 2023
Interview at Square for Data Engineering
1 project | /r/dataengineering | 23 Mar 2023
How can I improve my SQL skills if I don't use it in work?
1 project | /r/datascience | 17 Mar 2023
How do I count the number of series per team?
1 project | /r/SQL | 19 Feb 2023
Where can I find exercises to practice my SQL learning?
1 project | /r/learnSQL | 16 Feb 2023

https://advancedsqlpuzzles.com/ Hackerrank.com Leetcode.com Datalemur.com
I'm spending a crazy amount of time on hacker rank questions. Is this normal?
2 projects | /r/SQL | 15 Feb 2023
Looking for more SQL exercises after finishing all the free medium and hard questions on stratascratch
1 project | /r/SQL | 3 Feb 2023

Try this GitHub repository. It has a PDF of 50+ advanced puzzles that are nicely written, along with the solutions in a separate sql script.
Looking for advanced SQL resources
1 project | /r/learnSQL | 19 Jan 2023
SQL Case Studies to Practice
1 project | /r/SQL | 15 Jan 2023

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
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/

What are some alternatives?

When comparing AdvancedSQLPuzzles and sql-server-maintenance-solution you can also consider the following projects:

sp_whoisactive - sp_whoisactive

dba-dash - DBA Dash - SQL Server Monitoring Tool

sql-server-password-secure - Securely storing passwords in SQL-Server for C# and verifying

SQL-Server-First-Responder-Kit - sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

DataAccessGeneration - Better SQL Server stored procedure calls from C#

nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative

DataEngineeringProject - Example end to end data engineering project.

MachineIntelligence-TextAnalytics-TPLDataFlows - Machine Intelligence using OpenAI, Semantic Kernel, Vector Search, SQL Server

dp-300-database-administrator - Repository for lab exercises and instructions for Microsoft DP-300 learning content

litestream - Streaming replication for SQLite.