On a recent SQL migration, we had to obviously move SQL server 2008 R2 databases from one instance on the consolidated server, to another instance on a new SQL FCI of 2016 version. Scripting out and scripting back in the logins, executed smoothly but a thing! A login, scripted in the new SQL server as... » read more
Lately, we’ve had an interesting conversation on how could developers begin to sort of categorize various data stored within SQL databases. As our customer is located in a EU country, they are deeply concerned and have to strictly comply with GDPR, along with a custom security pattern that combines ISO27001 and PCI DSS. Understanding your... » read more
Starting from Edition 2017, Microsoft SQL Server is available for deployment on Linux systems. This short guide lists the steps for installing SQL Server 2019 on a Mac. I will be setting this up on the following system: Beginning with it, it is necessary to install Docker for Mac. You can download it from this... » read more
An interesting request came up from one of our customers. They were unable to complete a process that was running until lately. During a mass update in a database from a Microsoft Excel file, the export process was not producing a file. This custom upload process is based on a Microsoft. ACE.OLEDB.12.0 SQL Server Linked... » read more
During a visit to a regular customer, a strange request came from the upper IT management. As I was told, they noticed that the global email profile in one of their core SQL servers was mysteriously removed, resulting to errors and delays sending emails to some thousand customers, hence, they wanted me to investigate the... » read more