Creating my own Map Shapefiles for Power BI
(2019-Jan-06) In the past, I used to always rely on shapefiles crafted by others to create my map visualizations in...
2019-01-15 (first published: 2019-01-06)
6,751 reads
Rayis Imayev
- Website: http://datanrg.blogspot.com/
Using WGS 84 shape maps in Power BI
(2018-Dec-31) Back in July of 2018, Ontario provincial government of Canada decided to decrease the number of Toronto city wards from 47...
2018-12-31
1,384 reads
Email Notifications in Azure Data Factory: Failure is not an option
(2018-Nov-27) When something goes wrong with your data transformation process in Azure Data Factory, the last thing you expect to happen...
2018-12-11 (first published: 2018-11-27)
9,561 reads
System Variables in Azure Data Factory: Your Everyday Toolbox
(2018-Nov-20) After working and testing the functionality of variables within Azure Data Factory pipelines, I realized that it's worth to explore...
2018-12-04 (first published: 2018-11-20)
2,834 reads
Append Variable activity in Azure Data Factory: Story of combining things together
(2018-Oct-29) There are only a few sentences in the official Microsoft web page that describe newly introduced activity task (Append Variable)...
2018-11-07 (first published: 2018-10-29)
12,584 reads
Setting Variables in Azure Data Factory Pipelines
(2018-Oct-15) Working with Azure Data Factory you always tend to compare its functionality with well established ETL packages in SSIS. Data...
2018-10-23 (first published: 2018-10-15)
13,905 reads
Maps in Power BI. Do I really need them?
(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in...
2018-08-30
1,091 reads
ArcGIS Maps for Power BI: Free vs. Paid version
(2018-July-25) I like the ESRI company slogan, "The Science of Where". Hopefully, it will help someone not to get lost in...
2018-08-14 (first published: 2018-07-25)
2,960 reads
ArcGIS Maps for Power BI: Plus subscription (2nd part); What's in it for me?
(2018-July-29) My initial attempt to explore and test the ArcGIS Map paid version continued after receiving a response from the...
2018-07-29
391 reads
SQL Server data flow into Excel template with Power Query function-based parameter
(2018-July-15) Your case is to create an Excel template with data extracted from a backend SQL Server database; it takes a...
2018-07-24 (first published: 2018-07-15)
2,483 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Report Server Configuration Manager - Change Database - SSL Error
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers