Distribution Database Migration
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
2014-11-20
9,263 reads
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
2014-11-20
9,263 reads
This article shows a problem with P2P replication doesn't replicate DDL schema changes and something you might want to check.
2014-10-16
2,090 reads
2014-04-04
1,662 reads
A drive on a mission-critical server is reaching capacity, and the new DBA is panicking. How do you approach a ballooning log file that won’t stop growing?
2014-03-27
8,204 reads
2014-03-19
1,831 reads
Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.
2020-12-16 (first published: 2014-02-26)
82,179 reads
2014-02-17
1,658 reads
2014-01-22
1,598 reads
2014-01-10
1,677 reads
2013-12-18
1,347 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers