How to Compare Tables in Azure Data Studio
Learn about the Schema Compare feature in Azure Data Studio.
2022-02-21
9,829 reads
schema changes
Advanced Schema Evolution using Databricks Auto Loader
This article demonstrates how to get started with using Auto Loader cloudFiles with Databricks through an end-to-end practical example of ingesting a data stream which has an evolving schema.
2021-10-01
Fine-tuning Scripted Database Comparisons with SQL Compare
When comparing databases, save your standard options and filters to a single project file, and then use PowerShell to script them out to the command line. This allows you to reuse the same project file across multiple comparison operations.
2021-07-21
Using Delta Schema Evolution in Azure Databricks
In this article we explore schema evolution capabilities and limitations in Databricks with regular parquet format and explore schema evolution features and capabilities through delta format with inserts, appends, and overwrites.
2021-06-04
Allowing for manual checks and changes during database deployments
SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.
2020-06-15
Blogs
SQL Saturday NYC Recap 2025
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
Why Data Silos Hurt Your Business Performance
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Forums
SSPI handshake failed error code 0x80090311
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Need query help - MAX record
Hello - I have attached a Word document here with details about my issue....
Need query help - MAX record
I am having trouble writing linking the MAX query that I created back to...
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers