Andrea Benedetti's Projects
Config files for my GitHub profile.
Sometimes it could be useful check info not with the Azure portal but via code, with tools like SQL Server Management Studio, Azure Data Studio, VS Code, ... Here you can find some queries to retrieve useful information related to Azure SQL Databases.
An Azure SQL Database can't access immediately to another db,even if created on the same virtual server. Here, you can see how to set up an external table in one db that can be used to query data in another db.
COVID-19 Italia - Monitoraggio situazione
With Power BI Desktop, we are able to create a robust, complex and rich data model and sometimes is quite handy to create simple documentation for the tabular database built with PBI: the catalog info, dimensions, attributes, measures, ...
A collection of T-SQL scripts for managing and optimizing data warehouses on Microsoft Fabric
Power BI Analytics from personal Garmin data
Presentations and code samples from my talks, conferences, meetup, ...
Demo script for SQL Server 2019
SQL Server 2019 Polybase demo with MongoDB
Sometimes I receive questions about the difference between Azure Data Studio (ADS) and SQL Server Management Studio (SSMS). The purpose of this topic is to enlist some key points to think about some use cases for each tool.