SqlQueryStress
fluentmigrator
SqlQueryStress | fluentmigrator | |
---|---|---|
3 | 1 | |
887 | 2,696 | |
- | - | |
5.8 | 10.0 | |
about 2 months ago | about 2 years ago | |
C# | C# | |
MIT License | Apache License 2.0 |
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.
SqlQueryStress
-
Security logs for splunk dataset
Sample Log Generator: This tool generates synthetic logs that you can customize to fit your needs. While not real-world data, it can be useful for testing specific scenarios or queries: https://github.com/ErikEJ/SqlQueryStress
-
Over thinking update with rowlock
You could try SqlQueryStress to mock out your database interaction and then increase the threads to see how it handles and then use SP_WhoIsActive to see what you are waiting on while that test is running.
-
Autoscaling Azure SQL Hyperscale
To simulate a simple workload, you can use powerful load testing tools like Locust, K6 or Apache JMeter where you can simulate even the most complex and realistic workload. To create a simple workload, a nice tool originally written by Adam Machanic is also available: SQL Query Stress.
fluentmigrator
-
My first NuGet package - Alt.FluentMigrator.VStudio
There is popular migration tool FluenMigrator to manage database migrations. I decided to create simple powershell commands to be able create, update and rollback migrations from VisualStudio like we do with EF Migrations.
What are some alternatives?
SqlClient - Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications.
LINQ to DB - Linq to database provider.
azure-sql-hyperscale-autoscaler - Autoscaling Azure SQL Database Hyperscale with Azure Functions
rocksdb-sharp - .net bindings for the rocksdb by facebook
SqlKata Query Builder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
employee-sample-database - Employee Sample Database for MySQL and Postgres
monitor-table-change-with-sqltabledependency - Get SQL Server notification on record table change
snowflake-connector-net - Snowflake Connector for .NET
DayZCommunityOfflineMode - A community made offline mod for DayZ Standalone
Alt.FluentMigrator.VStudio - A set of powershell commands which helps to use FluentMigrator framework in Visual Studio via Power Manager Console.
botsv4
SqlBinder - :paperclip: Free and open-source library that helps you create complex and reusable SQL.