A robust Python script that converts Excel (.xlsx, .xls) and CSV files to T-SQL INSERT statements, ready for execution in SQL Server or Azure SQL Database.

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs. I ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

Abstract: Data plays a crucial role in computer science, serving as its backbone in various applications. Understanding and interacting with data stored in databases often requires technical knowledge ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

In this post, we will go step by step into several aspects of Change Data Capture, a feature that is available on the Azure SQL Managed Instance and Microsoft SQL Server. The focus will be on the ...