Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL ...

A small social media poll from Visual Studio guru Mads Kristensen split respondents over whether the IDE should add more database tooling, while the discussion quickly turned to existing SQL project ...

Abstract: Database forensics is becoming more important for investigators with the increased use of the information system. Although various database forensic methods such as log analysis and ...

The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook data model here. Sample Data Media related ...

Accelerate your AI application's time to market by harnessing the power of your data and the built-in AI capabilities of SQL Server 2025, the enterprise database with best-in-class security, ...

Introducing a new cloud billing option for SQL Server customers, providing pay-as-you-go flexibility across on-premises and cloud environments. License by vCore [4]New Allows customers to elect to ...

New dbForge release improves AI-powered SQL generation and adds PostgreSQL visual query building and table editing By ...

Microsoft has introduced unified Copilot shortcuts and a new Migrations page in SQL Server Management Studio 22.5, making AI assistance and database migration workflows more efficient for warehouse ...

If you are building a simple dashboard or a form-based application, the traditional JSON API (REST or GraphQL) approach is ...