Creating Deep and Shallow Delta Clones in Azure Databricks
In this article we will look at how to create deep and shallow clones of source data when using Azure Databricks.
2021-05-26
data
How to Generate Fake Test Data for SQL Server
How to use a SQL random data generator to fill SQL Server tables with realistic test data, to shift left database unit testing, integration testing and performance testing so that it is performed during the early stages of database development.
2021-05-03
Learn basics of Data Wrangling in SQL Server to handle Invalid Values
In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.
2021-04-23
Using Azure SQL Data Sync to Replicate Data
Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.
2021-03-02
Comparing and Syncing Data using SQL Data Compare Command Line
Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes.
2021-02-24
Getting your SQL Server Development Data in Three Easy Steps
Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the number of rows for testing.
2021-01-14
Blogs
How to give developers access to Query Store
Let’s have devs look at their own query performance. Yes, please, sign me up...
Sharpen Your SQL Skills: June’s Challenge Awaits!
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
Denver Dev Day – Best Practices for Database Deployments Resources
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
Forums
The name of column index 9 is empty ADF
Hi I am brand new to Data Factory I am getting the following error...
How to set execution timeout in SSMS for SQL Server Programmatically
I want to set the execution timeout in SSMS Connection properties on the 'Connect...
The SQL Assessment API
Comments posted to this topic are about the item The SQL Assessment API