SQL Server Temporary Stored Procedures
The post SQL Server Temporary Stored Procedures appeared first on SQLServerCentral.
What is new in Copilot, the new features available
Introduction to copilot In Bing, you can now see a Copilot option. In the past, we had Bing Chat. Now, it was changed to Copilot. In this article, we will see what is new in Copilot. When was Copilot introduced in Bing? The rebranding of Bing Chat to C …
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Similar to the SQL Server Agent job Wizard in SQL Server Management Studio, Azure Elastic Jobs Manager str …
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by TakeAway.com: STOP. The content of this article is, of course, about the annual, legendary and unique event called Data Grillen, helt in Linge …
Okay, About That SmartPostgres.com Thing.
In some of the Query Exercises posts here, you might have noticed links over to similar query exercises at SmartPostgres.com, and the free read-only version of the Stack Overflow database I’m hosting there. I’ve held off the questions for l …
[Video] Office Hours: I Feel Like an Amateur Edition
I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling like a SQL amateur! Here’s what we covered: 00:00 Start 01:52 Does Time Really Exist: Hi Brent! What is the best way to ETL? web …
Troubleshoot SQL Server Always On Availability Groups with SQL LogScout
The post Troubleshoot SQL Server Always On Availability Groups with SQL LogScout appeared first on SQLServerCentral.
Empowering Lakehouse Users – Data Engineering with Fabric
Microsoft Fabric allows the developers to create delta tables in the Lakehouse. However, the automation of copying, updating, and deleting of data files in the Lakehouse might not be possible. How can we empower the end users to make these changes manu …
The Future of DBAs: History Rhymes
Eitan Blumin recently wrote a post about the future of the DBA career in which he talked about the rise of jack-of-all-trades IT professionals. It’s a good post. You should read it. I did, and over the last 20 years, I’m pretty sure I …
The CHECK() Constraint
One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that the tables, rows and columns can have constraints on them. This allows you to reduce the types of bad data that can be loaded into y …
Exploring MVCC and InnoDB’s Multi-Versioning Technique
In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing its performance is crucial, especially in highly concurrent environments where multiple transactions compete for resources. InnoDB, the default storag …
How Big Data Supports Gen AI
Big data processing plays a pivotal role in the development and efficiency of Generative Artificial Intelligence (AI) systems. These AI models, which include examples like language models, image generators, and music composition tools, require substant …
Optimizing MySQL: Deleting Data
In the previous parts of these MySQL optimization series, we told you how query optimization works on a high level, then walked you through how you should optimize queries that insert, read, or update data. Remember the laws of physics? “What goe …
SQL Replication Error – the row was not found at the Subscriber when applying the replicated UPDATE command
The post SQL Replication Error – the row was not found at the Subscriber when applying the replicated UPDATE command appeared first on SQLServerCentral.
Managing SQL Agent in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the way SQL Agent is managed inside the tool, both in the …