Microsoft just released a community technological preview for the next release of SQL Server. Download…
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.
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.