Posts Tagged ‘tip’

Tip: Get the list of all DBs in a SQL Server 2008

Posted in General on December 7th, 2010 by Xavier – Be the first to comment

Just a quick tip on how to get the list of all databases in a Microsoft SQL Server 2008:
- Open SQL Server Management Studio
- Select master DB
- Run ‘exec sp_helpdb’

You will get a matrix of all databases created in this server. Of course, you need to have the appropriate permissions.

Google Analytics tip: Don’t count yourself in your traffic, create a filter

Posted in SEO on March 11th, 2009 by Xavier – Be the first to comment

One common mistake a lot of people do is they count themselves as traffic to their own site. Don’t! You may visit your own site hundreds of times a week (in an addicted scenario), but remove yourself by creating a filter in Google Analytics as you want real data and you are moving the average by quite a bit.
Create a filter in google analytics by following this instructions:

http://www.google.com/support/analytics/bin/answer.py?answer=55496

To find out your ip go to http://www.whatismyip.com/