About

Gianluca Sartori

Founder and CEO of Quantumdatis · Microsoft Data Platform MVP

Portrait of Gianluca Sartori

I have more than 20 years of experience designing, managing, diagnosing, and optimizing Microsoft data platforms. I have worked hands-on with business-critical production environments and shared practical experience at international conferences. My technical articles and community work have earned me Microsoft Data Platform MVP recognition for 13 years.

My areas of focus include:

  • SQL Server performance and architecture
  • High availability and disaster recovery
  • Migration, automation, and mentoring

I am a SQL Server and Oracle DBA based in Conegliano, Italy. I have worked with SQL Server since version 7 and Oracle since 11g. Before focusing on data platforms, I worked as a Java, .NET, Visual Basic, and ASP developer.

I also build and share open-source tools with the data community, including WorkloadTools and XESmartTarget. You can find my conference sessions on Sessionize and more code on GitHub.

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 recipes for your daily database cooking, with a bit of an Italian touch.

Help yourself.

Archived WordPress comments (11)

Historical comments from the original site; this archive is read-only.

  1. Abu Dina
    Haha... this is great! Very good site and keep up the good work!
    1. spaghettidba
      Thank you good Sir.
  2. Guillermo
    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.
    1. spaghettidba
      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: /2017/12/19/recovering-the-psgallery-repository-behind-a-corporate-proxy/

      Hope this helps!
  3. guy-roger tilkin
    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
    1. spaghettidba
      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
      1. guy-roger tilkin
        Thanks !
  4. Peter

    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?




  5. coraldelectably54cb7ea596

    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.
    1. spaghettidba

      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.


  6. Nour

    Hi, I tried to convert the workload generated on the prod, on the test server and database.the ConvertWorkload.exe produce the log with tracing all events until the last, but the file_convert.sqlite is created at the start of process just with the structure of the table of events, but don't insert any datas in the tables ? the convert workload is the version 1.7.5.0 and the SQL Server is 2019 . Do you have any idea ? Thanks in advance