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)
185 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
Drop or delete a existing partition
Hello, so I was reading on partitioning a large table, Which i successfully did,...
PostgreSQL authenticated against Microsoft Active Directory
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
Ask SSC