Blog Posts

Why RDP'ing into a SQL machine is a bad idea

• General , Tipstricks

Guys, you should stop doing this, there are reasons if it’s not recommended to log into the SQL Server Machine via RDP as opposed to using a client on your PC (or another machine).

Presenting at SQL Saturday

• General

I’ll be presenting my session on “How to use PowerBi as a Free monitoring tool” this Saturday in Parma.

Use SQL Server on Docker for Windows, the easy way

• General , Powershell

I wanted to install and test SQL Server 2019 on a new machine, without the hassle to create a VM from scratch, since I had none of my resources from this new place, that’s when I remembered about Docker and how Microsoft is slowing reaching feature parity for SQL on LInux , moreover, I didn’t need any of the unsupported stuff, so.

Watch the Replay of my Session @ GroupBy

• Powerbi

https://youtu.be/aP15fp99h2s

Slides and materials for my session "How to use PowerBI as a Monitoring Tool" @ GroupBy.org

• General

Good news everybody! As you may know if you follow me on Linkedin , I’ve been selected as one of the GroupBy Speakers for the last GroupBy session for 2019!

DeadLock Art

I love when it happens

PROTIP: Performance Tuning on the cloud will save you money by the hour

• General , Performance

Note: I'll be focusing on Azure Cloud and SQL Server, but these considerations are valid for any Cloud/DB Vendor.

Creating a Report and distributed Alerts for PowerBI Scheduled Refreshes in your organization (starring Powershell, PowerBi & Microsoft Flow)

• Powerbi , Powershell

The Issue If you ever tried to manage a PowerBI Tenant, you may have come across this problem:

How to implement a Linear Regression Prediction in a PowerBI report using Python

• General , Powerbi

Machine learning is the buzzword of the moment, so I wanted to talk about that sweet ML here too.

Get faster performance and lower network usage in SQL Server Loops by avoiding the "DONE Token" overload

• Performance , Tipstricks

FYI: You can get the Notebook for this article on my github and experiment yourself (opens with Azure Data Studio ).