How to Move System Databases to a New Physical Directory
What is the easiest way to move SQL Server system databases. Let me walk you through it!
2020-05-25
16,678 reads
Kimberly Killian
Centrally collect replication conflicts and send an alert
Automatically capture replication conflicts and generate an automated email notification.
2016-02-05 (first published: 2011-10-17)
3,230 reads
What’s going on, on my server, right now?
Quick and easy way to monitor server activity and be notified from alerts.
2015-02-16 (first published: 2013-07-23)
20,769 reads
When did this DB property Change?
Learn an easy way to determine if and when a database property has changed in any of your databases.
2012-06-06
7,290 reads
Update multiple servers in a single bound
Learn how you can update multiple servers in a single bound with this technique from Kimberly Killian.
2011-10-24
3,731 reads
Are remote databases fragmented? Let's Defrag.
This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.
2011-09-12
3,475 reads
When Did Merge Replication Subscribers Last Sync?
The article presents an automated process to see when remote servers last synced to publisher and send notification reminders.
2011-08-18
1,925 reads
Blogs
Daily Coping 26 Jan 2023
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Working With Tags in FlashArray using PowerShell
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
Using SQL Data Compare from the Command Line with a Project
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Forums
SQL Table Issue
Hi everyone, In below code I am creating a table and inserting some english...
Backup Log Init run again by mistake manually.
backup log to int run every hour. If a log init backup is run...
Ask SSC