I've been doing what you call Agile for years, and it's worked well. It's a great evolution from the waterfall model.

I think MS has moved to this area in many...

Whoa, I'm not saying we need BI. I think BI can help here, but it doesn't have to be a fancy Proclarity report or a dashboard. It can be a...

I tend to agree with Michael.

One thing I'd suggest is looking for a small piece of this to tackle, perhaps replacing some tables with views and building a better underlying...

There is not automated way to do this, since it doesn't usually make sense.

there are lots of scripts here that you can search for if Ken's doesn't work for you.

We've actually got an article Q'd up for Aug 4th on this.

the author used the "Edit" query button after setting up a regular query, then entering the stord procedure name...

I think it's a sign of us getting older. 🙁

That's not a bad idea. I'll talk about it with the team.

Haven't found a great one, but I haven't used Apex's tool. I'd give that a try and see if it helps you. ER/Studio and ErWin haven't worked well for me.

I doubt the questions change much. There's too much effort into developing the exams and then doing a Beta to allow for change.

I thought that they built exams to...

Greg and Vidhya's advice is good. I'd be wary of allowing developers to manage jobs and packages. They tend to "fix" things on the fly, often breaking others at the...

These two concepts are not necessarily related at all.

A PK defines uniqueness on your data rows. It allows you to find an individual row out of a group. Whether this...

My kids always tell me that they won't spill grape juice on the couch. When I catch them drinking over there, they say that they haven't spilled it, so it's...

A couple of things.

Be sure the remote connection is using TCP/IP on both sides. It must be enabled on the server and set to be used on the client.

Also, if...

All the files are at the bottom of the article. I didn't notice the links internally, which needed to be removed.

The buffer pool.

You might want to read up here: http://msdn.microsoft.com/en-us/library/ms187499.aspx