Workload replay with WorkloadTools

• by Gianluca Sartori

• SpaghettiDBA

In my last post, I described how to capture a workload to a file, in order to run a replay against your target environment at a later time. Well,...

2019-07-08 (first published: 2019-06-20)

307 reads

Life behind a proxy server: downloading content for SSMS Help Viewer

• by Gianluca Sartori

• SpaghettiDBA

Life behind a proxy server can be problematic. Not every software out there is tested correctly for proxy interaction and oftentimes the experience for the corporate user is a...

2019-05-22 (first published: 2019-05-09)

309 reads

Generating a Jupyter Notebook for Glenn Berry’s Diagnostic Queries with PowerShell

• by Gianluca Sartori

• SpaghettiDBA

The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature...

2019-04-08 (first published: 2019-03-20)

550 reads

Capturing a Workload with WorkloadTools

• by Gianluca Sartori

• SpaghettiDBA

Last week I showed you how to use WorkloadTools to analyze a workload. As you have seen, using SqlWorkload to...

2019-03-27 (first published: 2019-03-12)

321 reads

Workload analysis with WorkloadTools

• by Gianluca Sartori

• SpaghettiDBA

Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...

2019-02-26

240 reads

Benchmarking with WorkloadTools

• by Gianluca Sartori

• SpaghettiDBA

If you ever tried to capture a benchmark on your SQL Server, you probably know that it is a complex...

2019-02-15

134 reads

A bug in merge replication with FILESTREAM data

• by Gianluca Sartori

• SpaghettiDBA

I wish I could say that every DBA has a love/hate relationship with Replication, but, let’s face it, it’s only...

2018-07-11 (first published: 2018-07-03)

2,143 reads

Recovering the PsGallery Repository behind a Corporate Proxy

• by Gianluca Sartori

• SpaghettiDBA

While getting a new workstation is usually nice, reinstalling all your softwares and settings is definitely not the most pleasant...

2017-12-19

615 reads

How To Enlarge Your Columns With No Downtime

• by Gianluca Sartori

• SpaghettiDBA

Let’s face it: column enlargement is a very sensitive topic. I get thousands of emails every month on this particular...

2017-11-15

785 reads

Introducing XESmartTarget

• by Gianluca Sartori

• SpaghettiDBA

Three years ago, I started to work on a project called ExtendedTsqlCollector. I blogged about it multiple times here on...

2017-10-27 (first published: 2017-10-19)

1,173 reads