Conversion Precedence
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
20 reads
Blog Posts
Daily Coping 20 Sep 2022
Today’s coping tip is to find a caring, calming phrase to use when you feel low. Life is mostly good, but there are times I feel down, depressed, low,...
2022-09-20
10 reads
Meetings Are Work Too
So Many Meetings I’ve said it. We’ve all said it.
I can’t get any work done today, I’ve got so many meetings.
I need to be reminded on occasion that for...
2022-09-20
120 reads
Daily Coping 19 Sep 2022
Today’s coping tip is to make time to remember if you’re busy, allow yourself to pause and take a break. I’m in the UK today, and at the Redgate...
2022-09-19
13 reads
Extended Events for Anything but Query Tuning: bulk_insert_usage
Wouldn’t it be great to be able to directly monitor specific behaviors within SQL Server, like, oh, I don’t know, knowing exactly when, and how, someone is using BULK...
2022-09-19
36 reads
Mental Health Bullet Journal – Collect Data to Help Your Mental Health
Purpose This blog and bullet journal was specially created to help me with my tendency to have suicidal ideation, depressive, and manic episodes related to
The post Mental Health Bullet...
2022-09-19 (first published: 2022-09-06)
272 reads
Unexpected Blocking during the Indexed View Creation
The problem
There was a need to make changes to a table with an Indexed View. Since Indexed Views must be created with SCHEMABINDING, the View must be dropped and...
2022-09-19 (first published: 2022-09-05)
323 reads
Comment might be free, but that doesn’t mean I have to listen
I have turned off comments on this site. All existing comments have been removed. Even the nice ones from awesome people, and the helpful ones, and the ones answering...
2022-09-16
73 reads
Daily Coping 16 Sep 2022
Today’s coping tip is to make time to aim to be good enough, rather than perfect. I find that many of us that work in technology want a solution...
2022-09-16
7 reads
Future Data Driven
I was honored to speak at Future Data Driven last year. This year has a great lineup with some fantastic sessions on data related topics. Register today for the...
2022-09-16 (first published: 2022-09-02)
180 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
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,...
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