SQLAdmin

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

In a SQL Errorlog we saw a lot of events like this. Buffer Pool scan took 10 seconds: database ID 6, command 'CHECKPOINT', operatio...

Hard disk s with spinning platters are going away very fast. During easter cleanup in my workshop I found a old 750 GB hard disk, and decide...

I have made this simple template to start a new PowerShell script file with a advanced function. It helps me to get the basics right from th...