Some elastic pools may not be discovered Elastic pools with no databases aren't discovered. No resolution. Error messages are received when Azure SQL Server is ...

Changes that are made to an availability group database on the primary replica (such as `INSERT`, `UPDATE`, and `DELETE`) are written to the transaction log and sent to the availability group ...

CPU issues have long been the bane of database and system administrators. I have worked on enterprise databases since the mid-1980s and seen three significant eras for CPU architecture and ...

I’ve had a bit of a time lately troubleshooting some database issues and I finally got them worked out so I thought I’d talk about my layered approach to pinning down issues on a busy box. The problem ...

Hi everyone! It's great to be back on Database Trends and Applications magazine. While I dropped out of the regular columnist position for quite a while, I was still hard at it promoting strong ...

The development team throws a party when it delivers a new database-oriented application to the business community. But the network exec, like Cinderella, can’t go to the party. All too often, the ...

Abstract: Exponentially growing number of workloads has been transferred from on-premises to the cloud environment during last decade. It incurs a constantly increasing load on the monitoring and ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...