About

Gianluca Sartori

I’m a SQL Server and Oracle DBA based in Conegliano, Italy. I work with SQL Server since version 7, and Oracle since 11g. My interests go from database design and architecture to performance tuning.

I have worked for many years as a Java, .NET, Visual Basic and ASP developer and then decided to focus on the database side of the IT.

Now I’m working with my own consulting company – SQLConsulting.it.

More information can be found here:

The SpaghettiDBA

“Spaghetti” is generally used as a pejorative term for source code, but (hopefully) feeding you with low-quality code is not the purpose of this Blog. My intent is to provide some recipes for your daily database cooking, with a bit of Italian touch.

Help yourself.

Leave a comment
Trackbacks 1
Comments 10

Abu Dina | November 7, 2013 at 5:28 pm

Haha… this is great! Very good site and keep up the good work!

Reply
- spaghettidba | November 7, 2013 at 5:32 pm
  
  Thank you good Sir.
  
  Reply
Guillermo | November 15, 2018 at 7:03 pm

Hi Spaghettidba. I need to run the Powershell command: Install-Module -Name Posh-SSH. But it gives me an error saying “PackageManagement\Install-Package : No match was found for the specified search criteria and module name ‘Posh-SSH’.”. I tried with nuget.exe to install PSRepositories but I got nothing. Can you give me a hint please ? Thanks in advance.

Reply
- spaghettidba | November 16, 2018 at 3:10 pm
  
  You probably have no repository installed. Try this:
  
  Register-PSRepository -Default -Verbose
  
  If it doesn’t work, you probably need to work around your proxy server. See this post for more information: https://spaghettidba.com/2017/12/19/recovering-the-psgallery-repository-behind-a-corporate-proxy/
  
  Hope this helps!
  
  Reply
guy-roger tilkin | January 25, 2024 at 2:56 pm

Hello Gianluca,
thank you for everything you do. Quite helpful !

When I execute .\XESmartTarget.exe –File c:\mon_XESmartTarget.json. This error message comes out :
t XESmartTarget.Core.Target.Start() in C:\GitHub\XESmartTarget\XESmartTarget.Core\Target.cs:line 71
—> (Inner Exception #0) System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.SqlServer.XEvent.Linq.dll’ or one of its dependencies. The specified module could not be found.

even though the dll missing is in C:\Program Files\XESmartTarget.

How can i fix it ?

Guyr

Reply
- spaghettidba | January 26, 2024 at 10:12 am
  
  Hi! I think that you need to install the c++ runtime that is a prerequisite for xesmarttarget. You can find it here https://www.microsoft.com/en-us/download/details.aspx?id=40784
  
  Reply
  - guy-roger tilkin | January 26, 2024 at 2:21 pm
    
    Thanks !
Peter | April 19, 2024 at 1:51 pm

Hi Spaghettidba,

Looking into WorkloadTools, and was wondering what traces would be needed to feed into ConvertWorkLoad make a realistic replica of the original workload?

Reply
coraldelectably54cb7ea596 | June 5, 2025 at 2:40 pm

Hi, Trying to use XESmartTarget to monitor extended events on a Azure SQL managed instance but getting error saying

“Error – XESmartTarget.Core.Target : System.ArgumentException: Format of the initialization string does not conform to specification starting at index 127.”

Any help would be greatly appeciated.

Reply
- spaghettidba | June 5, 2025 at 2:43 pm
  
  Sure, no problem. Can you send me an email? My address is spaghettidba at sqlconsulting dot it. Please share your json configuration file, the problem most likely is there.
  
  Reply