SQLAdmin

Investigating a memory leak we have to get a full memory dump under certain conditions. Setting the Windows pagefile is descriped in the pos...

When troubleshooting memory issues it sometimes is necessary to change the Windows pagefile to something different that the default settings...

To play around with some obscrure naming possibilities in SQL Server I create the star-database. The name has nothing to do with the data wa...

2024 was a year with fewer posts than planned - again. As each post is like a personal refined note on a specific situation this signals tha...

Some days ago I was asked - politely - to move some databases between two SQL Server installations. Unfortunately the service had failed on ...