Convert Email to SQL Server is often the first step when email data becomes too large, too scattered, or too hard to search. Emails are not just messages anymore. They carry decisions, approvals, ...

A tool which treats CSV and JSON files as SQL tables, performs SQL SELECT queries on them, and stores the result into CSV and JSON files. Many tools and systems can export their data to CSV. Typical ...

Moving data between SQL Server databases is a routine yet crucial task for database administrators and developers. Whether it's for backups, migrations, setting up test environments, or sharing data, ...

With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations. If you have a large data source, such as an Access ...

In server-side JavaScript, you will most likely use the fs library for dealing with the filesystem. This library is a module in Node and other platforms like Bun. So you don’t need to install it using ...

A few years ago a new pair of Profiler events was added for Power BI Import mode datasets (and indeed AAS models): the Job Graph events. I blogged about them here but they never got used by anyone ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

The SQL Server Import and Export Wizard is a tool that allows you to copy data from a source to a destination. This document describes how to use the SQL Server Import and Export Wizard if a source ...

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didn’t realize how ...

Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under ...