The administrative aspect of Copilot here is more like the ChatGPT experience than the T-SQL query builder. You can ask questions like "Why is my database slow?" [Click on image for larger view.] ...

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

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if ...

Why is there such pervasive abuse and misuse of database views today? Views are a helpful tool in building a business intelligence environment, yet many organizations establish practices that not only ...

To find the database name you can pipe the output of Get-AzureSqlDatabasServer directly to Get-AzureSqlDatabase. You can see here that I'll be using a database name of myazuredatabase. [Click on image ...

How will SQL Database Edge connect back to Azure/on-premises? Azure SQL Database Edge has a streaming engine which is built on top of Azure Stream Analytics.