Prevent Duplicate Records in SQL using Filtered Index
In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table.
Getting Your DBA Teams Scripts into Git
In this article, you will learn how a team can start to better manage the scripts they use for their daily work.
The Cost of Rework
Steve notes that we're always better doing things better the first time. That takes some effort.
Concepts and Issues in Test Data Generation
Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you need plenty of data of exactly the right type, size and verisimilitude
Shout Your Successes
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)
Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating
What Metrics Do You Collect?
Monitoring and observability are becoming more important in today's 24x7x365 environment for applications. Steve asks what data helps you solve problems today. Tell us what's important to you.
Build Chatbot with Large Language Model (LLM) and Azure SQL Database
In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.
Control OneLake with Storage Explorer – Data Engineering with Fabric
In this new article, we examine how to work with OneLake storage.
Where to Test Your Code
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers