6 Steps to setting up Replication with Mirroring
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
8,517 reads
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
8,517 reads
This powershell script updates the server name specified in connections within a SQL 2005 SSIS package
2011-06-24 (first published: 2011-06-22)
993 reads
2011-06-23 (first published: 2011-06-20)
650 reads
2011-06-22 (first published: 2011-06-14)
1,908 reads
Calculates the latlon coordinates for a given bearing and distance from reference latlon coordinates
2011-06-22
608 reads
Do you verify database backups regularly? If not, you may find this toolbox solution usable.
2011-06-21 (first published: 2011-06-15)
2,035 reads
This script helps to find all columns of an index on a table. Include columns covered (include)
2011-06-17 (first published: 2011-05-31)
1,425 reads
Three different ways that you can get the count of the rows in a table.
2011-06-16 (first published: 2007-08-16)
6,608 reads
To merge data in SQL 2005 from various table, we do not have a MERGE function as in SQL 2008. The following script gives an alternative approach of implementing in SQL 2005
2011-06-15 (first published: 2011-06-03)
1,487 reads
2011-06-14 (first published: 2007-12-05)
6,015 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers