2007-04-30 (first published: 2007-04-03)
1,673 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)
178 reads
Blogs
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key...
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2
By Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
Forums
AWS instance storage
We are planning to use one of AWS instance for sql server and wanted...
Insert New Rows in sql based on difference between 2 dates
Hi, I want to create a new records based on the difference between...
COHESITY for Backup/Restore?
Any one have any experience with using Cohesity as the backup/restore platform instead of...
Ask SSC