How to grant PowerBI Service Workspace access using PowerShell
Learn how to more easily manage permissions in the Power BI service using PowerShell.
2022-06-06
1,141 reads
G_M_J
How to remove quote marks using SSIS and a little C#
Introduction If you import flat files and use double quotes as your Flat File Text Qualifiers, then it’s likely that you’ve encountered problems when importing data where speech marks have been entered manually. This is a common occurrence in free text fields, such as Name. e.g. Smith, James “Jim” Attempting to import a file with a […]
2020-01-16
8,232 reads
Blogs
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation...
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Forums
sp_send_dbmail using HTML with templates and injecting datasets
Morning all, Looking for any advice or thoughts on how to achieve the impossible...
Forms Authentication Setup for SSRS in 2019
As I was looking the authentication set up which come as default when we...
SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
Ask SSC