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 …
T-SQL Tuesday #174: Your Favorite Job Interview Question?
T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for this months topic, I knew I had to answer! One of my favorite things to do is technical interviews (about stuff that I know). So much …
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i. …
Read Data Stored in a Lake Database using Azure Synapse Analytics
The post Read Data Stored in a Lake Database using Azure Synapse Analytics appeared first on SQLServerCentral.