Having performed audits of medical insurance companies I have found that most do not implement encryption. Why should they? The cost outweighs the possible penalties. Only when...

Things were so messed up the first 6 months were more like the first two years. And mixed in there's the aborted move to Cassandra, the consideration of SSAS,...

The statement is made " The GUID should be generated at the data tier or in the database itself." without support. Of course this is one reason developers love...

I hope it's the last job as I've got just a few years to retirement but if things go downhill at my current position I will move.

Someone mentioned mentoring after...

For me it's a good time to finally apply the latest service pack to our servers. And tentatively disable some of those sysadmin accounts that seem to sprout up...

In our case some of these parameters were meant to be implemented, perhaps as filters or whatever, but never were. This is pretty useful to me.

It's been many years since an employer sent me to a conference. That said, perhaps it's not as important as it formerly was. Online courses are far cheaper...

I'm pretty new to OLAP. What I've decided to try is creating a relational db which just has views for each table. Each view unions selects from the...

I don't know if that's the easiest approach. That would entail creating a 600 gig relational database and another step to populate it from the 50 odd client databases.

I...

I discovered that I need to first add these tables to the data source designer; then they can be added via the cube designer.

I would still like to know if...

The only use at my previous shop was for string aggregates, where it's orders of magnitude faster than TSQL. I second the thought that string aggregates should be native...

I had a syntax error also; a database name on my system is a reserved word. Fix the issue by surrounding the database name in the dynamic sql with...

Like many others I've been in IT for decades. It's fun, pays pretty well, and jobs are not scarce. I seem to change jobs every few years when...

Exactly. The tables were all in the primary group; I moved the large one out so I could do a restore of just the other tables. I believe this...

I believe SP2 can not be applied to 2008R2. Is that because 2008R2 has all the SP2 fixes included? I was under the impression that these were separate...