Dec 3, 2019 | Azure, 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...
Aug 6, 2019 | 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....
Jun 24, 2019 | Business Intelligence, 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...
Mar 22, 2019 | Consulting, 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...
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...