Certificates used for TDE and Certificates used to encrypt a database backup will be in the master database. They are not included in the user database backup.

Certificates that have been...

Is there any way besides the Configuration Manager GUI to find out what SSL certificate is bound to the MSSQLSERVER network protocols?

Check the registry for what is configured. Fire up...

An SSL certificate is for communication between two different endpoints. The worst that could happen is the Primary won't connect to the Secondary, and things will look like they do...

A backup stripe set is a database backup taken to multiple backup files. The above 200GB block blob max size is your guide - use enough files to keep each...

Go to where the backups were created and look to see if you're grabbing the right certificate:

SELECT * FROM master.sys.certificates WHERE thumbprint = 0x477BB40D3618B2E162F70B62693D11F6FA3A360F

When you split a partition with data in it, the engine must scan the partition's rows to determine which rows will go into the new partition. Even in cases such...

The gold nugget in that error message is the \KB3045321\ in the path. 'KB' and a bunch of numbers means 'Knowledge Base article ######'.

1. Go search on Microsoft.com for "KB3045321"....

Use IDENTITY_INSERT:

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-identity-insert-transact-sql?view=sql-server-ver15

SET IDENTITY_INSERT [YourTableName] ON;

INSERT [YourTableName](ColumnID, ID, ColumnName)
SELECT 515, 13, 'DriverID';

SET IDENTITY_INSERT [YourTableName] OFF;

Want to learn something well? Then figure out how to teach it. Think you know something? Offer to stand in front of a room of your peers - who can...

> Okay, so it does work with the port number. Now how do I get it to connect without the port number?

Start the SQL Browser service.

Connecting is expensive. Staying connected is cheap. I'm not sure about SQL Server 2014, but a connection in prior versions consumed only 32KB of memory.

Check sys.dm_exec_sessions.last_request_end_time for the connections. If...

Selecting every 10th record means selecting every row where the row_number divides evenly by 10, as in, when you divide the row_number by 10, the remainder will be 0.

WHERE RowNumber...

Check the AG replicas. The Primary can't flush the log until the transactions have been replicated to all AG secondary replicas.

When primary DataCentre DC1 goes down including SQL07P &SQL08P server , How should I perform failover as SQL06P node in DC2  , failover mode is in Manual mode?

I think I...

The key aspect of running a SQL Server Failover Clustering Instance (FCI) is that it runs on a Windows Failover Cluster.

The host cluster must be built and configured (including the...