The beauty and joy of a relational database is the concept of relational closure—everything is a table. Beyond the eponymous table, query results are also “tables.” Any query serves as a table to be ...

Tom Fenton shows you two ways to overcome the gotchas when setting up an ODBC connection to a remote database. This article is a follow-up to one I wrote in August 2017, "How To Set Up a SQL Express ...

Microsoft introduced a new service into its "intelligent edge" portfolio at the recent Build conference. Here's how Azure SQL Database Edge will fit into the company's broader vision for a more ...

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I look at ...

Microsoft unveiled .NET Aspire at the Build 2024 developer conference, describing it as an opinionated, cloud-ready stack for building observable, production ready, distributed, cloud-native ...