Know How to Restore SQL Database Without Backup Easily

 Restore SQL Database Without Backup -Step By Step Guide 
Microsoft SQL server is one of the best and the widely used relational database management system. The primary function of this...

SQL Server Management Studio 18.0 is available now.

SSMS 18.0 is available for download now.Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL...

Difference Between Restore with Recovery & Restore with Norecovery

Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...

Calculating DTU's for Azure SQL Database

One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database....

Configure Read only routing for an always on availability group

One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary...

How to Change the File Extension for a Data File

Link Below:

How to Change the File Extension for a Data File

In general, the file extensions for our SQL Data Files...

Changing the Path for the Master Database

Link Below:

Changing the Path for the Master Database
This article will show how we can move the master database to a...

Upgrade SQL Server Evaluation edition to license Edition of SQL Server

 The SQL Server Evaluation Edition is a great way to get a fully functional and free instance of SQL Server for learning and...

Cumulative Update #1 for SQL Server 2017 RTM

The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.
CU#1...

Resolve Network Binding Order Warning in failover cluster

In this post, I’m going to talk about an issue that I found while running the cluster validation report. You...