I've done some Powershell, although mostly I've found scripts to accomplish what I need in general, then fine-tune them. An excellent resource for picking up on Powershell is the...

So we've got so far:

1. Mayan calendar runs out...

2. Y2K bug

3. Bird Flu

4. Red Sox winning the World Series

Hmm, are you looking for things that would...

If you're planning to trigger this from within a DOS batch file, you could set up the batch file to either outright delete the previous backup files, or move them...

T-SQL is the language the scripts are written in. So when you keyed in the "Select @@version" in Management Studio, you were writing a T-SQL script.

What I think I...

No way to tell what the Windows OS is...

Nice car, but your steering wheel is on the wrong side of the car!

😉

Jason

To quote Adam Savage: "Well...

Well, the first thing you want to find out is if this is Express Edition or not. If it's Express, you won't have the option to create a Maintenance...

I found this posting on Simple-Talk the other day, and am intending to give it a try: http://www.simple-talk.com/sql/ssis/ssis-basics-setting-up-your-initial-package/

Then there's part 2 of the previous article: http://www.simple-talk.com/sql/ssis/ssis-basics-adding-data-flow-to-your-package/

Jason

Thanks for the information Steve!

If / when I go to the SQL in the City, it'll only be the second such event I've been too. I do (when I...

Well, for giggles I renamed an SQL Server I have, to see if that would break the Agent service.

I changed nothing, didn't follow the steps when done to rename an...

Did you rename the computer at some point?

I ask because it doesn't look like the computer name is the same between here:

and here:

Unable to connect...

Oh, I don't mind biased, and I figure I'll pick up some pointers even if I never touch a Redgate application.

Hmm, now to suggest this to one of my bosses,...

OK, I'm reviving this topic with a new (somewhat related) question:

How do you feel about the SQL in the City[/url] events?

I took a look at the agenda for the London...

At this point I've seen Avengers three times and yet I still wouldn't object to seeing it again. I'm a comic book fan from a while back, but nothing...