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

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...
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....
Enhance Your SQL Server Tool Belt – How to Add Compression to Existing Objects

Enhance Your SQL Server Tool Belt – How to Add Compression to Existing Objects

Jun 24, 2019 | Business Intelligence, How To, SQL Server

By: Ken Adams   Not Enough Space On my current engagement, we are trying to build a reporting platform that meets the needs of our client while simultaneously adhering to best practices. One of the best practices we’ve established as part of the platform is...
Step By Step – Chaining Jobs With SQL Server Agent

Step By Step – Chaining Jobs With SQL Server Agent

Mar 22, 2019 | Consulting, How To, Microsoft, SQL Server, Tech Tips, Technical Information

By: Jason E. Bacani   Introduction When working with SQL Server Agent, one of the many useful features is the ability to schedule SQL Agent Jobs. The frequency and scheduling of such jobs can be as fancy and as specific as needed, and can be coordinated with...
Key Takeaways from SQL Saturday Atlanta 2018

Key Takeaways from SQL Saturday Atlanta 2018

Oct 9, 2018 | Azure, Business Intelligence, Conferences, Consulting, Data Visualization, Key2 Stories, Microsoft, Microsoft Power BI

By: Andy Kim   Introduction It was a beautiful fall morning as I drove towards the Microsoft office in Alpharetta, GA. I was on my way to attend the annual 2018 SQL Saturday Atlanta – BI Edition. When I arrived, there was a nicely furnished office with great...
« 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