Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.
2017-05-16
3,672 reads
In this new article, we will learn how to access to our Azure DWH tables using C#.
2017-05-15
2,324 reads
Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.
2017-05-15
2,743 reads
On March 29, over 650 people tuned in from around the world to find out more about Redgate's new database provisioning tool, SQL Clone. The webinar answered the FAQs, included some in-depth demos, and gave a look into the technology behind the tool. Catch up with the recording.
2017-05-15
5,212 reads
Almost all SQL Server databases grow in size over time. Capacity planning is an important activity for the DBA. You need to know how long before you run out of space long before you actually do. Here are some helpful tips and tricks.
2017-05-12 (first published: 2016-06-09)
7,777 reads
SQL Server sees the cloned database as a user database, meaning that you can treat it as one, including backup and restore - Steve Jones explains.
2017-05-12
3,815 reads
Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.
2017-05-12
4,017 reads
This article will provide the actual implementation of the control mechanism.
2017-05-11
2,355 reads
Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.
2017-05-11
5,730 reads
In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.
2017-05-10
6,149 reads
By Steve Jones
Houston AI-Lytics 2026–Powerpoint Slides Thanks to everyone for attending my session on running a...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers