It's just Emanuele showing you what you can do in the Microsoft Data Platform

Archive

A

2024

May 9th - [Video] A SQL script to automatically infer the data types of data that someone just dumped in your DB with no effort
April 3rd - A SQL script to automatically infer the data types of data that someone just dumped in your DB with no effort

2023

May 9th - Quick Tip: Dumb fix for “ORA-26086: direct path does not support triggers” in Azure Data Factory or Azure Synapse Analytics Pipelines

2022

November 23rd - How to connect Azure Data Factory / Synapse Pipelines to Google BigQuery without losing your sanity over connection tokens
May 14th - How to fix “Connect Timeout” and/or “Cannot open server xxx requested by the login” when connecting to Azure SQL Managed Instance in redirect mode

2021

2020

December 18th - SQL Server Diagnostic Notebook Updated
October 26th - There’s a Bug with Extended Events creation in SQL Server Management Studio 18.7: what it is and a workaround
October 17th - Presenting @ DataWeekender the SQL Server Diagnostic Book
September 22nd - The SQL Server Diagnostic Book is now on the Azure Data Studio Marketplace!
September 22nd - How to ship SQL Jupyter Notebooks and Books directly to Azure Data Studio by creating an extension in the Marketplace
August 13th - You can now access the SQL Server Diagnostic Book remotely!
July 14th - How to lose hundreds of thousands of dollars by using functions in SQL Server
May 25th - Quick Tip: How to find the address of the PowerBI local tabular instance
April 7th - You can now script your database objects as a Notebook using SQL Server Management Studio 18.5+
March 23rd - How IT helped the world during the CoronaVirus Pandemic, and how it can continue to help
March 11th - A Self-deployable TICK Stack for ingesting data, monitoring and alerting for any service (including SQL Server)
March 8th - A PowerBI Report for the COVID19 Emergency in Italy
February 13th - How to use Grafana (on docker) to monitor your SQL Server (eventually on docker too) – feat. InfluxDB and Telegraf
January 28th - The SQL Diagnostic Notebook: Update 2
January 20th - Should you put all your eggs in one basket? Thinking about Database eggs and Cloud baskets
January 8th - How to update a SQL Server container on Docker for Windows (spoiler – there is a catch)
January 1st - The SQL Diagnostic (jupyter) Book

2019

November 28th - Why RDP'ing into a SQL machine is a bad idea
November 20th - Presenting at SQL Saturday
November 14th - Use SQL Server on Docker for Windows, the easy way
November 5th - Watch the Replay of my Session @ GroupBy
October 8th - Slides and materials for my session “How to use PowerBI as a Monitoring Tool” @ GroupBy.org
October 4th - DeadLock Art
August 5th - PROTIP: Performance Tuning on the cloud will save you money by the hour
June 24th - Creating a Report and distributed Alerts for PowerBI Scheduled Refreshes in your organization (starring Powershell, PowerBi & Microsoft Flow)
June 10th - How to implement a Linear Regression Prediction in a PowerBI report using Python
May 22nd - Get faster performance and lower network usage in SQL Server Loops by avoiding the “DONE Token” overload
April 29th - SQL Notebooks: On the right track to enhance Data Analysis on SQL Server
April 10th - How to identify the unit of measure of Extended Events durations
April 2nd - Quickly move data between instances for testing using only PowerShell
March 25th - Cast any string directly to XML with auto-escaping characters in SQL Server
March 22nd - How to Show Better Execution Plans in Azure Data Studio
March 20th - Load data directly in SQL Server from a xlsx file, without OLEDB or Excel, using Powershell
January 28th - A SQL Server Permission Report in PowerBI

2018

December 28th - Why identity values can jump by the 1000’s ? Is it normal?
December 16th - Row Level Security Performance Implications
November 4th - A quick function to remove (or keep only) string patterns from SQL Server Strings
September 23rd - A PowerBI Report for SQL Server Agent Jobs
September 16th - Job Performance Analysis PowerBi Report coming soon
August 10th - How to populate a PowerBI Dataset from a REST API, using PowerBI’s REST API, without any code (via Microsoft Flow)
June 29th - SQL Server: How to Find a safe restore point (and who messed up) by reading from the Transaction Log
June 4th - A script to automatically align columnstore indexes to enhance segment elimination (and hence performances)
May 16th - Troubleshooting SQL Server by analyzing the deviation from average values of Waitstats and Perfmon counters
May 2nd - Tracking Dynamic SQL performance automatically with a wrapper on sp_executesql (Dynamic SQL Inception)
April 25th - Creating a Perfmon and Filestats reports in PowerBI [Part 2]
April 16th - A clarification on the waitstat: SOS_SCHEDULER_YIELD
April 4th - Revisiting the classics: Minimizing the Impact of DBCC CHECKDB (by Aaron Bertrand) in 2018
March 21st - What’s the best way to massively update a big table?
March 20th - SQL Server 2017 CU5 enhances troubleshooting for Intra-Query Parallelism Deadlock
March 11th - Test: confronting various methods of bulk loading data from a table to another, what’s the fastest?
March 3rd - Can a single query deadlock itself? Apparently, yes: A curious case of Intra-query Parallelism
February 26th - Scan Performance Showdown: INROW Predicate pushdown VS Batch Mode Adaptive Join vs Columnstore indexes
February 18th - Creating a Perfmon and Filestats reports in PowerBI [Part 1]
February 17th - How to get and decode callstacks in in extended events for recent versions of SQL Server
February 12th - Create an asynchronous multithreaded workflow on your SQL Server using the Service Broker
February 3rd - THREADPOOL, or, Why is SQL server not responsive even the CPU is basically idle?
February 1st - How to avoid the traps when dealing with parallelism