Understanding Peer-to-Peer Transactional Replication, Part 1
There are times when you need to share tables between servers, where the table may be updated in both places. Peer-to-Peer Transactional Replication gives you the ability to create a solution. I explain the benefits and the downfalls.
Disable Data Sync for SQL Server Merge Replicated Table via Publisher
Learn how to stop the data sync process in SQL Server Merge Replication on a large table during maintenance windows.
Spend More on Security
With a data breach at Marriot, there is a call from one person for companies to spend more on security.
Data Quality
Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks about data quality and where the issues tend to happen.
Get Patched If Not Supported
Many organizations that run older versions of SQL Server are not patched.
Getting Sneaky With Forced Parameterization
In which Erik works around the documented limitations with CROSS APPLY.
SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2
In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.
Deploy the Database First
Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers