Key2 Consulting
  • Home
  • Solutions
    • SOLUTIONS
      • Data Warehouse Solutions
      • Business Intelligence Solutions
      • App Development Solutions
    • SOLUTIONS BY TECHNOLOGY
      • Big Data
      • Cloud
      • Kronos Workforce Analytics
      • Microsoft
    • SOLUTIONS BY INDUSTRY
      • Finance
      • Manufacturing
      • Pharmaceutical
      • Public Sector
      • Retail
  • Company
    • About
    • Careers
    • Our Team
    • Contact
  • Resources
    • Blog
    • SSIS eBook
    • Vlog (Videos)
  • 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 Ways to Offer Great Service as a Consultant
  • Quick Overview of SQL Server on Azure Virtual Machines
  • How to Import Multiple CSV Files into Power BI

Categories

  • .NET
  • Amazon
  • Amazon MWS
  • Amazon QuickSight
  • Analytics
  • Apache Spark
  • App design
  • Application Development
  • Azure
  • Azure Machine Learning
  • 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
  • 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 Applications
  • Web design
  • Web Development
  • What's Happening at Key2
Copyright © 2020 Key2 Consulting