Viewing 15 posts - 14,881 through 14,895 (of 39,970 total)
The DMZ is a semi-secure area on your network. It's a buffer to your main network.
The typical configuration is:
Firewall -> DMZ subnet -> Firewall/router -> main network
Putting a SQL Server...
December 2, 2011 at 9:09 am
SQLRNNR (12/2/2011)
Stefan Krzywicki (12/2/2011)
Steve Jones - SSC Editor (12/2/2011)
Don't be making me add IZ, haz, sertinz and a few more to the "bad words" list here.
There's a "bad words" list?...
December 2, 2011 at 9:04 am
Add a waitfor delay? I know sometimes the zip procs seem to complete, but there's still some work in Explorer to rewrite the file and update the NTFS stuff.
December 2, 2011 at 9:02 am
You always execute jobs from the server. Even if you connect from your workstation using SSMS, you are "asking" SQL Server to run the job.
If you want to run a...
December 2, 2011 at 9:01 am
The DC shouldn't be a huge load. I assume you have other DCs on your domain, or a small domain that's not too active.
Running anything on the SQL Server instance...
December 2, 2011 at 8:58 am
Don't be making me add IZ, haz, sertinz and a few more to the "bad words" list here.
December 2, 2011 at 8:53 am
Let us know how this works. I think it should work fine for you on the file fragmentation of the MDF. It shouldn't change any internal fragmentation of tables inside...
December 2, 2011 at 8:47 am
GSquared (12/2/2011)
We were also attacked by Annonymous a while back, but when they failed to accomplish anything, they changed targets. I guess that counts too.
Good for you. A few...
December 2, 2011 at 7:08 am
You can try this: http://ask.sqlservercentral.com/questions/71956/getting-the-source-code-from-a-clr-assembly
The compiled code is stored in the system tables. Decompiling it can be tricky. .NET Reflector from Red Gate may help, or another decompiler, but it...
December 2, 2011 at 7:04 am
The idea from GSquared is nice, but it could be a problem as well if you don't document this and make sure alerts will not fire or someone will not...
December 1, 2011 at 12:27 pm
Not unless you had some type of monitoring or tracing in place. This isn't captured by default.
December 1, 2011 at 10:45 am
First, you mean SQL Server 2008 R2. SQL Server 2008 is a completely separate product. If you confuse this, you might find yourself in a lot of trouble.
I don't see...
December 1, 2011 at 10:42 am
Fundamental architeture. SQL Server has multiple database per instance, Oracle doesn't. Understanding some of the layout of the internals is helpful.
Backups - Make sure you have a solid grounding of...
December 1, 2011 at 10:34 am
I agree with Sean in terms of the GUID. If you have a good reason, use them, if not, use an identity.
If you're worried about data size in a column,...
December 1, 2011 at 10:32 am
Viewing 15 posts - 14,881 through 14,895 (of 39,970 total)