Microsoft SQL Server Guy Trying Oracle Database

This post contains my personal experiences trying Oracle Database.

In sql-server, oracle-database, May 08, 2019 · 2 min read

Docker - SQL Error on ASP.NET Core Alpine

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?

In aspnet-core, docker, sql-server, May 07, 2019 · 2 min read

Filtering, Paging and Sorting in SQL Server 2008

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

In sql-server, November 22, 2018 · 2 min read

Pad a number with leading zeros in SQL to make uniform char length

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.

In sql-server, October 01, 2018 · 1 min read

Fetch Row Count for All Tables in a SQL SERVER

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

In sql-server, March 11, 2018 · 1 min read

Determine Total Number of Open/Active Connections in MS SQL Server

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

In entity-framework, sql-server, September 16, 2017 · 2 min read