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, ...

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 ...

If two SQL returns different results -> test fails. Application supports TeamCity Service Messages (##teamcity messages) so if teamcityLogsEnabled is set to "true" (config file or command line ...

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 ...

In one of the previous articles, we explained the difference between the two SQL-flavored pools in Azure Synapse Analytics, and, what’s even more important, in which scenario it makes sense to use ...

I was recently working with a client to review their proposed database configuration for their SharePoint Server Subscription Edition environment. They were going to be upgrading from an earlier ...