Tough Interview Questions
Steve ran across a list of interview questions and wonders if it's a good test for an experienced database developer.
Your SQL Servers Are Misconfigured...
It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.
Create Azure DevOps Analytics Visuals with Power BI OData Queries
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
Gitflow Workflow Hotfix Branching for SQL Database Projects
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
Do it. Try it. Fix it.
Building better software requires some experimentation, but also some learning. Building better software as an organization requires even more.
sp_who4
Introduction The analysis of blocking in SQL Server can be hard if the SQL Server instance has a high number of active connections. This analysis becomes complicated because busy instances could have more than one blocking connection, meaning that we could have more than just one blocking chain. For every group of blocked connections, we […]
Oracle archived redo size – the research
Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.
SQL Server SET STATISTICS IO ON Deep Dive
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
Artist or Scientist?
In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?
CRUD Operations in SQL Server using Python
This article goes through a process to show how you can use Python to perform create, read, update, and delete (CRUD) operations on SQL Server data.
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
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
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...
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