In the latest version of Data Masker for SQL Server, it’s now much easier to rapidly identify sensitive data that needs masking, set up appropriate rules, see which masking rules are applied to which column, and locate what sensitive data you've yet to mask.
We’ve also improved the performance of commonly used masking rules, which lets you run masking operations 3 times faster.
Amazon is providing automatic redaction of PII data in there transcription service.
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
Today Steve starts a mid year review of his career goals and encourages you to do the same.
17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.
Azure SQL Database offers a number of resiliency features that deliver a mix of high availability and disaster recovery capabilities
Now in it’s 4th year, the State of Database DevOps report continues to deliver valuable insights. In the report, you will learn multiple tactics to improve the quality of database code deployment, whether it is by changing the type of environment used for development, enhancing your code review practices, or your change management/approval practices.
Steve talks data virtualization in the age of growing data sets and larger workloads
As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers