Daily Coping 14 Feb 2023
Today’s coping tip is to thank someone and tell them how they made a difference for you. I’ve had a lot of success in my life, as well as...
2023-02-14
5 reads
Blog Posts
Speaking at Techorama 2023
I’m excited to announce I’ve been selected again as a speaker for Techorama 2023. Techorama is one of the biggest Microsoft-focused events in the European mainland, and it’s always...
2023-02-14
15 reads
Daily Coping 13 Feb 2023
Today’s coping tip is to show an active interest by asking questions when talking to others. I listen more and more these days. I’m trying to input less and...
2023-02-13
9 reads
Queries Impacting TempDB
The question came up that someone wanted to monitor the queries impacting tempdb using Extended Events. Initially, I was pretty sure that there was no real way to do...
2023-02-13
19 reads
Tales From The Field Weekly Wrap Up for the Week of 02-06-2023
Hello Dear Reader! We had a great last week on Tales from the Field. This weekend was also a really nice one. On Saturday a group of friends gathered...
2023-02-13
21 reads
Tempdb Performance Improvements in SQL Server 2022 are Dramatic
Tempdb is always a topic for me whether it’s in my sessions or blogs I have written. However, I’ve never been so excited about it then I am when...
2023-02-13 (first published: 2023-02-01)
2,779 reads
Daily Coping 10 Feb 2023
Today’s coping tip is to send a message to let someone know you’re thinking of them. I reached out a friend the other day, someone I know from the...
2023-02-10
19 reads
Daily Coping 9 Feb 2023
Today’s coping tip is to write down your hopes or plans for the future. Hopes are vague, and plans are easier, so here are some plans: Plan a trip...
2023-02-09
31 reads
Allow a user to only trigger pipelines in Azure Data Factory
Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to be manually triggered. For example, when the finance department...
2023-02-08 (first published: 2023-01-25)
216 reads
Creating a Flyway Desktop Shadow Database in PostgreSQL
In order to generate migrations, we need to configure Flyway to use a shadow database. This post looks at that process. This is part of a series of working...
2023-02-08 (first published: 2023-02-06)
124 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers