MSSQL

First of all, upgrade is an important task. Before upgrading, you must check your database is ready to upgrade with the help of Database Migration Assistant. You can find detailed …

You may receive this error if you want to make a change in SQL Server Configuration Manager. Depending on the version of SQL Server you are using, copy the following …

You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different methods to perform this. One of method is linked server. …

With DBCC SHOW_STATISTICS we can get detailed information about a statistic. As many of you know, statistics have one of the most important roles in the decision making of the …

This is very interesting case. One day we saw that a database is not accessible in a failover cluster due to an offline disk. And we examine the event log …

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 have a partition, it won’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 with this option. For example, …

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 Online Index Rebuild operation. The …

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. You may want to read …

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 should read the article “How …