"Backups, indexing, jobs, monitoring, and performance tuning are still core skills"

You better believe it. it was true ten years ago, it was true 20 years ago, it was true 30...

check the db owner. If they didn't change it, and if they were windows authenticated, you should see their identity. Depending on how they moved it, you might...

it works fine on 2008. I don't know why it wouldn't work on 2005. No matter, I was overthinking it, and I don't actually need to do the join,...

I am using an OLE DB Command, in a data flow task. There are some technical and business reasons for not using 2008. In fact, this is the...

it doesn't have delay validation. I know it's on 2008, but this is 2005. there is a ValidateExternalMetadata, that I turned to false, but that didn't help.

Leonard

I'm having the same problem. it tells me the zip file is corrupted or empty. I use some of these scripts, and have a few of my own,...

Here is a powershell script I use. Rename the attachment to .ps1. Create a .txt file with a list of servers. Update the script to use the...

I must be spacing out. read through the posts, and didn't see the previous suggestion. mea culpa. 🙂

you could also add another log file on another drive. not ideal, but it will get you going until you can get the mess cleaned up, then remove it....

Unless the email addresses were constantly changing, I would store them in a permanent table, then do the join as suggested. This would allow you to change the table...

Just wanted to throw this out there, it might be easier, especially for scheduling purposes, to use Powershell.

I actually have a similar situation, but for a different reason. We have a 2 node active\passive, SQL Server 2008. I would like to install a non clustered,...

it might. I have a 7.0 and I extract from it all the time. I have a 2008 server that I set up as my SSIS server. ...

One method I use, is SSIS. I have a production database, that has multiple schemas. So, I create an SSIS package for each schema. In it, I...

Just one suggestion, make the key an int, and populate with the date yyyymmdd (20081216), instead of an identity column.

You might want to create a separate table, for fiscal calendar,...