[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 …
[Video] Office Hours: Answers for Your Database Questions
Y’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office before tackling a client’s performance issues: Here’s what we covered: 00:00 Start 00:45 Eve: When should you/ …
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in parallel, in order to finish faster. In reality, though, this involves more than just restoring databases. And I have significant skew to deal with: …
Getting Data Out of an Audit Table: Answers & Discussion
In last week’s post, I gave you a trigger that populated a history table with all changes to the Users.AboutMe column. It was your job to write a T-SQL query that turned these Users_Changes audit table rows: Into the full before & after data …
Combining Silver Tables into a Model – Data Engineering with Fabric
Data Presentation Layer Microsoft Fabric allows the developer to create delta tables in the lake house. The bronze tables contain multiple versions of the truth, and the silver tables are a single version of the truth. How can we combine the silver tab …
Why Generative AI Scares the Hell Out of DBAs
I was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age of generative AI. The DBA’s concern was, “What if we hook up generative AI tools to the production database, and someone asks f …