Eric M Russell (1/24/2014)

---

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

Trust Me, but audit all the other Admins!

Something missing in that picture.

Akayisi (1/24/2014)

---

Hi Perry I want to do this:

in SQL Server 2012, i can make audit filter for sa user. However i can't do it in sqlserver 2008 I want to...

Here's another article a bit newer that also describes just what is happening.

chris.smith 91049 (1/23/2014)

---

Of course, what IS a good practice, when its a reporting solution, is to develop properly a high quality data cube and give the Excel users free rein...

Thanks for helping Perry.

I probably should have made the link more obvious.

Typical Business view -

Users are familiar with Excel.

It only takes mere seconds to do almost anything in Excel.

With Control comes Cost.

Many Businesses likely do not add up the hidden costs...

You need the cert and have to install it in the master.

See this article.

I thought the NSA had fixed...

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

chris.smith 91049 (1/22/2014)

---

I disagree with what a couple of people have said - that Excel itself isn't a problem - as a development tool it's terrible, not easily source-controlled, distributed...

Either one is only as good as the brain...

Jeff's articles were very good.

Thanks Jeff!

Our hierarchy was 3 levels deep (Commodity Code) for an Item.

What was a different twist for us - we only assigned the bottom level to...

Excel can be great in the right hands, your worst nightmare in the wrong hands.

Yes, it is no surprise that it costs money to build a data warehouse, or create...

I agree with Jeff, it appears to be a ragged hierarchy.

In your example, you have a where (physical location), and a type of item.

Will any of the items be used...