Showing posts with label SA Account. Show all posts
Showing posts with label SA Account. Show all posts

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