Change SQL Server Analysis Services Deployment Mode from Multidimensional to Tabular
I recently installed SQL Server Analysis Services (SSAS) and used the default settings during the installation. Unfortunately, this meant I installed it using a…
I recently installed SQL Server Analysis Services (SSAS) and used the default settings during the installation. Unfortunately, this meant I installed it using a…
I recently needed to find which databases in SQL Server had a specific view deployed to them. I’ve created scripts in the past to…
I was recently doing some testing of a script I created for a client which used SQL Database Mail for sending emails. this was…
Today’s post combines the topics of the previous two posts and moves into Power Query to connect to SQL directly instead of connecting to…
Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting…