Of course the BI group doesn't always get the biggest budget, and often times they're working with...

Gift Peddie (12/27/2010)

---

MSDN downloads and DVD/CD are AnyCPU binaries so Microsoft can provide x64 and AnyCPU builds that will install in x86 operating systems for developers and testing. In...

Gift Peddie (12/27/2010)

---

...That is a myth Oracle sells but I have not run x86 Oracle in any company for more than eight years, selling only x64 for production and development...

leroy-1092048 (12/27/2010)

---

I guess i have a question...

Would a company really upgrade their production SQL server to the upcomming version and then say...

hey! lets just upgrade SQL server but keep it...

I don't know what level of access you have on the server to verify this, but perhaps the latest version of MDAC needs to be installed or re-installed. You can...

SQL Server is already seen as being limited, in comparison to Oracle, because it only runs on the MS Windows operating system. I think that removing 32bit support from the...

One way to get related items into a delimited column is using a sub-select and for xml clause. This involves the awkward problem of stripping off the leading or trailing...

Some of my older sub-queries that were using a GROUP BY with MAX() for things like "get the most recent address" or "get the primary phone number", I've replaced that...

As a part time data analyst and part time roaming developer, I see a lot of database, and if I were going to stand up and give a talk about...

I think it's a lot easier to pick up development or (especially) admin skills on SQL Server when compared to Oracle.

I woudn't call MS Access or Excel a "low end development tool". Primarily they are general purpose tools for data analysis and reporting, and they are actually state of the...

Often times it's good to just let the end users "prototype" their own applications in MS Access or Excel. The trial and error process is practically part of the discovery...

I agree...

The purpose of schemas are to logically organize objects in your data model. For...

Anyone who says that coding while listening to political talk radio makes them more productive has to be lying or is just fooling themselves.