CoderJony

SQL Server

Exporting and copying SQL Server backup files to Azure Blob Storage using Command Line

Exporting and copying SQL Server backup files to Azure Blob Storage using Command Line

In this post, we will understand how can to export the SQL Server database via the command line and copy it to Azure Blob storage.

Read More By Ankush Jain
Migrate Local SQL Server Database to Azure SQL Database

Migrate Local SQL Server Database to Azure SQL Database

Moving a local SQL Server database to Azure SQL Database is quite straightforward.

Read More By Ankush Jain
Connecting with Azure SQL Database using Azure Active Directory and Managed Identity in .NET Core

Connecting with Azure SQL Database using Azure Active Directory and Managed Identity in .NET Core

Steps to connect Azure SQL with Azure Active Directory

Read More By Ankush Jain
How to loop through a table variable in SQL Server?

How to loop through a table variable in SQL Server?

Let's assume you want to loop through a table variable having the structure like below.

Read More By Ankush Jain
Database Unit Testing for SQL Server using tSQLt

Database Unit Testing for SQL Server using tSQLt

In this blog, I am sharing the key points that I noted while learning the basics of database unit testing for SQL Server.

Read More By Ankush Jain
How to check number of bytes used by a variable in SQL Server?

How to check number of bytes used by a variable in SQL Server?

To check bytes used by a variable in SQL Server, you can use DATALENGTH function.

Read More By Ankush Jain