AdvancedSQLPuzzles
MachineIntelligence-TextAnalytics-TPLDataFlows
Our great sponsors
AdvancedSQLPuzzles | MachineIntelligence-TextAnalytics-TPLDataFlows | |
---|---|---|
16 | 1 | |
490 | 18 | |
- | - | |
9.2 | 8.8 | |
about 1 month ago | about 2 months ago | |
TSQL | TSQL | |
- | MIT License |
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
-
Not using window functions?
Try advancedsqlpuzzles.com
- I don't see the point in these problems.
- Interview at Square for Data Engineering
- How can I improve my SQL skills if I don't use it in work?
- How do I count the number of series per team?
-
Where can I find exercises to practice my SQL learning?
https://advancedsqlpuzzles.com/ Hackerrank.com Leetcode.com Datalemur.com
- I'm spending a crazy amount of time on hacker rank questions. Is this normal?
-
Looking for more SQL exercises after finishing all the free medium and hard questions on stratascratch
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
- SQL Case Studies to Practice
MachineIntelligence-TextAnalytics-TPLDataFlows
-
An Innovative OpenAI Approach to Crafting a Vector Database in SQL Server using Semantic Kernel
Main GitHub location: source code, developer instructions to get started and more details on the application: https://github.com/bartczernicki/MachineIntelligence-TextAnalytics-TPLDataFlows
What are some alternatives?
sp_whoisactive - sp_whoisactive
CEDS-Data-Warehouse - Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
sql-server-password-secure - Securely storing passwords in SQL-Server for C# and verifying
sqlserver-kit - Useful links, scripts, tools and best practice for Microsoft SQL Server Database
DataAccessGeneration - Better SQL Server stored procedure calls from C#
OpenAI.Net - OpenAI library for .NET
DataEngineeringProject - Example end to end data engineering project.
OpenAI-DotNet - A Non-Official OpenAI RESTful API Client for DotNet
sql-server-maintenance-solution - SQL Server Maintenance Solution
SQL-Server-First-Responder-Kit - sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
dp-300-database-administrator - Repository for lab exercises and instructions for Microsoft DP-300 learning content
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.