Ninja's_RGR'us (8/2/2011)

---

Can you enable snapshot isolation and put tempdb on it's own set of drives?

They will be able to run at the same time and NOT wait on locks... and...

Thanks Ninja

I'm doing a index rebuild weekly, at night, but there is almost no difference in performance from Monday to Friday. The main problem occurs when we do the frequent...

Thanks I've dropped the end points to see if I can, then I will re-create.

I just did not have time to recreate them with Transact SQL. I need to go...

Elliott W (4/21/2010)

---

Perhaps you can build a web service for your app to use, that would make it more difficult for them to directly access your system and allow you...

@jason: I'm just indicating that IP banning is an old, effective way to kerb attacks. Sure some FTP and SFTP servers are flawed, but that's besides the point....

The attacker's IP varies over time. I need less maintenance from...

Oh my... Thank you...

Now if you're saying that the firewall is not going to solve the whole problem, then I would agree. If you're saying you won't utilize IP blocking whatsoever even...

Elliott W (4/21/2010)

---

hein-1120388 (4/21/2010)

---

Ok. I use SQL Server Standard om my web server but have SQL Express installed at clients. So your comment is still valid. I had some database...

Ok. I use SQL Server Standard om my web server but have SQL Express installed at clients. So your comment is still valid. I had some database management tasks that...

Ok, I have an elaborite firewall at my disposal at the isp, also in between my server and the internet. I've never activated it, because all the ports I have...

So I can still schedule stored procedures with SQL Express 2005 & 8? I can't find the option in Management Studio. I...

Lynn Pettis (4/21/2010)

---

Configuring a VPN client is only done once. Once configured, you simply start it and use it. One of our sysadmins even has his start automatically...

Elliott W (4/21/2010)

---

hein,

Not to put too fine a point on it, but the fact is that SQL doesn't do this, hole or not. A VPN solution would be the...

Rats they dropped it then from MSDE to Express. Too bad.

Thanks for the info re. Proxy. So it has no effect on my xpcmd_shell right then.