SQL Server

2 snippets, 2 videos, 14 developer stories, 2 tools and 10 posts tagged with “SQL Server”

Style Guide - SQL Server Auditing Column Names
February 05, 2020 · 2 min read

Naming convention for auditing fields in a SQL server table.

SQL Server - Delete Duplicate Rows
December 04, 2019 · 2 min read

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

Dapper - Execute Multiple Stored Procedures
September 05, 2019 · 2 min read

Dapper provides extension methods to execute multiple queries within the same command. The same can be used to execute multiple stored procedures.

Create SQL Server Database From a Script in Docker-Compose
May 21, 2019 · 3 min read

Run a SQL Server container with database initialized from a script using docker-compose.

Microsoft SQL Server Guy Trying Oracle Database
May 08, 2019 · 3 min read

This post contains my personal experiences trying Oracle Database.

Docker - SQL Error on ASP.NET Core Alpine
May 07, 2019 · 2 min read

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?

Filtering, Paging and Sorting in SQL Server 2008
November 22, 2018 · 2 min read

This article provide one solution to achieve server side paging, sorting and filtering in SQL Server 2008.

Pad a number with leading zeros in SQL to make uniform char length
October 01, 2018 · 1 min read

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.

Fetch Row Count for All Tables in a SQL SERVER
March 11, 2018 · 1 min read

Using a short query we can list all the tables in the database along with the number of records in each table.

Determine Total Number of Open/Active Connections in MS SQL Server
September 16, 2017 · 2 min read

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