Delete duplicate records from a SQL server table without primary keys or any unique columns.
4 developer stories, 1 tool and 9 posts tagged with “SQL Server”
Dapper provides extension methods to execute multiple queries within the same command. The same can be used to execute multiple stored procedures.
Run a SQL Server container with database initialized from a script using docker-compose.
This post contains my personal experiences trying Oracle Database.
Having trouble to connect to a remote SQL server from an ASP.NET Core app running on top of Alpine dotnet on a linux container?
This article provide one solution to achieve server side paging, sorting and filtering in SQL Server 2008.
When you are in need of transforming a number to have some character to be prefixed in order to make the chars in the number a specific number long, here is one way to do it.
Using a short query we can list all the tables in the database along with the number of records in each table.
This article contains a SQL query which can be used to determine the total number of open/active connections in MS SQL Server. Also explains, how to solve the error "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."