Viewing 15 posts - 3,436 through 3,450 (of 3,638 total)
quote:
SQL Server can run perfectly fine if it's not an administrator on the system.
I think...
June 23, 2003 at 2:09 am
I think you need to be careful here. Although 15hours to back-up a 30Gb database does sound too long it sounds like the back-up of your SQL Server is...
June 23, 2003 at 1:53 am
I used to work on an HP3000 mini computer where the console was the ultimate controller of the mini, then there were administrators and finally users.
There used to be a...
June 20, 2003 at 5:21 am
Thanks for your comments.
My concern with "properly" locking down a server, be it SQL, IIS or whatever is where do you learn to do it "properly"?
I've read a...
June 20, 2003 at 4:44 am
I don't think the question has a single correct answer. I think this one is a case of "an" answer rather than "the" answer.
Having had to do this for...
June 19, 2003 at 2:13 am
From a financial perspective Active/Passive is cheaper as the licensing is for the Active instance.
June 16, 2003 at 3:15 am
I would say "Comment the code". If you don't comment your code then you are asking to be nailed to your old projects for life or until you resign....
June 16, 2003 at 3:00 am
If you mark a table as pinned then it has little or no affect the first time you carry out an operation after it was pinned. It is the...
June 13, 2003 at 1:59 am
On this site ages ago there was someone who was running two low grade servers in a profitable dot com and was getting very good performance out of them because...
June 13, 2003 at 1:52 am
quote:
what did you do?
We had a staging database and a live database. In effect...
June 12, 2003 at 6:59 am
The main pitfall that springs to mind is making sure that unique id's on each machine do not overlap and that you have a strategy to cope with replication conflicts...
June 12, 2003 at 6:48 am
Although I do use replication a great deal we do have a situation where we use DTS to copy data from one server to another.
You can also use log shipping...
June 12, 2003 at 3:04 am
We have looked at sending a newsletter type HTML mail and are looking at the sp_makewebtask and sp_runwebtask stored procedures.
In testing we have used these procedures to generate e-mails as...
June 12, 2003 at 2:09 am
We use ColdFusion and a ColdFusion based content management system by PaperThin called CommonSpot.
I encourage my developers to avoid direct access to tables and to use stored procedures for just...
June 12, 2003 at 2:04 am
Where we are allowed to we compile our VB modules to DLLs and register them on the Webserver.
This allows us to develop and test the code quickly and also reduces...
June 11, 2003 at 2:11 am
Viewing 15 posts - 3,436 through 3,450 (of 3,638 total)