Updatable Subscriptions Deprecated in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,038 reads
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,038 reads
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
2,005 reads
There's nothing more I love than free food and SQL Server, no joke. I take my free food and SQL...
2011-09-14
528 reads
To troubleshoot replication agent failures, replication agent profiles can be configured to output verbose agent logs to a text file. ...
2011-08-24
4,421 reads
Did you know a snapshot can be applied using the Distribution and Merge Agent –AltSnapshotFolder parameter? This means that after...
2011-08-03
552 reads
When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION. In some cases, we might...
2011-07-29
7,751 reads
Brad McGehee over at SQL Aloha posted his July Question: What Do You Think are the Most Common DBA Pain...
2011-07-02
868 reads
When configuring Merge Replication for Web Synchronization it's common to encounter the error The Proxy Auto-configuration URL was not foundand
...
2011-06-23
1,351 reads
Have you made the mistake of dropping your distribution database like this?
If so, remember not to do this ever again. ...
2011-05-28
2,033 reads
One caveat that’s worth mentioning is replicating the XML data type in
SQL Server using Merge Replication. Sometimes, when replicating...
2011-05-20
1,415 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. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
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