September 2021 - Andy M Mallon

Identify how many CPUs our database server is using

September 9, 2021 Andy 0

Question Our server where the Microsoft SQL Server 2016 Web Edition server is installed is running very slow. We are thinking of increasing the number of cores licensed on it. However, we need to check how many CPU cores the database is using currently. Our … [Read More]

Function to create SQL TABLE does not works well using Powershell

September 2, 2021 Andy 0

Question I need to get the values from a Excel Sheet (in a shared folder) to export it and then create a SQL Table in my instance. After of this I will execute a Stored Procedure (I already created) in order to create extended properties … [Read More]

Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

Month: September 2021

Identify how many CPUs our database server is using

Function to create SQL TABLE does not works well using Powershell