Viewing 15 posts - 3,421 through 3,435 (of 3,614 total)
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
I see what you are getting at but the situation is that I am installing databases on someone elses i.e. customers servers so this would be a bit "chicken and...
June 10, 2003 at 5:27 am
OK, having read around absolutely any user could issue the commands
CREATE TABLE #Tmp(MyField Int);
WHILE (1=1) INSERT #Tmp(MyField) VALUES (1)
Hardly advanced is it an yet this can't be blocked in any...
June 6, 2003 at 10:34 am
Thanks Brian,
I'm not so concerned with Access users hitting my box, but I am concerned with breaking something inside SQL itself.
I have to admin that prior to sifting through the...
June 6, 2003 at 7:12 am
quote:
I've actually done some research on this. Guess I need to put it together in an article. If you can wait a...
June 5, 2003 at 9:27 am
OK, so its a minor release but why don't they change the version number on the service pack. It is exactly the same as SP3!
Surely they could have at...
June 5, 2003 at 9:07 am
Thanks for that, I particularly like the closing statement "...and pray!".
It mentions three or four extended stored procs to block.
I notice xp_dirtree isn't documented anywhere. Come to...
June 5, 2003 at 9:05 am
quote:
my boss's perspective was, "It looks like you still have everything under control, so we don't need to hire another DBA."
June 5, 2003 at 9:01 am
I had a transactional database that held transactions for 6 european countries.
I split the transaction table into 12 separate tables. For each country I had
June 5, 2003 at 2:05 am
The term DBA covers a variety of tasks.
June 5, 2003 at 1:59 am
Viewing 15 posts - 3,421 through 3,435 (of 3,614 total)