Viewing 15 posts - 76 through 90 (of 205 total)
I agree with all of your points. I have done the Kimball method before. My boss, is very technical and has substantial experience with the Microsoft stack. ...
June 19, 2014 at 9:38 am
I totally agree with you. Let me start from the beginning.
We are working on a data warehouse. The data warehouse will have a star schema that has not...
June 18, 2014 at 5:38 pm
I was considering having a different staging database for each source because the boss wants this one staging database to be an exact replica of this one source. However,...
June 18, 2014 at 11:08 am
Okay, so should I rely strictly on SQL Agent Jobs or should I use SSIS? There will be many data sources for the data warehouse, and this particular source...
June 18, 2014 at 10:31 am
We are using SSIS 2012, which has the project deployment model. Will having several packages affect the deployment vs. one package?
June 16, 2014 at 10:40 am
Thanks for the reply. I think we will need to do the backup/restore once or twice a day. What's the best way to automate this?
June 16, 2014 at 10:39 am
I like the rowcount transformation/Execute SQL Task option. What do you mean by logging with Execute SQL? How would I do it?
June 10, 2014 at 10:36 am
Can I just create a view and let someone update the underlying table using the view?
Locking shouldn't be an issue. This is just a staging table we're talking about.
April 23, 2013 at 2:40 pm
Okay, what's the best way to disable mirroring? 🙂
Let me explain the situation. The system being tested is based on a data warehouse. First, we have SSIS packages...
January 29, 2013 at 10:56 am
I got mirroring to work in the testing environment. Now how can I write queries against it?
January 28, 2013 at 6:12 pm
Here's a problem. The prod server backs up the file to a location that the test server can't access. I don't have authority to change that location.
January 28, 2013 at 4:13 pm
So which is the better approach, scripted restore or mirrored database? Which has better performance, when is easier to maintain?
January 28, 2013 at 3:40 pm
I'm considering mirroring a "staging" database that's in the production environment. Can I use SSIS to extract data from the mirrored database directly or will I need to have...
January 28, 2013 at 12:04 pm
From what I understand about database mirroring, you cannot use the mirrored database directly. Is that correct?
January 28, 2013 at 11:52 am
Viewing 15 posts - 76 through 90 (of 205 total)