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 new location.
The ALTER DATABASE command would work for moving...
2018-01-11
6 reads
Ganapathi's MSSQLLover
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...
2017-12-01
67,694 reads
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 developing solutions. The edition has a built in expiry...
2017-12-01
4 reads
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...
2017-10-27
519 reads
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 KB Article: https://support.microsoft.com/en-us/help/4038634/cumulative-update-1-for-sql-server-2017
Microsoft® SQL Server® 2017 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=56128
2017-10-27
4 reads
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...
2017-07-22
1,593 reads
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 may receive below warning message that includes information about...
2017-07-22
8 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica...
2017-04-18
1,716 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group. This error mostly appears when we...
2017-04-18
10 reads
Step by Step Configuring a Dedicated Network for Availability Group
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage...
2017-04-10
863 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers