Dec 15, 2022 | Conferences, Microsoft Power BI, SQL Server
The PASS Data Community Summit 2022 was a blast! A handful of people from our company attend the conference every year and this year was no exception. The knowledge gained, connections made, and fun enjoyed in Seattle is always worth the investment. Here are our five...
Mar 30, 2022 | SQL Server
By: Ken Adams The Problem I recently ran across an issue on a project that required a large amount of data to be removed from a table, specifically an issue with the loading of the table causing duplication of data. All non-clustered indexes had been removed...
Mar 14, 2022 | SQL Server
By: Phillip Sharpless The need to export data from a database to some other format is a pretty common scenario for many data professionals. SQL Server Management Studio provides several different ways to accomplish this, some more complicated than others. If...
Feb 4, 2021 | Azure, SQL Server
By: Matt Wisor SQL Server on Azure Virtual Machines is one of Microsoft’s cloud options for customers looking to move SQL Server to the Azure platform. As the name implies, it means hosting SQL Server in the cloud on an Azure Virtual...
Aug 31, 2020 | Data Encryption, Data Security, SQL Server
By: Matt Wisor Data breaches cost U.S. businesses over 1.2 trillion dollars in 2019, according to a ForgeRock Consumer Identity Breach Report cited by Cyware Hacker News. With stakes so high it is no surprise that data security is one of the top...
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...
