andycao (6/16/2011)

---

"Do you want a Yugo, a Buick, or a Porsche?" I use that when the business asks for a quick, but potentially long-living database application. Then I...

Regarding how to get a formatted list of columns, you can also query them from the information_schema.columns view and add things like commas as needed. Just drop this into your...

🙂

Never use phrases like "I think it's time the rich client got a new facelift" or "we need to dump our fat client for a thin client model" in front...

This may be the 5 most common T-SQL errors you'll encounter when typing into a SSMS query window, but I rarely see them in a production or QA envrironment, unless...

IceDread (6/15/2011)

---

Eric M Russell (6/14/2011)

---

EdVassie (6/13/2011)

---

One of the big lessons of the last 10 years for the traditional database community has been the emergence of the NoSQL movement. Whatever...

EdVassie (6/13/2011)

---

One of the big lessons of the last 10 years for the traditional database community has been the emergence of the NoSQL movement. Whatever you think caused this...

IceDread (6/10/2011)

---

ORM is becoming more and more common in todays products and development of different solutions. With ORM we lose the power of security throu stored procedures.

I would like to...

markjholmes (6/9/2011)

---

Yes! We could call the first one Twitchy and the other...

Starting with SQL Server 2005, a lot of features that could potentially cause security holes are turned OFF by default, and I'd consider that a safety net. We also have...

One of the best articles on the web for configuring linked server connections. The part that describes what specific resources a provider must be granted access to before it will...

Question Guy (6/2/2011)

---

Ya, I had to get out of being a jack-of-all trades. It was great to learn a bunch of different stuff of course, but the problem was,...

All this talk about code books and elaborate schemes for generating one-off passwords sounds like overkill. If a tornado should strike your company headquarters, I hope you have a backup...

If you're an employee or sub-contractor, then you can (and should) acknowledge the need for external expertise, but that decision is ultimately out of your hands.

I'd much rather have the production control team notify me that a script failed to...