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
8,272 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,032 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,264 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,249 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,716 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,456 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,819 reads
Blogs
Snowflake in Azure
By Arun Sirpal
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that...
Regression Testing SQL Saturday Naming
By Steve Jones
I started a poll today on the naming for future SQL Saturdays. You can...
Daily Coping 9 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Mercado Español de Muebles de Lujo
Informes de Expertos (IDE) latest report, titled “Mercado Español de Muebles de Lujo, Informe...
Mercado Latinoamericano de los Medicamentos Oncológicos Genéricos
Informes de Expertos (IDE) latest report, titled “Mercado Latinoamericano de los Medicamentos Oncológicos Genéricos,...
Kick starting Extended Events
We have no prior experience of using XE. Yes, our DBA group uses server...
Ask SSC