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.
Learn how to stop the data sync process in SQL Server Merge Replication on a large table during maintenance windows.
With a data breach at Marriot, there is a call from one person for companies to spend more on security.
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.
Many organizations that run older versions of SQL Server are not patched.
In which Erik works around the documented limitations with CROSS APPLY.
In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.
Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.
SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Ruko Taman Kedoya Permai, Blok A 1A, No.4-5, RT.11/RW.5, Kb. Jeruk, Kec. Kb. Jeruk,...
Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blok AN, RT.004/RW.001, Bojong Rawalumbu,...
Ruko Tomang Tol, Blk. A1 No.21-22 Raya Blok, Kedoya Sel., Kec. Kb. Jeruk, Kota...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers