Making a PostgreSQL Backup in a Container
I needed to back up a PostgreSQL database as a part of the repro for an issue I had. I hadn’t ever made a backup of PostgreSQL, so this...
2025-02-19
144 reads
Azure SQL offerings
There are three Azure SQL products with so many different deployment options, service tiers, and compute tiers that it can get quite confusing when choosing the right option for...
2025-03-03 (first published: 2025-02-18)
1,233 reads
T-SQL Tuesday #183 Roundup
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions. I didn’t get my own post completed in time, but I’ll add it in the...
2025-02-28 (first published: 2025-02-18)
244 reads
Data Strategy Checklist for 2025
Reflecting on data strategy projects from 2024, key lessons include starting with clear business objectives, prioritizing data ethics and security, and fostering collaboration between business and IT teams. Also,...
2025-02-17
30 reads
A Little Brainstorming with an AI
I was asked to do some a little thinking and brainstorming recently. Rather than send some emails or get on a call, I decided to ask my local AI...
2025-02-26 (first published: 2025-02-17)
362 reads
The Mysterious Empty Table
It seems like no matter how long you work with a system beyond a trivial size, you’ll find something new every so often. A little while ago, I found...
2025-02-26 (first published: 2025-02-17)
390 reads
When is the perfect moment to build a data strategy in a company?
Introduction The challenge enterprises face is adopting new technologies to manage data. But, even more importantly, using the latest technologies is not a solution by itself, and companies should think first about adding value to the organization through...
2025-02-16
11 reads
Choosing to not drive the Tesla
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla at home recently. A few people asked me about it, so I decided to do...
2025-02-14
40 reads
Advice I Like: Transactions and Relationships
Life gets better as you replace transactions with relationships. – from Excellent Advice for Living This is incredible advice. I think that much of the complaints about the US...
2025-02-14
20 reads
The pros and cons of self-service BI: What every industry leader should know
Introduction Growing enterprises or businesses that want to remain competitive must make quick decisions daily. While experience and expertise are essential in that process, making those critical calls is...
2025-02-14
11 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers