We're pretty much on Option #3 as you described them. We use SQL Projects to handle the code changes and they usually aren't too bad, but trying to do customized...

I think there is a lot of "it depends" on these cases. For basic row-level interactions (add, update, read) a single row - by all means use the ORM. For...

Submitted, but if you think it needs more work or examples, please kick it back to me.

Hard to narrow this down.

I like the Foundation series, but see that working better as a miniseries than a movie. Too much happening even in the first short story to...

I think I can handle this one.

Nadrek (2/7/2014)

---

Well, I'd probably start off development by using xp_cmdshell to interface with the driver for the stepper motor...

Haven't gotten too far beyond using these for RowNumber(), but I look forward to using some of the 2012 functionality soon.

--Query to display sets of daily recurring schedules with different...

With a huge thanks to the SSC support team, they were able to recover the original article and adjust it to have the changes I'd made. I'll be a bit...

And submitted a request to the people running the site to see if we can get the article back. The text was there when I submitted the update - I...

That's not good. I tweaked a little text to resubmit the article, but it shouldn't have deleted anything. Checking now....

SSMSBoost looks interesting. I'll have to give it a more thorough look. I appreciate the full-featured community edition, even if you have to reinstall it every 120 days. That seems...

ssms-man (9/18/2013)

---

Hello Peter, I wonder if you have heared about the tool, that I develop: SSMSBoost. I have extensively addressed "connection coloring" topic there:

(Full description is here: http://www.ssmsboost.com/Features/ssms-add-in-preferred-connections)

SSMSBoost...

michelle-409778 (9/17/2013)

---

🙁 never mind. I work for one of those big corporations which have a restricted list of software. If it's not on the list, I don't...

michelle-409778 (9/17/2013)

---

Article says this is in SQLServer 2005, but I'm running that edition (still!) and I'm not seeing this as an option in Register Servers. Did you mean SQLServer...

MegaZord (9/17/2013)

---

Thanks for the tips.

Say you've RED (prod) and GREEN (DEV).

If you're, say in one of the (GREEN) database servers in the query Window and do a Ctrl +N and...