Managed Instance Impressions
Today Steve asks about your view of Managed Instance. He has found many people like the offering quite a bit.
Today Steve asks about your view of Managed Instance. He has found many people like the offering quite a bit.
Learn how Daniel Calbimonte is using the AI in Bing to have some fun, write some code, and get help.
Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.
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.
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
Steve has had a good time sharing knowledge with others at events. He gives you a few thoughts on why you might join him at a future event.
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.
Learn how to use the OneLake Explorer and Data Wrangler extension in VS Code to empower users to work with data in Microsoft Fabric.
Steve has a few thoughts on invisible downtime, a term he had never heard until recently.
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?
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