During development, you'll occasionally need an undo script that drops a group of tables, or you might need to truncate a group of tables and then insert fresh data in order to run some tests. Unless you perform the required actions in the correct dependency order, you'll be tripped up by foreign key constraint violations. This article provides a SQL function that returns the list of tables in the correct dependency order.
Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you're merging a pair of tables with hundreds of columns, since the script doesn't know anything about them. This technique introduces and populates some auditing columns (IS_DELETED, IS_INSERTED, IS_UPDATED, TRANSACTION_DATE) for each record, and runs fast. […]
This article explores three key areas that need to be considered to make digital transformation occur: as a response to current changes, in preparation for future changes and to enhance the human experience. Read on to find out more!
Learn about the new functions JSON_OBJECT and JSON_ARRAY to work with JSON formatted data in SQL Server.
As I looking at the feed of technology stories this week, two things jumped out at me. First, Valentine's day happened to fall on the monthly release day for Microsoft updates and feature previews. If you work with Azure services, specifically in the data platform space, there are a lot of update announcements to work […]
Do you have a set of practices for building software in your organization?
A list of builds for SQL Server 2014, through CU4 for SP2 and CU11 for SP1.
SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book.
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