SQLAdmin

Putting the Persisted Version Store (PVS) in its own file group is to improve the performance of SQL Server Accelerated Database Recovery (A...

These questions are relevant your first day on the job as Database Administrator. Also the questions are usefull to look at on a regular bas...

Some notes from a SQL Server 2022 Developer Edition installation on a Windows 11 Pro workstation. The infrastructure is VMware Workstation P...

 Quite often I find it usefull to have a file as parameter to a PowerShell function. And most times I want to make sure the file exists when...

Here are some personal guidelines on writing and using a stored procedure. They are mentioned in a somewhat random order. The list and each ...