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…
The Right Join
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):…
Following on from a previous blog post on how to flatten a pivot table in Excel, this trick repeats all the labels in a flattened…