Data analysis is no longer a specialist skill reserved for analysts. It now supports finance, trading, ecommerce, marketing, ...

Microsoft shipped SQL Server Management Studio 22.7.0 on Wednesday, June 10, 2026, in what the team called one of the bigger point releases in the 22.x cycle. Database developers who have spent years ...

Power Query and Power Pivot help Excel users manage large datasets more efficiently. Power Query focuses on cleaning and preparing data, while Power Pivot handles analysis and reporting. Together, ...

pgdiff compares the schema between two PostgreSQL 9 databases and generates alter statements to be manually run against the second database to make them match. The provided pgdiff.sh script helps ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

Earlier, we discussed SQL Databases. In this post, I will list some popular open-source, free database software. Before starting any service online, it is necessary to choose a database that can ...

DBCC CLONEDATABASE command generates a schema-only clone or copy of a database. Effective March 1, 2025, Microsoft will no longer support creating copy of a database using the DBCC CLONEDATABASE ...

COMMENTARY In late 2023, I wrote an article comparing how well ChatGPT and Google Bard handle writing security policies. Given that ChatGPT 4.0 has been available as a paid version, called ChatGPT ...

See whether Databricks or Snowflake is the better ETL tool for you using our comprehensive guide to compare their features, pricing and more. With more and more solutions entering the enterprise ...

We are less than one month into 2023 and already have a new release of Azure Data Studio to share—introducing 1.41! With this release, we migrated to a new authentication library, made improvements ...