Yes, SQL Server Standard Edition is NUMA Aware
The official documentation suggests that SQL Server Standard edition is not NUMA aware due to Standard having limits on the amount of hardware available.
SQL Server 2016
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database.
Auditing Linked Servers
SQL Server does not track this information by default. You need to be proactively auditing linked servers for modifications. Getting started is easy, here’s how.
Data Migration Assistant Custom Configuration
The Data Migration Assistant is a great tool to help you evaluate and migrate your database to newer versions of SQL Server, including Azure SQL Database.
The Seven Samurai of SQL Server Data Protection
I want to help in the struggle against the adversaries. I’ve identified seven data security measures you can use. These ‘Seven Samurai’ will protect against all three possible attack vectors: data at rest, data in use, and data in motion.
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
Last week I wrote about the Meltdown and Spectre vulnerabilities. Today I want to show you how to check if your database server is protected against Meltdown and Spectre.
