Technical Article

RE: Clone Database

  • Reply

If you need to have the clone db continuosly with the last changes, you should choose between log shipping and replication.  Wich one is better will depend of how much latency you can support.  


2 reads

Technical Article

RE: dynamic source sql string in transformation

  • Reply

If I am understanding you correctly you might try creating a stored procedure that allows a parameter to be passed to it (Credit Score) and stores this in a table. Within the same stored procedure execute (xp_cmdshell) the DTS package modifying it to read from the Credit Score table.


1 reads


Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers