I've been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to the data tier. Writing the ...

Microsoft offers two paths for running enterprise databases: SQL Server, which you install and manage yourself, and Azure SQL, which Microsoft runs for you as a managed service. Both use the same ...

Change Event Streaming (CES) in SQL Server 2025 and Azure SQL enables event-driven architectures by streaming JSON records from table activity to Azure Event Hub, with Entra support now available in ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

-- provided it is supported in the edition / pricing tier of the database. -- It does the following: -- 1. Validate that In-Memory OLTP is supported. -- 2. In SQL Server, it will add a ...

Database administrator with 14+ years of hands-on experience in database management and database design.

Tables are used to store the data in Microsoft SQL server. Tables are created inside DATABASE of SQL SERVER to store data. In tables, data is logically organized in row and column format. Each row ...

To identify the cause of high memory utilization, you need to gather information about SQL Server's memory usage. You can use the following tools to collect this information: Performance Monitor: Use ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a different trick ...