A Bug in ‘Move All Your SQL Database and Log Files in Bulk’
It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it’s all been fixed...
2020-04-22
19 reads
Blog Posts
Daily Coping 22 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-22
11 reads
EightKB – A new virtual SQL Server event
With all the events that have been cancelled over the next few months due to the on-going COVID-19 crisis, Mark Wilkinson (b|t), Anthony Nocentino (b|t), and I wanted to...
2020-04-22 (first published: 2020-04-15)
274 reads
How SQL Server stores data types: DATETIME, DATE, TIME, and DATETIME2
This post dives into how SQL Server stores date and time data types in memory and on disk. But first, a note about endianness: CPUs manufactured by Intel and...
2020-04-22
159 reads
Jupyter Book Challenges in ADS
I was excited to try the Jupyter Book feature in the March Azure Data Studio (ADS) release. I’ve thought notebooks were an interesting way to teach and I’m looking...
2020-04-22 (first published: 2020-04-08)
325 reads
Running Azure SQL Database Edge on a Raspberry Pi
One of the coolest new projects out there is Azure SQL Database Edge: – https://azure.microsoft.com/en-us/services/sql-database-edge/ This allows SQL Server to run on ARM devices which will expand the range...
2020-04-22
5,413 reads
Running Azure SQL Database Edge on a Raspberry Pi
One of the coolest new projects out there is Azure SQL Database Edge: – https://azure.microsoft.com/en-us/services/sql-database-edge/ This allows SQL to run on ARM devices, just think how many devices are...
2020-04-22
234 reads
Coding Standards Gone Bad in SQL Server
Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...
2020-04-21
6 reads
Daily Coping 21 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-21
9 reads
DAX and Power BI Stairway Live
As part of the Redgate Community Circle, I’m going to be running a live class on DAX and Power BI, every Thursday, from 12MDT for about 30-45 minutes. We’ll...
2020-04-21
149 reads
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