2024-04-12 (first published: 2018-12-20)
10,172 reads
2024-04-12 (first published: 2018-12-20)
10,172 reads
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies.
2024-04-12
Learn about the SQL Server plan cache and how SQL Server caches query plans, and the potential of plan cache bloat which could impact performance.
2024-04-10
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
843 reads
Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll always get excited to do it again. He’s not just smart, but he’s friendly and funny as hell.
2024-04-08
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
2024-04-05
1,832 reads
In this step-by-step article, learn how to quickly install Python and start writing Python code using Jupyter Notebooks or Visual Studio Code.
2024-04-05
Andy Leonard discusses and demonstrates using Fabric Data Factory to load a CSV file stored in Azure Blob Storage to Azure SQL DB.
2024-04-03
You can create custom statistics distributions, sampling, and histograms in SQL Server 2022 with a new trace flag
2024-04-01
1,166 reads
In this article, we look at how you might go about choosing whether to use SSIS or ADF for your next ETL/ELT project.
2024-04-01
By Steve Jones
Recently I was trying to delete a folder and kept getting the “something is...
In the introduction of this blog post series, I explained the use case: extracting...
In the introduction of this blog post series, I explained the use case: extracting...
I tried to set the execution timeout in SSMS for SQL Server 2017 using...
Comments posted to this topic are about the item Implementing Change Data Capture
Comments posted to this topic are about the item What is new in Copilot,...
I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?
See possible answers