I too have never touched Powershell either nor used it. I think if I had some very complex administrative tasks with Microsoft services, that might change, but for the most...

Just went through this at my company, but luckily, PowerBI supports this feature with dynamic pivots.

I would start by picking up a book on the subject. Here is a good one by Ralph Kimball on Data Warehouse Toolkit: The Definitive Guide to Dimensional...

From my understanding, the certificate contains the clients public key. This is why the client does not need to have a client certificate installed on the local machine. You are...

Really depends on the server too. In the MPP world, data is essentially in columnstores. You're paying for the extra compressed space to reduce the overhead of having to format...

Unfortunately, this is a very common question that is asked when modeling data, which means there are few methodologies that various DBA's have to approach such a problem without any...

I would say any version would work fine. Hell, I would use Excel personally with a tab per table. That's only because I prefer to define data dictionaries over visio...

We have both chief data officers and global data officers due to the size of our organization.