AdvancedSQLPuzzles vs sp_whoisactive

AdvancedSQLPuzzles

Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them. (by smpetersgithub)

Source Code

advancedsqlpuzzles.com

Suggest alternative

Edit details

sp_whoisactive

sp_whoisactive (by amachanic)

SQL Sqlserver Monitoring

Source Code

Suggest alternative

Edit details

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		sp_whoisactive
	Project
16	Mentions	3
490	Stars	1,103
-	Growth	-
9.2	Activity	0.0
about 1 month ago	Latest Commit	2 months ago
TSQL	Language	TSQL
-	License	GNU General Public License v3.0 only

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

sp_whoisactive

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

SQL not showing active kpid connection
1 project | /r/SQLServer | 22 Apr 2023
Unknown High SQL Server CPU usage
2 projects | /r/SQL | 21 Apr 2023
sp_whoisactive
1 project | /r/SQL | 10 Feb 2023

What are some alternatives?

When comparing AdvancedSQLPuzzles and sp_whoisactive you can also consider the following projects:

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

DataAccessGeneration - Better SQL Server stored procedure calls from C#

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

DataEngineeringProject - Example end to end data engineering project.

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.

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

sql-server-maintenance-solution - SQL Server Maintenance Solution

W3Schools - W3Schools Full Offline Version