Steve Jones - SSC Editor (6/23/2011)

---

Eric M Russell (6/23/2011)

---

Regarding the client tools specifically (SSMS, BIDS, DAC, etc.), if the user's version of Windows has the latest .NET framework installed, then...

Regarding the client tools specifically (SSMS, BIDS, DAC, etc.), if the user's version of Windows has the latest .NET framework installed, then it shouldn't matter what version of Windows it...

I guess it depends on what exactly is meant by "will longer support". If that means they will no longer make extensions or big fixes to the code base to...

I don't think you mentioned the eact method currently used to pull data from the remote database; only that it is "queried". The advice below assumes you're just selecting from...

David Portas (6/21/2011)

---

Eric M Russell (6/20/2011)

---

That's strange. In my observable universe, SQL Server and Oracle support declarative data integrity, meet business needs, EAV tables exist only within the realm of...

I think that more regulation is needed. There are specific software and database design patterns that for decades have been known to be security vulnerabilities, and yet they continue to...

OCTom (6/21/2011)

---

Excel has its place. However, it can be misused.

I have been on the receiving end of Excel-based databases. As they become bigger, the data is harder to handle...

While we're on the topic of Excel in the Clouds, Microsoft's Excel Web App service provides not only the data but also the application in the cloud. It also allows...

One of my primary projects is developing and maintaining a reporting datamart for the accounting department. When a report is run, a dataset containing key and fact columns are queried...

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

🙂