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

One other thing I'd like to add about deploying ad-hoc change scripts; I also wrap the DML or procedure calls in a transaction and add assertions on the expected number...

In the past, whenver a "data fix" was required in production; a change order was created, and I'd write a T-SQL script which would go though the normal version control,...

Ukon (5/28/2011)

---

Hello again! I agree, using Linq with stored procedures, I believe would work quite nicely. I have no objection to that at all. I was only concerned regarding the...