Database Master Key Error After Database Restore
When restoring a database to another server, you may get a master key error if using symmetric keys
2014-03-31
27,114 reads
Derek Stanley
Removing the Linked Server 2 hop Limitation
This article talks about how you can get around the "Login Failed for user 'NT Authority\ANONYMOUS' LOGON" error when using linked servers and Windows authentication.
2013-12-17
8,520 reads
Blogs
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Seeding an Availability Group Replica from Snapshot
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
Microsoft Build event announcements
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Forums
Starting on Monday
Comments posted to this topic are about the item Starting on Monday
Charindex values of a substring inside a long sentence
I need to gather the starting position of the keyword "sql" from a sql...
BUILDING AN INVENTORY OF SQL SERVERS in Active Directory
We need to scan our entire network to build the list of all machines...
Ask SSC