Per Microsoft documentation for SSRS, it’s possible to add an action to an object that will allow you to jump (drillthrough) from one report to…
The Right Join
Some time ago I came across this post by Erik Darling about using Alt+Shift in SSMS to edit multiple lines at the same time. It’s…
This is a handy trick for switching between the SQL Server instances and databases that a Power BI file is connected to & is particularly…
Recently I came across what I consider to be a serious security risk when configuring Azure SQL Database for use with Azure services (such as…
In SQL Server Integration Services projects, it’s possible to parameterize OLEDB data connections so that a different Data Source (SQL Server) and Initial Catalog (Database)…
One thing that threw me the first time I connected to an Azure SQL Database in SSMS using a non-admin account was the requirement to…
Occasionally I have to process data from Excel spreadsheets as part of my data warehouse work & usually these files require a bit of a…
I came across this error recently on a VM with multiple SQL Server instances installed. Initially a SQL 2016 instance had been installed & some…
This trick is useful if you need to “pretend” that a named instance is the default instance, e.g. to connect a poorly coded app that…
I recently had cause to review the Tenant Settings in the Power BI Service. One of the settings seemed somewhat ambiguous (at least to me):…