For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple question: What do you think about PostgreSQL events? Prior to this year, I’d never attended...
2023-12-01
47 reads
A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...
2023-11-24 (first published: 2023-11-13)
230 reads
Once more, my apologies for being late on getting the T-SQL Tuesday announcement out. I have no excuse. However, our extended event on Extended Events (yes, I’m the third...
2023-09-15
17 reads
With 165 T-SQL Tuesday events, two, just two, this one, T-SQL Tuesday #166, and another one back in 2018 or 2019 (I forget and I’m far too lazy to...
2023-09-14
10 reads
When I was put on the list to host September’s T-SQL Tuesday, well, I forgot to put it in my calendar. So I’m late (and in the doghouse with...
2023-09-11
30 reads
As data professionals, of any stripe, we should, as much as we can, where we can, base our decisions on data. After all, in theory anyway, we’re the experts...
2023-09-18 (first published: 2023-08-23)
212 reads
I recently presented a session on the Query Store at Data Saturday Rhineland and the question came up: If there’s already a query hint on a query, what happens...
2023-07-10 (first published: 2023-06-26)
270 reads
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty simple, database change management. Now, I may have, once or twice, spoken about database change...
2023-06-02
12 reads
I’ve had people come up to me and say “PostgreSQL is open source and therefore license free. Why on earth would I put PostgreSQL in Azure?” Honestly, I think...
2023-05-17 (first published: 2023-05-08)
230 reads
I’ve been seeing more and more noise about how ChatGPT can help with technical stuff, writing code, all that. Well, I wanted to know how best to set up...
2023-04-21 (first published: 2023-04-10)
797 reads
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Comments posted to this topic are about the item Crazy Interviews
Comments posted to this topic are about the item The Query Traceflag
Comments posted to this topic are about the item Using Machine Learning Pipeline Execution...