Wednesday, 18 November 2015

Reset Forgotten SA Password

The following article explains how to grant SYSADMIN rights to a user, when you may not have ANY SYSADMIN access at all (e.g. forgetting the SA password, and not having any other sysadmin accounts):

https://technet.microsoft.com/en-us/magazine/jj853293.aspx

Updating massive amount of rows whilst avoiding blocking

The following SQL is a good means to split an update on a massive table into smaller chunks, whilst reducing blocking. The method is to upda...