What is new in Copilot, the new features available
Learn how Daniel Calbimonte is using the AI in Bing to have some fun, write some code, and get help.
2024-05-27
907 reads
Learn how Daniel Calbimonte is using the AI in Bing to have some fun, write some code, and get help.
2024-05-27
907 reads
Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.
2024-05-27
Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.
2024-05-24
505 reads
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
306 reads
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach. One of the benefits of having a more code-based approach in data pipelines is that it has become easier to build metadata driven pipelines.
2024-05-24
Learn how to use the OneLake Explorer and Data Wrangler extension in VS Code to empower users to work with data in Microsoft Fabric.
2024-05-22
993 reads
We experienced several unplanned outages and failovers on our SQL Server Always On Availability Groups. We want to know the root cause to prevent them from happening in the future. How do we identify the root causes of unplanned Availability Group outages and failovers?
2024-05-22
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2024-05-21 (first published: 2022-09-01)
2,707 reads
This article includes an overview of how big data and Artificial Intelligence (AI) models work together.
2024-05-20
659 reads
The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input and transforming it into usable data for querying and analyzing. We used sample data from the Advent of Code 2023 to demonstrate some of the ELT techniques in PostgreSQL.
2024-05-20
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...
In the introduction, I explained the setup of the use case and why we...
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