Advice I Like: Examining My Past Self
If you are not embarrassed by your past self, you have probably not grown up yet. – from Excellent Advice for Living While I’d like to think most of...
2025-05-02
15 reads
Blog Posts
Can I Change a Primary Key Value? #SQLNewBlogger
I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of...
2025-05-02 (first published: 2025-04-23)
514 reads
Preparing for the TOGAF 9 Foundation Exam
Now that I've completed both TOGAF 9 tests, I am putting up a couple of quick posts on how I prepared for these Enterprise Architecture exams.
2025-05-02
32 reads
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using Ollama. There is no cloud, and there is no cost. Just install, pull a model,...
2025-05-02 (first published: 2025-04-17)
427 reads
DevOps Day – Atlanta
No tour this year, but Redgate does have a few DevOps events scheduled. I’m hoping for more, and the first one for me this year is Atlanta. You can...
2025-05-01
25 reads
SQL Server Budgets: How to Justify Cost to Management
Ever tried to request SQL Server funding from the CFO? Your systems, your data, your customer experience – they all rely on that “invisible” database engine humming along behind...
2025-05-01
48 reads
FabCon 2025 Recap
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best way). It was incredible to see so many folks in Redmond for the MVP Summit,...
2025-04-30 (first published: 2025-04-15)
205 reads
Index Maintenance Can Change NORECOMPUTE Settings
I had a customer recently ask about a change in one of their constraints on production, where a new option appeared when they went to deploy some changes from...
2025-04-30
137 reads
So You Think You Should Get a Radio
This is not database related, so if you’re not interested in hearing about something besides SQL Server, PostgreSQL, DevOps, community or data management in general, time to move on....
2025-04-30
32 reads
SQL Server Wait Stats
Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...
2025-04-30 (first published: 2025-04-16)
391 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