Viewing 15 posts - 1 through 15 (of 2,324 total)
If you have things called 'Development and Production' environments and 'Change Control' then SSIS environments can be useful.
A place I used to work had dedicated staff doing the Production implementations....
August 17, 2022 at 7:10 am
You said you have done a Copy Only backup. This may not be what you actually need.
Unless you really know what you are doing and the restrictions related to a...
August 15, 2022 at 6:20 am
Your AG listener needs to have a unique IP address. It should not try to share the address with a node or any other object.
Your client applications connect to the...
August 12, 2022 at 6:02 am
Part of your job is to tell management what is possible and what is not.
You may have a technical solution that merges job history, but it requires you to manipulate...
August 12, 2022 at 5:50 am
Fredrico's question is important. Why are you making this change. If it is needed why are you doing it as part of the DB migration.
You are doing a data format...
August 12, 2022 at 5:38 am
To link your applications to the servers use DNS aliases. I have used a two-tier setup of Application aliases and Failover aliases. See my post from July 11 for more...
August 6, 2022 at 12:58 pm
First thing, you need to be very clear about the business problem and what you are trying to solve. Eventually you will have to ask for money to get this...
August 6, 2022 at 12:53 pm
It may be time to experiment with a non-production implementation of your application. Make a copy of your test DB and point the application at that. Then apply all the...
August 3, 2022 at 9:38 am
It is difficult to get into almost any job unless you have experience in what you want to do. The best way is to do research and find employers who...
August 1, 2022 at 8:44 am
The scenario you want to do is something most organisations have faced. Unfortunately it is not possible to do it in a single step.
Any database that is in Full Recovery...
August 1, 2022 at 8:24 am
Can I suggest you also look at your application upgrade process. The standard I have been used to is to minimise risk.
There should be no DB changes made that could...
August 1, 2022 at 8:08 am
The client can either:
a) Run your tool for discovery
b) Run their own process for discovery, possibly assissted by you
c) Agree with your client a list of servers they want to...
July 27, 2022 at 9:13 am
This works for a simple situation but problems may arise in many enterprise situations.
Many enterprises use DNS aliases for connection, as this gives a layer of indirection between PowerBI and...
July 18, 2022 at 9:19 am
As always, the job of the DBA is to present the technical opportunities along with their risks and costs to management and get them to tell you in writing which...
July 11, 2022 at 9:26 am
My wife now has the best workstation in the house for her 3-day per week job as Church Administrator. She has a 1yo 16GbB laptop/tablet combo feeding two 4k monitors...
July 10, 2022 at 2:38 pm