Category: MSSQL

How To Restore a Backup From URL(Backup On Azure Storage)

In this article, I will explain how to restore a backup on Azure Storage to a local sql instance. Before

With SQL Server 2014, we are able to back up a database to a URL via SSMS. In fact, this

If you do not want to send the entire query result to the client, you can use OFFSET and FETCH

In this article I will describe SQL Server Architecture. In the article, I will proceed through the following image that

ACID is the four main rules that relational database management systems (RDBMS) must provide. For more detailed information about relational

We can easily perform point-in-time recovery with Database Recovery Advisor. For example, we have a Full backup that has taken

User Defined Function is a feature of SQL Server that takes parameters like a programming language functions and returns a

Before you read this article, I recommend that you read the article “What is Data-Tier Application” to avoid confusion. In

Data-Tier Application Version 1.1 (DAC) was introduced with SQL Server 2008 R2. With Data-Tier Application, we are able to transfer

IntelliSense was introduced with SQL Server 2008. With this feature, we can now write TSQL Code in a more practical