MS made a change in office that I have not read much about, they now have a "what do you want to do" box on the top of the ribbon....

I will admit that I do not have very many instances under my control, but I very much agree with separate accounts and not storing the password. The administrative time...

Very good question. I write code fairly often and it seems there is more to think about in SQL about scope than many programming languages. Either that or I just...

Awesome... thank you. I actually just found a post a few pages back that linked to the same article, VERY useful

I am looking for the same information. I have two servers that are at different companies and I need to move data from one to another. The servers are both...

I do not think this was saying it was acceptable, but just used to demonstrate how the view is created. That even though * was used the SQL Engine still...

Nice easy question, but it really does make you think about what is happening with views.

I think the reason MS "decided" to go one way with Report Builder and another with BIDS is really where they both came from. Report Builder came from a long...

Nice question,

I learned this a fun way when I created a new database and hadn't checked my email for a few hours. Came back to a full inbox saying my...

I have always held that having certifications in general do not mean anything, however NOT having the certifications means a whole lot.

Having them: yeah...great...you took an exam... so what.

Not having...

Nice question, and good to know.

It seems many people are guessing at this one, The answers were split 50/50 when I saw it.

I agree, this looks to be the best way to assign this. Since you are coming from a select statement that is about as basic as you can get.

Nice question, learned something new today

Here is another vote for daily.

When we run out of backup space on our dailies I will consider alternatives, but for now the convienece of having a single backup with...

Good question...and a good time to share a bit of wisdom about triggers:

Note:

Because SQL Server does not support user-defined triggers on system tables, we recommend that you do not create...