PROBLEM In my previous post I described how Data Discovery and Classification is a half done tool. Personally I loved…
Read MoreData Discovery and Classification with Data Preview
PROBLEM I’m currently working on a project that is a sort of spaghetti monster. On all sides. The databases are…
Read MoreHow to blind Reverse Engineer SQL Server database to ERD
Problem I lately faced a problem: we are working on a complex ETL project that aims to migrate a database…
Read MoreAssess an enterprise and consolidate assessment reports with DMA
This post has the same title as the official Microsoft guide Assess an enterprise and consolidate assessment reports with DMA. …
Read MoreLet’s get confused: Azure Database for MySQL, MariaDB, PostgreSQL – Part 2
I don’t like to flag problems without providing solutions. In my last post I wrote about how Azure OSS Databases…
Read MoreLet’s get confused: Azure Database for MySQL, MariaDB, PostgreSQL
What’s a server? What’s a database? What’s a schema? … and a table? Let’s make some order here: Server: When…
Read MoreHow to Run the DMA Tool in bulk
Problem In one of my previous post I was discussing how to discover your SQL Server estate. Now that you…
Read MoreHow to discover SQL Server instances on Azure VMs
Scenario Someone told you that migrating your SQL Server estate to the cloud would have lowered your costs. So you…
Read MoreSQL Server :: How to query a whole Data Center
Few days ago I had the time to update one of my too called SQL_Spring_Cleaning. This made me figure out…
Read MoreHow to Find Unused Databases in SQL Server
Problem In my life I’ve lost flights, trains, my wallet, keys… and yes, sometimes is normal to forget databases here…
Read More