Convert UTC time to Arabian Standard Time in SQL Server
commit ddcaad9 · authored · 1 min read
SELECT CONVERT(datetime, SWITCHOFFSET(GETUTCDATE(), DATEPART(TZOFFSET,GETUTCDATE() AT TIME ZONE 'Arabian Standard Time'))) AS CreationTimeReplace GETUTCDATE() with your table column that has the UTC time.
Create a database-level user in SQL Server/Azure SQL.
Naming convention for auditing fields in a SQL server table.
Delete duplicate records from a SQL server table without primary keys or any unique columns.
Dapper provides extension methods to execute multiple queries within the same command. The same can be used to execute multiple stored procedures.
Run a SQL Server container with database initialized from a script using docker-compose.
This post contains my personal experiences trying Oracle Database.
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?
blobeater.blog ·
Azure SQL Managed Instance: Boost Performance with Read-Scale Out | All About Tech (opens in a new tab)csharp.com ·
Reduce NULL Storage in SQL Server with Sparse Columns (opens in a new tab)techcommunity.microsoft.com ·
Importing a Database into VS Code - Microsoft Community Hub (opens in a new tab)mssqltips.com ·
New and Enhanced Features in SQL Server 2022 (opens in a new tab)c-sharpcorner.com ·
UNION And UNION ALL SQL Operators (opens in a new tab)azure.microsoft.com ·
Azure SQL Database now supports powerful geo-replication features for all service tiers | Azure Blog and Updates | Microsoft Azure (opens in a new tab)loading discussion…
