David Portas (6/20/2011)

---

Eric M Russell (6/14/2011)

---

MS SQL and Oracle are first and formost relational database engines. If Microsoft thinks NoSQL datbase solutions are a market worth breaking into, then...

Somtimes one thing has to break before we discover that something else has been broken for a long time. For example, it takes a hurricane to reveal the fact that...

GSquared (6/16/2011)

---

Peter Maloof (6/16/2011)

---

Non-technical person: "It's working! What was the problem?"

Me: "You don't really want to know."

Non-technical person:...

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,...