A Fine Slice Of SQL Server
Tomaz Kastrun has fun generating a triangle:
What motivates human behaviour can be captured in the Maslow’s hierarchy of needs (source: Wiki). Maslow and psychologists have articulated these needs in a form of a Pyramid, and ever since the concept had been widely adopted (also criticised), and yet, another adaptation is the Pyramid of R needs
Read on for Tomaz’s take, as well as how to generate such a pyramid.
Comments closedVlad Drumea does a bit of digging:
Back in June I wrote a post about SQL Server 2025’s new PBKDF2 hashing algorithm, in which I’ve mentioned that “I don’t yet have way to build the new PBKDF2 password hash from parts”.
So, almost 5 months later, after some more reading and a decent amount of trial and error, I finally have it.
That is some neat detective work on Vlad’s part.
Comments closedJack Corbett diagnoses a problem:
I was working with a client to do an upgrade/migration from SQL Server 2016 to SQL Server 2022, and this client assigns non-default ports to SQL Server. As part of the process, I had to create a credential on one node and needed it on the other node, so I went to the handy Copy-DBACredential dbatools cmdlet, but it didn’t work.
Read on for the troubleshooting process and the ultimate issue.
Comments closedMeagan Longoria wants to know about visual interactions:
It can be tedious to check what visual interactions have been configured in a Power BI report. If you have a lot of bookmarks, this becomes even more important. If you do this manually, you have to turn on Edit Interactions and select each visual to see what interactions it is emitting to the other visuals on the page.
But there is a better way!
Click through for that better way.
Comments closedAndrew Pruski tries out a new feature:
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieves this is documented here.
Now in SQL Server 2025 we can switch on ADR for tempdb!
Read on to see what benefits you can get.
Comments closed