Browsing articles in "Tips & Tricks"
Nov
6
2012

How to: create Filter on Undelivered Emails in MS Outlook

If you are frustrated with others not keeping their mailbox clean and you are landing up with 10’s to 100’s of undelivered mail notifications landing up directly to your inbox, then don’t worry this post may be useful for you to some extent 🙂 Note: this is not a tool tip, but usage of a very well-known feature of outlook i.e. Rules Here is a short, simple and clean method to create a filter i.e. […]

Nov
1
2012

Fix Msvcp71.dll And Msvcr71.dll Missing Error In Windows 7

My BMC client tool was not working and giving one of dll missing error, so I fixed it by following, Follow link: http://www.addictivetips.com/windows-tips/fix-msvcp71-dll-and-msvcr71-dll-missing-error-in-windows-7/ Download dll files from the Mirror 1 link given in above link It fixed the said issue for me, it’s tried and tested! so no harmful affect. Hope it helps!

Oct
19
2012

How to: Check full source of email sender in Outlook 2010

You might be wondering that in Microsoft Outlook 2010 where we can find the source of message sender, please find the simple tip below to understand how this can be done. Note: For those who are wondering what is source, it is a way to identify the ip address of sender and this is one way the junk/spam mails are detected, you can read more about it on internet. 1. Within Outlook 2010, open an […]

Jul
2
2012

Configure SQL Mail on SQL Server 2000 with Outlook 2007 client

Scenario is, we have SQL 2000 as database engine and outlook 2007 as mail client, now as we know SQL 2000 requires MAPI client for SQL mail configuration and from records we need minimum Outlook 2000 client, in this case we have outlook 2007 client present. I was skeptical initially that whether SQL mail will at all work with outlook 2007 or not, by going through several articles and forums, I found it to be […]

Jun
29
2012

Changing SQL Server Collation / Rebuilding system databases

You may find yourself in situation where you need to change Server level collation or need to rebuild system databases, then following article will be helpful, 1. First detach all user databases 2. Script any logins (if exists) using sp_help_revlogin (get one from MSDN for e.g. http://support.microsoft.com/kb/246133 , http://support.microsoft.com/kb/918992 3. Script Maintenance plans/Jobs (if can’t be created again) 4. Execute following on command line by going to the folder where appropriate setup of SQL Server […]

Jun
7
2012

SQL 2005/2008/R2 N/W connection error troubleshooting steps

You may see 1001 n/w connection error when trying to connect remote sql server from ssms, I have compiled some best troubleshooting steps I am aware and few collected from various references,   First try to use one of five ways to connect SQL Server using SSMS, (for e.g. let’s say server name is ngmssql and instance name is sql001 and domain is ad.in.com and port is 1433 and ip address is 10.26.27.28)   • […]

Apr
17
2012

Command Line utility “sc” to manage windows services

If you have been working with Windows then you are aware of command line utility which can be run by going to RUN > type “cmd” and a black window open’s up, now you can do several activities using command lines, let’s take example of managing services. Microsoft provided a GUI for same as well which will open-up by typing “services.msc” in RUN window. Managing services using command line is simple and efficient as you […]

Mar
14
2012

Managing and Optimizing Tempdb in SQL Server

We often come across situations where there is contention in tempdb or tempdb is getting oversized, etc. better planning of tempdb may avoid performance issues if it is being used heavily and also reduce administration effort, below article is basically focussed on the planning stage of tempdb to reduce administration effort and avoid performance issues, Source: http://support.microsoft.com/kb/328551, http://www.sqllion.com/2009/05/optimizing-tempdb-in-sql-server-2005/ Tempdb is one of the system database in SQL Server, all user data is lost from tempdb […]

Feb
12
2012

How to do FTP in binary mode

1. Go to server 2. open command prompt as Start > Run > cmd 3. type ftp and enter 4. type open and give ftp address (for e.g. xxx.abcd.com) 5. it will ask you for user name and password (give as provided by ftp providor) 6. Now type binary and enter 7. It will show that it is now in binary mode 8. Now type put and enter 9. ftp should complete 10. Do not […]

Jan
25
2012

Working with bit locker in Windows Vista/7

Today my hard drive went corrupt, when I tried to attach it via external HD case then it asked for bit locker key, so after search I found that starting with Windows Vista MS has built-in drive encryption feature called bitlocker, now to identify key I did following, Source: BitLocker Drives Unlocker [AddictiveTips Apps] If you use BitLocker Drive Encryption to encrypt and secure multiple local drives in Windows 7, you will be frustrated by […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 254 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2020
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

View Post by Categories

%d bloggers like this: