How I go prepared for the MS DP-300 exam
How I go prepared for the MS DP-300 exam

First of all, congratulations for deciding to get prepared for this exam. You apparently have lots of guts and determination! To my honest belief, this was a demanding exam that required focus and discipline in order to pass it. I was not confident that I would be able to get a Pass on the first... » read more

Fix error code 0x8009030c: Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Fix error code 0x8009030c: Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication.

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

Debate: Multiple Instances vs Single Instances on SQL Servers
Debate: Multiple Instances vs Single Instances on SQL Servers

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

SQL Data Classification using SSMS
SQL Data Classification using SSMS

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

Get all connections to SQL Server by using netstat
Get all connections to SQL Server by using netstat

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

Deploy MS SQL Server 2019 on Mac
Deploy MS SQL Server 2019 on Mac

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 error occurred during the execution of xp_cmdshell. A call to ‘LogonUserW’ failed with error code: ‘1326’.
An error occurred during the execution of xp_cmdshell. A call to ‘LogonUserW’ failed with error code: ‘1326’.

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

OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server returns message “Unspecified error”.  (Microsoft SQL Server, Error: 7303)
OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server returns message “Unspecified error”. (Microsoft SQL Server, Error: 7303)

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

Global e-mail profile missing from SQL Server
Global e-mail profile missing from SQL Server

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