Five facts about the SQL Server Model Database
In this article we cover interesting facts about the SQL Server model database and how new databases inherit properties from the model database.
Moving from application automation to true DevOps by including the database
This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code.
Growing Outside of the English World
The world is bigger than one country, and Steve is trying to remember that.
Stairway to SQL Server Virtualization Level 2 - The Ideal SQL Server Virtual Machine Architecture
In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.
PowerShell editors and environments part 2
In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.
Reading Stored Procedure Output Parameters in Azure Data Factory
This article will help you to work with Store Procedure with output parameters in Azure data factory.
Removing SA from Azure SQL Database
Azure SQL Database is getting the ability to turn off SQL authentication.
3 steps to get started with Database DevOps
Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve already done the hard part, making the decision to shift the culture. In this blogpost, Grant Fritchey explores three steps you can take next to begin your Database DevOps journey.
Where I See Databases Going in the Next 10 Years
This month, to mark the 20th anniversary of BrentOzar.com, Brent steps back and looks at the big picture.
Maintenance Windows
Is it better to ask forgiveness than permission? Some people take that approach to maintenance windows, but that isn't permissible in the cloud.
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers