SQLAdmin

2025 was with way les posts than several prior years. That could partly due to a new focus in my daily job activities such as more abstract ...

For many years AdventureWorks was the primary sample database from Microsoft for SQL Server. But with many new features and new ways to stru...

Sometimes one just has to add new storage to a Windows installation. And in some cases like adding physical storage there are a few simple s...

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...