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

It helps to have cross-funtional team meetings.

Professional atheletes, school teachers, and midwives have special moments and inspirational stories to tell about their work. For those of us in IT, what we do for a living doesn't...

P Jones (12/20/2013)

---

I'm in the UK and have 31.5 days leave (1.5 added in place of compulsory shutdowns) which was 26.5 until 5 years service complete. Plus Bank Holidays. Then...