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
30,455 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,606 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)
21,592 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,405 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,966 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,501 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
2,125 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
BCA KCP Samanhudi | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers