Can you show a few things:

1. The backup code (or is this only in maintenance plans).

2. What is the "run as" setting in the Agent job for the maintenance plan.

3....

I agree with Craig. I think you might be misinterpreting what is happening here.

Filegroups will let you control the objects, and if you have enterprise editions, you can move tables...

I used to play in a band, but it's too much of a commitment with kids, exercise, etc. However I enjoy music and one thing that's been fun is to...

Jack Corbett (11/17/2010)

---

For any chapter leaders that may not be on Twitter but are here, I started a thread on the chapter leaders forum about handling money, http://tinyurl.com/3ywxkbq. I'm...

I go away for a day as my daughter's sick and we're now throwing pies instead of pork chops? What is up with you kids?!?!?! :w00t:

I think we should have more certifications, and each of them harder with specializations in different areas. Good idea to post on Connect. If you do post, and I'd post...

As long as your SSIS instance is for disaster recovery, licensing is not an issue.

Willem, nice system, and if you'd like to write this up a little more with code, it would make a good article.

I don't think it scales well, but for a...

I'm not sure what you mean here. The English is a little confusing as you're writing it. If you can't open ports to location b, then there is no way...

george25 (11/17/2010)

---

Another question:

If a large amount of data (over 100Gb) are removed permanently from a db then this obviously frees up a lot of space within said db. How...

I've gone Stefan's route. To me categories or tags are a way of filtering down the content to specific areas. So the T-SQL posts on my blog. However if I...

I tend to agree with Travis. The product changes so quickly, even the people that write the code might not be tens in another version because it changes regularly.

To me...

You should not have a loop here with a WHILE statement. If you run this in the database server, your update statement will update all rows, not just the ones...

I didn't mean to imply you write bug-free code the first time you sit down. I don't think I ever said it would be perfect, nor do I think Jeff...

I think the author is 100% correct and a genius 😛