Schemas would work just as well in this example. I opted for the separate databases because it was easier to explain to management in my organization rather than getting...

In my environment I have many different departments that need to be kept separate from each other, yet share some data elements such as calendars and employee profiles. I...

tindog (3/22/2016)

---

I agree, and I think it does make everything a bit more daunting, especially when you're trying to decide whether to go down DBA/Analyst/developer routes. It sounds like you've...

Thanks for the reply. It's a shame stuff can't be more standardized, at least, from the managers perspective of what each level of DBA should know. I...

I have been toying with the idea of writing my own tool and releasing it as an open source tool, but I am not the most knowledgeable developer or data...

I call myself an accidental dev because I ended up falling into a business intelligence role mainly through passion and not through any in-depth technical knowledge. Yes, I can...

The tool was a custom tool that our consultant wrote. It basically is a Windows form application that prompts the user to fill in a bunch of values, and...

Thanks for the advice everyone! Unfortunately the closest PASS chapter is over 3 hours away from me, so I think I will just practicing delivering demos to my PC...

I bought an ETL generation tool where I work at and love it. I have to create my tables and columns one by one, but after that, it builds...

I'd also do four separate fact tables as well, because you have four different business objects. I like to keep each fact table to only one business entity because...