Most will agree that it is better to use stored procedures and have the application call the procedures. One issue is performance, stored procedures are more efficient than dynamic queries....

I think we can probably start a thread so all of us attending PASS can give daily updates. Steve will probably give the "official" updates like he did for a previous...

I finally got a good answer on this one.  Use '?' as the placeholder in the query and use numbers starting at 0 for the parameter name.  Works like a...

I haven't really heard if it is the same day/time as last year.  You could ask Steve.  I will definately look for you at the party.

It was at the summit and was held right after the welcome event Tuesday night.

Clarification: The registration at the Summit.

Last year, I received a ticket for the SSC party when I registered.

Thanks!

Thank you for all of your comments. With third-party apps, you usually don't have a choice about whether or not stored procs are used. My real intention for the article...

I will be there for the party.  Wouldn't miss a chance to meet other SSC members.

Kathi

That's too bad. We can definately hang out before then. When are you arriving?  I really wish you could be there Friday. The last two years they had a panel...

It's on Thursday at 3:15. By the way, your articles are great! Look forward to meeting you. 

It will be pretty cool for me this year at PASS since feel...

I will be there!  Shameless plug: be sure to attend my presentation on communication skills!

Doesn't matter the culture, bad guys can come from anywhere. A lot of imagination and hard work goes into writing an article that others will want to read. I am really shocked that...

I finally got the XML Task and XPATH to work to return the answer. If I save it in a variable, it has an extra character, a row delimiter I guess....