Microsoft broke new ground in scalability when it launched Azure SQL Database Hyperscale. Here's what it took to make Microsoft's hyperscale vision work with the existing Azure infrastructure. When ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

This template provides a baseline for evaluating enterprise DBA candidate’s skill set, ranging from application deployment support to database design.

About 5,500 of the SQL Server faithful came out for the PASS Summit 2018 in Seattle last November. As usual, the event had the feel of a great big family reunion. It’s always a fun time, with lots of ...

Microsoft's early embrace of advanced AI in its dev tooling continues apace with the new public preview of SQL database in Microsoft Fabric, the company's analytics/data platform. Fabric is a ...

Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks. While the embrace of big data, machine learning, and IoT by business enterprises everywhere may ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

The ‘Suspect’ mode of the SQL database indicates that the recovery process has started but failed to complete. The database goes into suspect mode if the primary data file is damaged or the database ...

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...