How to Reduce the Need for Bookmarks Using Parameters in Power BI
Learn how to implement parameters in Power BI.
2023-06-28
3,406 reads
G_M_J
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
2,976 reads
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
11,702 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
Is Ransomware Fading?
Comments posted to this topic are about the item Is Ransomware Fading?
How to Resolve SQL Server Database Stuck in Recovery Pending State
Comments posted to this topic are about the item How to Resolve SQL Server...
A Simple Choice
Comments posted to this topic are about the item A Simple Choice
Question of the Day
A Simple Choice
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers