G’Day, I recently renewed one of my Azure Certifications, extending it by another year from the original expiry data. You can extend any certification that is about to expire...
2022-02-16 (first published: 2022-02-05)
434 reads
Learn about SQL Server key lookup performance and how to improve the performance of key lookup queries.
2022-02-16
250 reads
When a database gets corrupted or failure occurs, before restoring the database from the backups you've created, it is recommended to create a tail-log backup of the records that...
2022-02-16 (first published: 2022-02-07)
890 reads
No doubt there will be a need for you to split off your analytical queries from the main database for performance reasons. If you have been following me in...
2022-02-15
28 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-15
18 reads
For those of you that need to setup Kerberos constrained delegation for Group Managed Service Accounts, you will likely get more familiar with msDS-AllowedToDelegateTo. This attribute stores a list...
2022-02-15
284 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-14
15 reads
I recently got an update from the SQL Monitor PM on the progress we’ve made across all the teams. We have a number focusing on different aspects of the...
2022-02-14
36 reads
I recently wrote an article about PostgreSQL restores (and by extension, backups) over on Simple-Talk. The restore process within PostgreSQL, without 3rd party involvement, can be a little tricky....
2022-02-14 (first published: 2022-02-03)
127 reads
Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here.
2022-02-14 (first published: 2022-02-01)
648 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers