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
17,154 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,246 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,832 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,732 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,477 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,932 reads
Blogs
Converting Types in C#
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Forums
Weird chars at beginning of XML file
Hi, each day we are sent an email with an XML attachment. Recently the...
Query based on sorting based on month
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
SSRS 2017 - SSRS 2019 migration
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Ask SSC