Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may...

Denali – Blog a Day Series : May, 2012

Denali

 
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is...

More IMPORTANT miscellaneous info

 
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.

Okay,...

Restore fails with tail of log error

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...

Command Prompt connectivity –U option

When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...

High Availability 9's

This is very important to understand what is high availability 9's, This is a measurement of high availability  where you can tell...

Desktop Edition Sql server 2000 MSDE Install upgrade

for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition...

Dynamic Add/Remove file in Mirroring/Logshipping

Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...

Find Login in Active Directory

Find Login in AD

Many times we require to know if particular login is a part of ad user group. Or...