RDS Connectivity
I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time,...
2024-10-21 (first published: 2024-10-07)
249 reads
Blog Posts
A New Word: Hickering
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens to come along, spending hours wallowing in the handful of details you can gather about...
2024-10-18
19 reads
Denver Dev Day Oct 2024 Slides
Here are the slides from my talk today: CI in Azure DevOps If you have questions, please feel free to contact me (top menu above).
2024-10-18
6 reads
Enabling an Index: #SQLNewBlogger
I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how...
2024-10-18 (first published: 2024-10-02)
244 reads
Minimize Downtime with SQL MI Disaster Recovery
I speak to many people who use cloud technologies, especially database tech and how little consideration they give to their MISSION CRITICAL Databases that run in the cloud and...
2024-10-18
19 reads
Snowflake + Azure blob
Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage...
2024-10-18 (first published: 2024-10-04)
146 reads
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation. Running code during a presentation should be as smooth as possible…so in VS Code I...
2024-10-16 (first published: 2024-09-27)
383 reads
Master SQL with This Free Course (141 Interactive Exercises Included)
SQL is essential for modern businesses and applications that rely on data. It's a robust language that lets you work with databases, pull out the information you need, and...
2024-10-16
51 reads
The Only Valid Test of a Backup is a Restore
Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I’m happy that you have...
2024-10-16 (first published: 2024-09-30)
244 reads
Dumping and Restoring Azure PostgreSQL Databases
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I wanted a simple db to restore onto my single server. I may not have needed...
2024-10-14 (first published: 2024-09-25)
129 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...