The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.
2020-10-16
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
2020-10-15
In this article we look at how you can use SSMS to filter objects, debug, drag and drop object names, add custom reports and use of operators for emails.
2020-10-15
Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.
2020-10-14
Flyway version 7.0 has just been released, and with it comes brand new features that enhance deployment flexibility. Version 7.0 also introduces Flyway Teams, which combines the Pro and Enterprise editions into one comprehensive offering. Join us today at 4pm BST to find out more.
2020-10-14
Learn how to use Git with SQL Server Data Tools to allow branching for development and how to merge development changes.
2020-10-13
Computed columns may be the cause of hard to track down performance issues. In this article, Robert Sheldon reviews the issues and some ways to get around them.
2020-10-12
Learn how to auto scale an Azure SQL Database with Azure runbooks and using an existing runbook from the runbooks gallery.
2020-10-09
Until now, organizations wanting to introduce database DevOps have had to rely on – and purchase – different tools and solutions for different databases. A new cross-platform database DevOps solution, Redgate Deploy, changes the rules. Find out why in this latest blog post.
2020-10-09
Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and how git became the popular tool it is today.
2020-10-08
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Hi All I have a table which contains the transactions done by cards. Below...
I have a lookup table that implements a system-generated Id for DRI purposes. The...
A client would like to be able to recognize similar free-texts in a text...
Ask SSC