New Job -> Week 7 and Beyond
This is part of a series of new job blog posts. You can find them all here. As a DBA, the first six weeks on the job can be...
2023-05-10 (first published: 2023-05-01)
158 reads
Blog Posts
Code That Writes Code
“Work Smarter, not Harder” We’ve all heard it before, pretty much any job, anywhere. In our DBA slice of the IT world, this is very relevant to how we...
2023-05-08 (first published: 2023-04-28)
511 reads
Tales From The Field Weekly Wrap Up for the Week of 05-01-2023 A new house, a reunion, & 15 Years of SQL Saturday Jacksonville
Hello Dear Reader, what a week! On Thursday my wife and I closed on a new house. We are so incredibly excited! We owned a house for a very...
2023-05-08
17 reads
What Is Azure Data Factory?
What Is Azure Data Factory? Azure Data Factory (ADF) is a cloud-based PaaS data integration solution that provides a fully managed, serverless environment for ingesting, preparing, and transforming your...
2023-05-08 (first published: 2023-05-01)
699 reads
A New Word: Chysalism
Chysalism – n. the amniotic tranquility of being indoors during a thunderstorm? While I love the sun, I did enjoy thunderstorms when I lived in Virginia. Something neat about...
2023-05-05
28 reads
Change the Default Git Branch for a dbt Cloud Project
In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what...
2023-05-05 (first published: 2023-04-24)
41 reads
Exporting SQL Data Compare Results to Excel
I had someone ask recently about getting SQL Data Compare results in Excel. It’s easy to do and this post looks at the process. Exporting a Comparison I won’t...
2023-05-05 (first published: 2023-04-25)
153 reads
Traveling to SQL Saturday Jacksonville 2023
I’m heading to SQL Saturday Jacksonville 2023 today, speaking tomorrow. After not making any of their events, I went in 2022 and am back for their 15th event this...
2023-05-05
30 reads
Adding microseconds to a timestamp in Azure Data Factory
(2023-Apr-25) It’s not hard to see that many different teams were involved in building Azure Data Factory (ADF) product at Microsoft. It doesn’t have conformed constraints for naming the objects...
2023-05-03 (first published: 2023-04-25)
930 reads
Find out how fast is your SQL database growing using the backup metadata from msdb
Sometimes I need to know how fast a database is growing, or which particular database is growing the most out of all the databases on a SQL instance. Now...
2023-05-03 (first published: 2023-04-24)
799 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers