I have transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication database without affecting the replication configuration.
SQL Saturday comes to Wisconsin and Madison on Apr 21, 2012 with world famous brats for lunch. Sign up for a free day of SQL Server training.
There's an IT skills gap in many companies, which is forcing managers to get creative. Steve Jones says now is the time to look for some cross training at work.
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
Come to a free day of SQL Server training in Houston, TX on Apr 21, 2012.
I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out.
This Friday Steve Jones asks about your on-call responsibilities and the load you face from after hours calls. If you're a DBA that doesn't work strictly 9-5 every week, let us know.
The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world applications. It isn't that easy to come up with a practical, set oriented solution in SQL that gives a near-optimal result.
Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers