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.
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Comments posted to this topic are about the item Removing TDE
Comments posted to this topic are about the item The day-to-day pressures of a...
How do I remove TDE encryption of data from database xxx?
See possible answers