Home › SQL Server › Archive for DBA

Category: DBA

By Posted on Posted in DBA, SQL Server, T-SQL Tips Tagged with , ,
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 »

By Posted on Posted in DBA, SQL Server Tagged with ,
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 »

By Posted on Posted in Business Intelligence, DBA, SSAS Tagged with , ,

I was trying to deploy my AdventureWorksDW2012 Cube Sample  and got interesting error as below OLE DB error: OLE DB or ODBC error: Login failed for user ‘MYDOMAIN\MYSERVER$’.; 28000 If you receive above error most likely your SSAS Instance running …

SSAS Cube Deploy/Processing Error – OLE DB or ODBC error: Login failed for user ‘[MyServer1\user1$]’.; 28000 Read more »