MSSQL

Its is a feature announced with SQL Server 2014. It can be very useful if you have a partition in your database. If you don’t …

COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes …

WAIT_AT_LOW_PRIORITY is a feature introduced with SQL Server 2014. We can control the Online Index Rebuild and switch partition operations. For example, suppose we perform …

Delayed Durability is a feature that introduced with SQL Server 2014. It is a feature that flexs Durability, a common feature of advanced relational databases. …

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

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

If you do not want to send the entire query result to the client, you can use OFFSET and FETCH in SQL Server to specify …

In this article I will describe SQL Server Architecture. In the article, I will proceed through the following image that I received from wikipedia. And …

ACID is the four main rules that relational database management systems (RDBMS) must provide. For more detailed information about relational databases and SQL Server, you …

We can easily perform point-in-time recovery with Database Recovery Advisor. For example, we have a Full backup that has taken at 14:00 PM and we …