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
14,841 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,159 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,594 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,272 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,727 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,470 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,906 reads
Blogs
Cloud Formations – A New MVP Led Training Initiative
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Columnstore Index Limits in SQL Server 2019
Comments posted to this topic are about the item Columnstore Index Limits in SQL...
How to use Images in Power BI Report Builder
Comments posted to this topic are about the item How to use Images in...
How to handle sticks on column country1 and country2 columns ?
I work on sql server 2017 i have table data as below i need...
Ask SSC