Have a Plan for Your Personal Downtime
Most of us know that spending a lot of time on social media and surfing the web isn't good for us, but we still do it. Why? Because it...
2025-01-17 (first published: 2025-01-07)
497 reads
Blog Posts
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....
2025-01-16
33 reads
2025-01-16
5 reads
How to Convert FileTime to DateTime
One of my customers recently wanted to rename each of the SQL audit files will the datetime stamp of when it was created. I explained to them the filename...
2025-01-15 (first published: 2024-11-05)
599 reads
SQL Server Error 9002 – Full Transaction Log
A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else...
2025-01-15
44 reads
Using Flyway Prepare for State-Based Deployments
One of the neat enhancements made to Flyway was the addition of state-based workflows and tooling. A lot of people have loved SQL Compare or SQL Source Control for...
2025-01-15 (first published: 2025-01-08)
1,715 reads
SQL Saturday Oregon & SW Washington 2024
Wow I am so late in posting these notes! But this conference was amazing, so figured still good to post my notes from the incredible sessions I attended! Hope...
2025-01-14
26 reads
T-SQL Tuesday #182: Personal Integrity
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from the first non-founder to host a party, Rob Farley. I reached out to Rob and...
2025-01-14
37 reads
Grinding Away: Mary Spender
A few years ago I stumbled on this video and loved it. That led me to Mary’s page and this cover of John Mayer’s Stop This Train: Since then...
2025-01-13
17 reads
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because...
2025-01-13 (first published: 2025-01-07)
1,938 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Experience Next-Level Cooling Comfort with RCM AC Systems
ashes over you, making you forget the relentless sun outside. Instantly, your energy lifts,...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers