SQL Server Security Update for SQL 2014-2019

Oopps! Upgrade your browser pretty please. Oopps! Upgrade your browser pretty please.

Yesterday Microsoft released a Security Update for SQL Server 2014, 2016, 2017 and 2019.
An authenticated attacker could affect SQL Server memory when executing a specially crafted query using $partition against a table with a Columnstore index. If you are using Columnstore Index you should consider to apply this security update.

You can find more information here and you can download update here.

If you want to check your database for columnstore indexes, you can use this t-sql code:

SELECT OBJECT_SCHEMA_NAME(OBJECT_ID) SchemaName,
OBJECT_NAME(OBJECT_ID) TableName,
i.name AS IndexName, i.type_desc IndexType
FROM sys.indexes AS i
WHERE is_hypothetical = 0 AND i.index_id <> 0
AND i.type_desc IN ('CLUSTERED COLUMNSTORE','NONCLUSTERED COLUMNSTORE')
GO

 

Do not hesitate to contact us for further assistant regarding SQL Server.