How to connect Microsoft SQL Server Analysis Service remotely?

Scenario SQL Server Analysis Service (SSAS) supports only Window Authentication mode. If you want to connect SSAS remotely from your local machine using some client tools such as SQL Server Management Studio (SSMS), Tableau or others... you will encounter an issue of connecting to SSAS. This is because these tools run under you local account … Continue reading How to connect Microsoft SQL Server Analysis Service remotely?

Advertisements

How to work with dynamic PIVOT in SQL Server

Problem In my article Working with PIVOT, I introduced a simple way to implement PIVOT table in SQL Server. However, the data set is static and if we insert more data, the PIVOT query will not work. For example, there is a Sales table as below Product             Date   … Continue reading How to work with dynamic PIVOT in SQL Server