Why Learn PostgreSQL?
At Redgate, we’ve spent a lot of time adding PostgreSQL functionality to our DevOps tools. We’ve also hired an advocate, Ryan Booz, to help us spread the word and...
2023-04-26
314 reads
EightKB 2023 – Schedule and Registration
The schedule for EightKB 2023 Edition has been announced! We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: – N.B. – If you click on the...
2023-04-26
50 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)
965 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)
160 reads
New Job -> Week 6 -> Ozar sp_BlitzIndex
This is part of a series of new job blog posts. You can find them all here. Week 6 goal: Analyze all Azure SQL Database indexes. Last week, I...
2023-05-01 (first published: 2023-04-24)
774 reads
Tales From The Field Weekly Wrap Up for the Week of 04-17-2023 Jorge, Wrexham AFC, & Guys Night Out
Hello Dear Reader! This past week was one I had been looking forward to for quite some time. A couple of months ago I had started reaching out to...
2023-04-24
59 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)
56 reads
On being a woman and a data professional
This is a list of links, in no particular order, that you should read in no particular order. But read all of the words at the end of these...
2023-04-24
155 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)
813 reads
Monitor SQL replication subscriptions synchronization status
In your current role if you are managing a SQL server replication setup, you are probably well aware that if any of the subscriber is not getting synchronized within...
2023-04-28 (first published: 2023-04-22)
380 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers