Key2 Consulting
  • Home
  • Consulting Services
    • SOLUTIONS
      • Data Warehousing
      • Business Intelligence
    • SOLUTIONS BY TECHNOLOGY
      • Azure
      • Power BI
      • Azure Databricks
      • Azure Data Factory
      • Azure Data Lake
      • Azure Synapse Analytics
      • SQL Server
      • SQL Server Analysis Services (SSAS)
      • SQL Server Integration Services (SSIS)
      • SQL Server Reporting Services (SSRS)
    • SOLUTIONS BY INDUSTRY
      • Finance
      • Manufacturing
      • Pharmaceutical
      • Public Sector
      • Retail
  • Company
    • About
    • Careers
    • Our Team
    • Contact
  • Resources
    • Blog
    • Case Studies
    • SSIS eBook
    • Vlog
  • Contact
Select Page
How to Copy Multiple Tables from On-Premise to Cloud in Azure Data Factory with PowerShell (Part 2)

How to Copy Multiple Tables from On-Premise to Cloud in Azure Data Factory with PowerShell (Part 2)

Apr 1, 2020 | Cloud Technology, PowerShell, Technical Information

By: Phil Woubshet     In part 1 of this series, we implemented a solution within the Azure Portal to copy multiple tables from an on-premise SQL Server database to Azure Synapse Analytics (formerly Azure SQL Data Warehouse). Today’s exercise will be to...
How to Copy Multiple Tables from On-Premise to Cloud in Azure Data Factory

How to Copy Multiple Tables from On-Premise to Cloud in Azure Data Factory

Dec 3, 2019 | Azure, How To, SQL Server, Technical Information

By: Phil Woubshet     This exercise will demonstrate how to copy multiple tables from an on-premise SQL Server database to Azure SQL Data Warehouse. We will use a metadata table that contains the schema/table names to drive the copy process from source to...
PowerShell – How to Display Job Progress

PowerShell – How to Display Job Progress

Sep 11, 2019 | How To, Microsoft, PowerShell, Technical Information

By: Mason Prewett   We’ve written many blog articles about PowerShell and how incredibly useful the Microsoft framework can be, and this article is another example. PowerShell is a great tool for performing long running tasks. A common strategy used to...
Introducing ‘SharePoint Things’, Our Newest Video Series

Introducing ‘SharePoint Things’, Our Newest Video Series

Aug 27, 2019 | How To, Microsoft, Microsoft PowerApps, SharePoint, Technical Information

By: Austin Gainey     Did you know you can utilize Microsoft PowerApps to customize out of the box SharePoint Online forms, which can then be used to take down corrupt secret government projects, destroy cars with telekinesis, and cut through the fabric of...
Manipulating the Target Table in a SQL SELECT…INTO Statement

Manipulating the Target Table in a SQL SELECT…INTO Statement

Aug 6, 2019 | How To, SQL Server, Technical Information

By: Andy Kim   Introduction The SELECT…INTO statement is an excellent tool to have in your arsenal if you’re a SQL developer. The SELECT…INTO statement: Creates a target table for you automatically, eliminating the need to manually create a table....
Working with Local Groups Using PowerShell

Working with Local Groups Using PowerShell

Jul 18, 2019 | How To, PowerShell, Technical Information

By: Matt Wisor     PowerShell to the Rescue Carrying out server maintenance on a regular basis can be challenging, especially if users are working in the application being serviced. Applying a Visual Studio update, for example, may corrupt the application if...
« Older Entries

Recent Posts

  • 5 Key Takeaways From PASS Data Community Summit 2022
  • Migrating from Power BI Premium Per User (PPU) to Premium Capacity – What You Should Know
  • Power BI Import vs. DirectQuery – Which is Best for You?

Categories

  • .NET
  • Amazon
  • Amazon MWS
  • Amazon QuickSight
  • Analytics
  • Apache Airflow
  • Apache Spark
  • App design
  • Application Development
  • Artificial Intelligence
  • Azure
  • Azure Cosmos DB
  • Azure Data Factory
  • Azure Data Lake
  • Azure Databricks
  • Azure Machine Learning
  • Azure Synapse
  • Big Data
  • BIML
  • Business Intelligence
  • Careers
  • CCPA
  • Cloud Technology
  • Conferences
  • Consulting
  • COVID-19
  • Custom Development
  • Data Encryption
  • Data Governance
  • Data Management
  • Data Regulations
  • Data Security
  • Data Visualization
  • Data Warehousing
  • Databricks
  • Entrepreneurship
  • Fantasy Football
  • Featured
  • Featured
  • GDPR
  • GitHub
  • healthcare
  • How To
  • Key2 Stories
  • Machine Learning
  • Microsoft
  • Microsoft Excel
  • Microsoft Power Automate
  • Microsoft Power BI
  • Microsoft PowerApps
  • Open Source
  • PowerShell
  • RevoScaleR
  • Salesforce
  • Self-Service BI
  • SharePoint
  • Snowflake
  • Software Development
  • SQL Server
  • SSIS
  • Tableau
  • Tales from Consulting
  • Tech Tips
  • Technical Information
  • Uncategorized
  • Web 3.0
  • Web Applications
  • Web design
  • Web Development
  • What's Happening at Key2