The 10 best IT certifications

MCITP Microsoft Certified IT Professional credential
Track:

1. Database developer,
2. Database administrator,
3. Enterprise messaging administrator, and
4. Server administrator

MCTS - Microsoft Certified Technology Specialist
Track:

1. SQL Server 2008 Business Intelligence
2. SQL Server 2008 Database Development
3. SQL Server 2008 Implementation and Maintenance

Security+ - CompTIA’s Security+
MCPD - Microsoft Certified Professional Developer
Track:

1. Windows Developer 3.5
2. ASP.NET Developer 3.5 and
3. Enterprise Applications Developer 3.5

CCNA - Cisco Certified Network Associate
A+ - CompTIA’s A+
PMP - Project Management Professional
MCSE/MCSA - Microsoft Certified Systems Engineer/Microsoft Certified Systems Administrator
CISSP - Certified Information Systems Security Professional
LINUX+

Integrate Google Task into Gmail

Google just rolled out functionality that can able to add task gadgets into your Gmail.
Settings --> Labs --> Enable (Select Google task) Option

The New OS from Microsoft - Windows Vienna

Run Query on Two Different Database on Two Different Servers

A linked server configuration allows Microsoft SQL Server to execute commands against OLE DB data sources on different servers. Linked servers offer these advantages:

• Remote server access.
• The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
• The ability to address diverse data sources similarly.

Managing a Linked Server Definition

Register the connection information and data source information with SQL Server.

You can create or delete a linked server definition with stored procedures or through SQL Server Enterprise Manager.

With Stored Procedure:

Create a linked server definition using sp_addlinkedserver.
Syntax
sp_addlinkedserver [ @server = ] 'server'
[ , [ @srvproduct = ] 'product_name' ]
[ , [ @provider = ] 'provider_name' ]
[ , [ @datasrc = ] 'data_source' ]
[ , [ @location = ] 'location' ]
[ , [ @provstr = ] 'provider_string' ]
[ , [ @catalog = ] 'catalog' ]
Example
EXEC sp_addlinkedserver
@server = 'SEATTLE Mktg',
@srvproduct = 'OLE DB Provider for Jet',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'

Delete a linked server definition using sp_dropserver.
Syntax
sp_dropserver [ @server = ] 'server'
[ , [ @droplogins = ] { 'droplogins' | NULL} ]
Examples
sp_dropserver ‘SEATTLE Mktg', 'droplogins'

With SQL Server Enterprise Manager:

• SQL Server Enterprise Manager Console -- Server objects -- Linked Servers
• Right Click -- New Linked Server
• Define the name, provider properties, server options, and security options for the linked server.
• Edit a linked server definition by right-clicking the linked server and clicking Properties.
• Delete a linked server definition by right-clicking the linked server and clicking Delete.

When executing a distributed query against a linked server, include a fully qualified, four-part table name for each data source to query.

This four-part name should be in the form linked_server_name.catalog.schema.object_name.

Select * From [linkedservername or IP].DatabaseName.sys.Columns

Pseudo Validator for a Pseudo Standard

Web 2.0 validator tool:
http://web2.0validator.com/

Web 2.0 Technology

Semantic web is an evolving extension of World Wide Web Consortium and It’s Director Tim Berner’s Lee founded in the year 1989.

Web 2.0 concepts have led to the development and evolution of web culture communities and hosted services, such as social-networking sites, video sharing sites, wikis, blogs, and folksonomies.

O'Reilly and John Battelle they frame the themes of Web 2.0.

Four levels in the hierarchy of Web 2.0 sites:

1. Level-3 applications, the most "Web 2.0"-oriented, exist only on the Internet. Examples: eBay, Craigslist, Wikipedia, del.icio.us, Skype, dodgeball, and AdSense.
2. Level-2 applications can operate offline but gain advantages from going online. Examples: Flickr.
3. Level-1 applications operate offline but gain features online. Examples: Google Docs & Spreadsheets and iTunes.
4. Level-0 applications work as well offline as online. Examples: MapQuest, Yahoo! Local, and Google Maps.

Web 2.0 websites typically include some of the following features/techniques

1. Rich-Internet application: Techniques to improve the user-experience in browser-based application such as AJAX, Adobe Flash, Flex, Java, Silverlight, Curl etc.
2. Server-Side software: Dynamic content management system by using much more robust database and workflow support.
3. Client-side software: Reduce server workloads and to increase responsiveness of the application by using scripting language such as JavaScript/AJAX, Flash, Curl Applets or Java Applets.
4. XML and RSS
5. Specialized protocols such as FOAF and XFN (both for social networking)
6. Web APIs which allow web-based access to data and functions: REST and SOAP
7. Search: Easily find the information in the site by specifying the keyword which makes the platform valuable.
8. Links: guides to important pieces of information. The best pages are the most frequently linked to.
9. Authoring: Able to post content by different users. While in blogs is increasing that posts and comments of individuals are accumulated over time.
10. Tags: categorize content by creating tags (one-word description) increase facilitate of searching.
11. Extensions: Automation some of the work and pattern matching by using algorithms e.g. amazon.com recommendations.
12. Signals: Notify users frequently about the changes that are made to the site by sending mails to them in the format of RSS (Really Simple Syndication) technology.

Current World Internet Usage and Population Statistics

Encoded file filename.php expired or corrupt error.

SYMPTOMS
The encoded file filename.php has expired or is corrupt.

SOLUTION
This happens when one of the ionCube encoded files have not been uploaded in binary mode or have been tampered with.

The files are encoded on the fly when you click on the download button and your user information is written to the comments of the php file so is a file checksum, if the file is edited or tampered with in any way it becomes corrupt, same with uploading it in ASCII mode, it changes checksums because of the difference in uploading.

The resolution would be to try uploading the file again in binary mode, if that does not work I would suggest re-downloading the entire system from our members area and re-uploading it in binary mode.

Types of Encode/Decode in PHP

You can encode or decode PHP file by using

1. Zend Encoder,
2. Zend SafeGuard,
3. IonCube,
4. PhpCipher,
5. Codelock,
6. Truebug,
7. Sourcecop,
8. Byterun,
9. ElearningForce,
10. PHPLockit,
11. Zorex Cryptz,
12. PHPion.

XAMPP Apache port change

Find httpd.conf file in the folder path
apache --> conf --> httpd.conf

Open httpd.conf file in your text editor.

Find this line:
Listen 80

change it to:
Listen 8080

Save and restart Apache.

http://locahost:8080 would now be your XAMPP default pages.