Arpit Tyagidataminds.hashnode.dev·Dec 2, 2024Optimizing "Data Transfer" and "Data Transformation" in ADF: Filtering Even Customer IDs from CSV to SQLStep 1: Inspecting the CSV File in Data Lake: Your First Step to Data Optimization Step 2: Configuring the Data Flow Source: Pointing to the Customer.CSV File Step 3: Filtering Even Customer IDs: Streamlining Data with ADF's Filter Data Flow Step ...Discuss·7 likesAzure Data Factory#DataPipelines
Arpit Tyagidataminds.hashnode.dev·Oct 24, 2024Important Business Use Case - Solved by ADF (Azure Data Factory)“Use Case”: Whenever we have more than 100 records in the customer table, we copy the customer data to another table customer_copy within the SQL DB. However, whenever we do this copy, we first truncate the table 'customer_copy' and then copy the dat...Discuss·10 likesAzure Data FactoryAzure
Rajender Singhsinghrajender.hashnode.dev·Jun 22, 2024Custom Split Delimited String into Columns in SQL ServerAfter ending my blog oraclebrains in 2009. I am excited to finally share my first post in years. I am motivated to continue writing and sharing my thoughts, experiences, and insights with others. I wanted to share a fun little challenge that I have r...Discusssqllogic
Glen Allenappandweb.hashnode.dev·Mar 5, 2024Migrating to Power BI: Challenges and Solutions for a Flawless TransitionIn the dynamic landscape of business intelligence, the decision to migrate to Power BI represents a strategic move towards enhanced analytics, improved data visualization, and a more robust reporting framework. However, with this transition comes a s...DiscussAnalyticsTransformation
Israel Heringerisraelhlc.hashnode.dev·Feb 26, 2024Migrating Data at ScaleTechnologies arise, technologies evolve, technologies get replaced with newer, better ones. Hardware requires upgrades, software needs to be updated – this is a never-ending process; but there is one constant that needs to be preserved. It’s data. If...Discuss·46 likes·10.1K readshybrid state
Brian Bakerbrianbaker.hashnode.dev·Feb 26, 2024How to Migrate Reports and Dashboards to Power BIData visualization is an integral part of decision-making in the business world. With the advent of advanced analytics tools, migrating reports and dashboards to platforms like Power BI Migration has become a strategic move for organizations seeking ...DiscussPowerBI
Stephanie Beatricestephbeatrice.hashnode.dev·Nov 15, 2023How to Perform Data Migration in SQLWhen managing files and databases, developers often use the main database server to store them. As such, the stored data may be victim to data loss, theft, and corruption, affecting the individual, the company, and the clients. That's where data migr...Discuss·37 readsSQL
DevOps Bridgedevopsbridge.hashnode.dev·Oct 24, 2023Unlocking the Power of AWS to Azure MigrationIntroduction In today's rapidly evolving technological landscape, businesses are continually seeking innovative solutions to streamline their operations and enhance their competitive edge. One such solution that has gained significant traction is the...DiscussAWS
Computicscomputics.hashnode.dev·Oct 4, 2023Data Pipeline Power - Proven Tips for Scalability SuccessData is the lifeblood of modern businesses, and the ability to efficiently extract, transform, and load (ETL) data from various sources into a central repository is crucial for making informed decisions. A scalable data pipeline is your secret weapon...Discussdataanalytics
Vladimir Márquezvladho.hashnode.dev·Aug 24, 2023Security Measures in AWS Data Migration Project"When migrating block and object storage to the AWS Cloud, it's crucial to consider security measures to protect your data during the migration process. AWS provides various security features and services to help ensure the security of your storage m...DiscussAWS Data Migration - Fundamentalsdatamigration