Create SQL Server Database From a Script in Docker-Compose

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

In docker, sql-server, May 21, 2019 · 3 min read

Microsoft SQL Server Guy Trying Oracle Database

This post contains my personal experiences trying Oracle Database.

In sql-server, oracle-database, cookbook, 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

Recommended Stories

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

In sql-server, docker, Jun 06, 2019
No Image

Recommended Services

SmarterASP.net - Unlimited ASP.NET Web Hosting

In hosting, sql-server, aspnet,
ASP.NET Hosting by SmarterASP.net. Unlimited ASP.NET Hosting Plans Starting at $2.95 a month.