#sql-server

SQL Server

posts: 10
snippets: 2
stories: 20
videos: 6
tools: 2

git log -- sql-server

2020-02-05
Style Guide - SQL Server Auditing Column Names
Naming convention for auditing fields in a SQL server table.

sql-server style-guide
2019-12-04
SQL Server - Delete Duplicate Rows
Delete duplicate records from a SQL server table without primary keys or any unique columns.

sql-server
2019-09-05
Dapper - Execute Multiple Stored Procedures
Dapper provides extension methods to execute multiple queries within the same command. The same can be used to execute multiple stored procedures.

dapper sql-server orm
2019-05-21
Create SQL Server Database From a Script in Docker-Compose
Run a SQL Server container with database initialized from a script using docker-compose.

docker sql-server
2019-05-08
Microsoft SQL Server Guy Trying Oracle Database
This post contains my personal experiences trying Oracle Database.

sql-server oracle-database cookbook
2019-05-07
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?

aspnet-core docker sql-server
2018-11-22
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.

sql-server
2018-10-01
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.

sql-server
2018-03-11
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.

sql-server
2017-09-16
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."

entity-framework sql-server