Eirikur Eiriksson (2/16/2014)

---

Would this be of an interest?

Data de-duplication using 2012 window functions.

Simple cases;

1. A set with no surrogate key defined

2. A set with a surrogate key, related records...

Eric M Russell (4/10/2014)

---

The standards would not have to be very technical. Dedicated sysadmin accounts, removal of service accounts from sysadmin role, seperation duties, application accounts with minimal privilege (ie:...

You guys are killing me.

This forum isn't for general questions or discussion. It's a call for articles. If you want to write one, please feel free to post or ask...

Tracy, take it.

Ed, you can tackle one or two of the items. We are really looking for focus here on solving a problem, not a general piece that tries to cover too...

No, though I'm thinking this is a 3-5 page sized article.

It's a complete when you can.

In terms of content, the whole idea is to focus. Assume that someone has done 1-4, and just focus on the measures. How do you...

Camille,

Thanks and looking forward to it.

a4apple (4/10/2014)

---

Hey Steve, here is a detailed article I wrote on partitioning. How to submit this was a question, I...

Bob,

give it a shot if you have...

Not done, but please do not submit for multiple articles. Please take one on only.

SSDT would be fine. We can use a few here.

However please tackle one at a time.

Take it, Ed, but focus on one solution. I'd rather have focused articles than one that tries to solve all possibilities. If you'd like to do a series, then you...

I'd be interested in your process. I'm looking for a piece, probably more than one, that talk about deployment. If you use SSDT and Jenkins, it would be nice to...

It would be a good topic. The important thing to do is focus on teaching someone about dimensional modeling. I'd suggest you write a couple sentences that explain what you...