Reputation
1,795
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 11 27
Impact
~144k people reached

1d
comment How to Replicate data between a hosted database and a local database
Agree with @Kin with your set of limitations your best bet is going to be SSIS. However I will say that A: the dev cost on this will not be cheap depending how many tables you have. B: You'll have to account for schema changes. C: It won't be real time. D: there will be load costs on both servers.
Jan
27
comment Is there a recommended for the database-to-DBA ratio?
This might help to some extent.
Jan
20
awarded  Notable Question
Jan
15
comment Use a SP to Archive/Revision related records in several related tables?
Are you talking about structural changes to your database as in DDL changes? Or are you talking about a user updating a particular row, DML?
Jan
13
comment SSIS 2012 metadata not refreshing on re-deploy
What happens if you set you connection dynamically, either via getting the connection prior to run time or setting it with a Config file? Also how are you calling these packages?
Jan
5
awarded  Famous Question
Jan
5
comment Migration script fires 'The data definition language (DDL) command cannot be executed at the Subscriber'
But the script has to be different because otherwise you wouldn't need to add that column because you would have added it yesterday.
Jan
5
comment Job not running on Schedule
TLDR: Wasn't paying attention and did something stupid.
Jan
5
accepted Job not running on Schedule
Jan
5
awarded  Nice Question
Dec
23
comment Job not running on Schedule
Okay when It was originally set up it was running as the service account. It's since been changed to a different account and is running fine.
Dec
23
asked Job not running on Schedule
Dec
16
comment Problem creating a transaction in an SSIS package
@KennethFisher try putting them in a sequence container that has a required tran.
Dec
16
comment Problem creating a transaction in an SSIS package
yeah. All items are in a sequence containers correct?
Dec
11
comment Problem creating a transaction in an SSIS package
What method are you using to set your transaction in the SSIS package?
Dec
8
comment How to import blanks as nulls instead of zeros while importing txt using wizard
You could make a proper SSIS package? There are a ton of solutions that don't involve the wizard.
Nov
13
comment Should I shrink this SQL Server data file?
I fully endorse this course of action.
Nov
12
comment “begin transaction” yields error
Does commit the full Commit Transaction? I'm kind of taking a stab in the dark here as I was 12 when 7.0 came out....
Nov
10
awarded  Enlightened
Nov
5
comment What are the benefits vs. drawbacks to using a clustered index in SQL Server
Not to mention then you either have to make your other indexes either covering or you're going to have to do a ton of key look ups and those aren't cheap either.