SQL Server MSDB Database Tutorial
In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database.
Hacking the Admin
A Twitter hack brings into the question of who can make changes in production for Steve.
Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016
This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.
Automate Database Restore for SQL Server
In this article we look at how to automate a SQL Server database restore using a PowerShell script.
TDE BYOK and Geo-Replication in Azure SQL DB
Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
Power BI Incremental Refresh for SQL Sources
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
A Dedicated Space
Today Steve looks at one possible future of offices, which might be something we own.
Loading data in Azure Synapse Analytics using Azure Data Factory
This article shows a basic Azure Data Factory pipeline to load data into Azure Synapse.
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