SQL Server

Naming convention for auditing fields in a SQL server table.

Delete duplicate records from a SQL server table without primary keys or any unique columns.

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."