The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)
Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...
Making Temporal Databases Work, Part 3: Saving Data
In part three of this series, Boris Novikov looks at how data is saved and modified in a temporal database and what kind of integrity constraints are needed for temporal tables. If you haven’t seen parts one and two, don’t worry! Links are provided in the article, and we recommend checking them out first.
Ingesting Data From REST API endpoints: Data Engineering with Fabric
In this article on Fabric we will examine how to get data from a REST API.
Separate Reads
Today Steve wonders how many software developers use separate connections for reads and writes in their application.
Relationships with Microsoft Fabric GraphQL API
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
A Tidy Database is a Fast Database: Why Index Management Matters
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
Time to Change Your Team
Many of you can't choose your team, or even change teams if you want, but from an organizational perspective, it might be the right thing to do. Whether you like it or not.
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
Step by step guide to setup PostgreSQL on Docker
Learn how to get started with PostgreSQL using a container to practice database skills.
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers