Aim: Set service accounts for SQL Server after installation. In Server Manager, create a new user with a strong password for the SQL Server instance service.…
The Right Join
Aim: Determine which SQL Server Features are installed and configuration settings. To determine which features are installed on a server, run the Discovery Report which…
Another performance issue identified was the use of Cursors when applying Table-Valued Functions to large datasets, whereby the TVF was applied to each individual record…
I recently worked with a team on a project to improve performance of a legacy system and one of the issues we encountered was low…
I recently came across an interesting way of using the REPLACE function in SQL Server to replace multiple (different) string patterns. Usually, we use the REPLACE…
Aim: Pass parameters from TeamCity to nuspec files in order to set the solution configuration from TeamCity. In TeamCity, create a new system parameter in…
I recently came across this error when attempting to build an SSDT solution that had been handed over to me by another developer. The database references…
Aim: Test speed of durable memory optimized tables against non-durable. In the previous post, I tested the speed of memory optimized tables & natively-compiled stored…
Aim: Test speed of memory optimized tables & natively-compiled stored procedures against disk-based tables & stored procedures. There are a couple of examples available from…
I’m currently doing a Data Science on Coursera (https://www.coursera.org/course/datasci) that requires me to complete assignments using a provided virtual machine. The easiest option for playing the VM…