Dynamic Data Masking is an exciting new feature in SQL Server 2016, allowing DBAs to centrally set a mask that is returned for a table column instead of the actual data, limiting what information is returned to certain users in a consistent and reliable way. What’s more, Redgate SQL Compare safely and reliably handles your DDM changes. Data Platform MVP Steve Jones explains more.
A guide to using Visual Studio to create U-SQL projects and scripts.
The march to the cloud is ongoing and Steve Jones says you should prepare yourself. Even if your company doesn't move.
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.
Today Steve Jones talks about the problem of having code that people are afraid to change or deploy.
Although it is well-known that the best efforts of a development team can be derailed by mistakes in the architecture, design and general governance of a development project, few attempts have been made to describe what needs to be done to increase the chances of success in the development of a database application. William Brewer steps into the breach to itemise what a delivery team needs to succeed.
SSMS has spent years being neglected, merely being kept compatible with SQL Server and its features: But now we have, instead, the promise of monthly delivery of new functionality
Today Steve Jones notes that back doors could be inserted into chips, which would be a huge problem.
With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
Comments posted to this topic are about the item The Vector Data Type
What is the vector data type in SQL Server?
See possible answers