Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking.
2018-11-27 (first published: 2018-10-30)
4,920 reads
Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.
2018-11-27
2,290 reads
Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues and Perform assessment when Migrating to Azure SQL Database or to SQL Server on an Azure Virtual machine.
2018-11-26
1,844 reads
In this tip we look at how you can monitor Azure health to know if there are any issues that may interupt your services running on Azure.
2018-11-26
1,932 reads
Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework
2018-11-23 (first published: 2015-08-27)
3,836 reads
In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.
2018-11-23
3,977 reads
An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.
2018-11-22 (first published: 2016-06-23)
16,201 reads
In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.
2018-11-22
2,396 reads
n this tip we will explain how you can deploy, execute and schedule SSIS packages in the Azure cloud.
2018-11-21
1,712 reads
2018-11-20
258 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers