In smaller shops I can see that as a bigger challenge. In bigger shops, there are usually other groups who have a hand in setting policy and since sa...

When no one knows it, no one can use it.. It kind of ends that debate. And our security people would flat out decline anyone who wanted to,...

In some ways we went a step further..

We created a second sa type account and then set the sa password to some value that was randomized, even we don't know...

Tom.Thomson (10/28/2009)

---

Yes, of course we have to have some negative values. But I would be much happier if the integer stored actually consisted of the 32 bit IP address,...

If you are using the OS Command instead of SSIS your command line should look something like this:

dtexec /F Package1.dtsx /SET "\Package.Variables[User::Variable1].Properties[Value]";4

/SET "\Package.Variables[User::Variable2].Properties[Value]";5

CEWII

Better answer no loops, we all know how much Jeff likes loops. <grin>

DECLARE @MYTBL TABLE(NAME VARCHAR(10), EMAIL VARCHAR(50), DOB DATETIME)

INSERT @MYTBL

SELECT 'ADAM' [NAME], 'EMAIL1@YAHOO.COM' , '10/11/1978' [DOB]

UNION ALL

SELECT 'TRACI'...

I would agree, try them both. There are a lot of factors, that make it difficult to tell which would be better from a 10,000 foot view.

Use the one...

The tempdb should be on seperate spindles than the rest of the databases..

As far as sizing.. Just shooting from the hip, why not start with 10GB total space for...

You might be concerned, but there is really nothing you can do about it. If the camera points at a space that is visible to the public there is...

skelly-806234 (10/27/2009)

---

There's no way you can come up with even a ballpark number of DBA's per server. With the right tools, a well set up infrastructure, reliable networks and well...

george sibbald-364359 (10/26/2009)

---

You can change it if it is not already in mixed mode. just select mixed mode in SSMS property window, OK out of it, and restart SQL (don't...

I agree that is pretty straightforward. You say that the "Rebuilt Product" works fine but the "Load Goal" dies?

Questions:

1. Are those two packages in the same location on disk?

2....

I read one person suggest having one server monitor them all, which in general is good, BUT, you still need to have something monitor the monitor server, at least a...

Uh, this looks a lot like homework.. We don't do homework..

CEWII

I think this depends greatly on the infrastructure you have in place. If you don't have a good infrstructure the number of servers that any single DBA can handle...