SQL Server

Create SQL Server Database From a Script in Docker-Compose

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

May 21, 2019 · 3 min read

Microsoft SQL Server Guy Trying Oracle Database

This post contains my personal experiences trying Oracle Database.

May 08, 2019 · 3 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?

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.

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.

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.

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

September 16, 2017 · 2 min read

Recommended Stories

Enter data privacy. Exit SQL Server 2008.

SQL Server 2008 and SQL Server 2008 R2 are out of extended support as of July 2019, but the end of bug fixes, security updates and ongoing support has far-reaching data privacy implic...

Jun 30, 2019
SQL Server

How to Connect to Your Local SQL Server From Inside Docker

If you are running an ASP.NET Core application from Docker and connecting to a SQL Server running on your PC then you might find you can't connect to it. In this post we'll look at wh...

Jun 06, 2019
SQL Server

Recommended Services - Unlimited ASP.NET Web Hosting

ASP.NET Hosting by Unlimited ASP.NET Hosting Plans Starting at $2.95 a month.