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 2017
Adding Python Packages to SQL Server 2017
SQL Server 2017 allows for the use of Python scripts called as an external script. SQL Server comes with some Python packages by default. Today I wanted to talk about adding Python packages to SQL Server 2017. To get started with Python in SQL Server 2017 we must enable the use of external scripts. … Read more
How To Hide an Instance of SQL Server
If you have ever wanted to hide an instance of SQL Server, this is the post for you. Read on.
GDPR Violations Are Hiding In Your Database – Here’s How To Find Them
Today I was attending the Microsoft Virtual Security Summit, and they posted this poll: As you can see, 22% of the respondents believe that their organization is not impacted by the GDPR. I think that many of that 22% have their head in the sand, something I’ve written about before. I’ve seen an uptick in conversations around GDPR recently. They … Read more
SQL Data Discovery and Classification
The new version of SQL Server Management Studio (v17.5) brings with it a new feature: SQL Data Discovery and Classification. You might recall that in SSMS 17.4 the Vulnerability Assessment feature was added. So, that’s two new features in the last two releases. This is the beauty of de-coupling SSMS from the SQL Server install … Read more
Data Migration Assistant Error During Assessment of SQL Server 2017
The Data Migration Assistant (DMA) offers you the ability to perform a feature assessment against your SQL Server database. The DMA will not work if you try to perform an assessment of a source database against an older target version.
