patrickmcginnis59 10839 (1/24/2014)

---

Here's a few reasons why I'm...

Greg Edwards-268690 (1/24/2014)

---

Eric M Russell (1/24/2014)

---

There are other 3rd parties like Google and OpenOffice who are developing front end applications for managing Excel spreadsheets. I'd hate for Microsoft to get...

Gary Varga (1/24/2014)

---

Eric M Russell (1/24/2014)

---

Excel can be a cog in a large organization's data processing lifecycle, somthing that exists peripheral to the RDMS, but that's not always the case.

There...

Excel can be a cog in a large organization's data processing lifecycle, somthing that exists peripheral to the RDMS, but that's not always the case.

There are a lot of small...

As it stands today, if a user imports data from SQL Server or another relational database into an Excel spreadsheet, they can mangle the data contained in the sheet (often...

patrickmcginnis59 10839 (1/22/2014)

---

Eric M Russell (1/22/2014)

---

patrickmcginnis59 10839 (1/22/2014)

---

Eric M Russell (1/22/2014)

---

patrickmcginnis59 10839 (1/22/2014)

---

Eric M Russell (1/21/2014)

---

One feature that would be very useful in Excel is the option to create strongly...

patrickmcginnis59 10839 (1/22/2014)

---

Eric M Russell (1/22/2014)

---

patrickmcginnis59 10839 (1/22/2014)

---

Eric M Russell (1/21/2014)

---

One feature that would be very useful in Excel is the option to create strongly typed columns or regions. That,...

patrickmcginnis59 10839 (1/22/2014)

---

Eric M Russell (1/21/2014)

---

One feature that would be very useful in Excel is the option to create strongly typed columns or regions. That, and also column level NOT...

Jim P. (1/21/2014)

---

Eric M Russell (1/21/2014)

---

One feature that would be very useful in Excel is the option to create strongly typed columns or regions. That, and also column level NOT...

Jim P. (1/21/2014)

---

Eric M Russell (1/21/2014)

---

One feature that would be very useful in Excel is the option to create strongly typed columns or regions. That, and also column level NOT...

One feature that would be very useful in Excel is the option to create strongly typed columns or regions. That, and also column level NOT EMPTY, DEFAULT, CHECK constraints. FOREIGN...

I learned the hard way that, sometimes the accounting department will hide or strikethrough records when they really intend for them to be deleted. To a non-technical user, it seems...

Back in the 90's, I developed a data warehouse (my first) that partitioned data by state into seperate tables and by period year into seperate databases. For maintenance operations, I...

..Imagine that you’re contemplating a project that will involve running multiple SQL statements and maybe some PowerShell against a list of instances, and then storing the results for later analysis....

Every ETL process needs a dashboard application and email alert process. For example, for one my larger data warehouse projects, the dashboard has one screen that lists a complete history...