We were recently facing an issue where several SSIS packages failed to execute against a newly created SQL FCI Cluster with DAG and several listeners created, with the following error being received as an output. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: xxx.xxx.x.xxx] SSPI handshake... » read more
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
A debate that is common among DBAs and possibly Architects, is whether should an organization use the what-so-called “SQL Instance Stacking” in order to deploy more than one SQL instances under the same OS, usually a Windows Server system. Let’s just see the advantages and disadvantages listed below: Pros Benefits Consolidation as several systems can... » 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
Recently, we got into a debate on how could we get all possible connections from various (unidentified) standalone applications, to several SQL Servers. Although a solution would be to constantly look the SSMS Activity monitor and collect all relevant information, the time a connection was occurring, it appeared less appealing, time passing, as there would... » 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
Recently, i was invited by a senior developer to investigate an issue with the aforementioned result. User was receiving the below error when tried to execute a specific Stored Procedure by using xp_cmdshell: Msg 15121, Level 16, State 200, Procedure xp_cmdshell, Line 1 [Batch Start Line 338] An error occurred during the execution of xp_cmdshell.... » 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