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

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

Curious engineer writing about things that work, fail, and unexpectedly scale. SQL practice is boring because nothing feels real. You type SELECT * FROM users, get a green checkmark, move on. The data ...

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