Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow
Learn how to perform data deduplication for Azure Synapse Analytics using Azure Mapping Data Flows.
2021-12-24
Additional Articles
Adding Test Data to Databases During Flyway Migrations
How to add test data to a SQL Server database, during Flyway development. We use SQL Data Generator to produce some "realistic but fake" data and then SQL Data Compare to produce an INSERT script that Flyway can use to load the data into a newly-built version of the database.
2021-12-22
Unity state machine behaviours
Video games would not be much fun without animation. In this article, Lance Talbert demonstrates Unity state machine behaviours to define code running during specific animation states.
2021-12-22
Why cloud and hybrid estates are important - but bring complexity
With 92% of organizations now reported to be multi-cloud, a well thought-out approach to cloud migration is imperative. Download our final insights report in this series on database monitoring to find out how 2500+ of your peers are dealing with the challenge.
2021-12-20
Working with PowerShell strings
Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.
2021-12-20
Connecting to PostgreSQL: Learning PostgreSQL with Grant
Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.
2021-12-17
Did you know SQL Monitor supports Azure databases, too?
SQL Monitor allows you to bring your whole estate into a single monitoring landscape that has a consistent interface, whether you have an all-Azure environment, or, more likely, a mixed database environment. Find out more, here!
2021-12-17
BETWEEN the two of us
BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.
2021-12-15
DBAs at work #2: The airline DBA
How different is it working as a DBA at an airline? Find out how your peers work in this series: DBAs at work. This episode features Deborah Thompson, Database Administrator at WestJet, Canada’s second largest airline.
2021-12-15
A Flyway Teams Callback Script for Auditing SQL Migrations
Demonstrates a cross-database PowerShell callback script for reporting on and auditing Flyway migrations, telling you which scripts were used to create each version, when they were run, who ran them and more.
2021-12-13
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Sabang. Tlpn:085373737845
Jl. H. Agus Salim No.57 B, Kb. Sirih, Kec. Menteng, Kota Jakarta Pusat, Daerah...
BCA KCP Atrium. Tlpn:085373737845
Ruko Atrium Blok E. 12-13, RW.2, Senen, Kec. Senen, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Wahid Hasyim. Tlpn:085373737845
BCA KCP Wahid Hasyim.Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota Jakarta...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers