2007-04-30 (first published: 2007-04-03)
1,679 reads
Checking the REMOTE site of a database-link
When gathering SQL server statistics on ALL our Active SQL servers the script was failing sometime when one of our servers was not reachable for one reason or another.This script is checking if the LINKED SERVER is up and running before executing the "gathering statistics" script for this particular server.
2006-12-25 (first published: 2006-09-29)
182 reads
Blogs
Azure Cosmos DB – HTAP using Azure Synapse Link
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Azure Cosmos DB – HTAP using Synapse Analytics
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Power BI Meets Programmability – TOM, XMLA, and C#
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Forums
AlwaysON on one Node
Hi friends, Is it possible to configure ALwaysON with two instances on one node...
SQL Server Single Instance FCI - Failover Error
I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three...
Disabling all access to the server
Hello everyone! We have a small group of users (4) using MS Access 2000...
Ask SSC