T SQL Date format convert function

In this post I will show you how to overwrite sql server backup file rather than append (default action is append to backup media set) If you try below t-sql command to take full sql server database backup then you …

How to overwrite SQL Server Backup rather than Append Mediaset Read more »

T SQL Date format convert function

Recently I had an interesting situation. Consider below situation You want to connect to sql server as sysadmin but you are not added to sql server logins using windows authentication BUILTIN\Administrators group has been removed from SQL Server You have …

How to login to sql server after all admin accounts removed and you are locked Read more »