A new way of getting help online

Here is A new way of getting help online and that is Wizpert. Wizpert is an online community of experts available to help people to resolve their issues there and then.

Things are changing and now people don’t have time to post an issue to a blog or forum and wait to get an answer. Now people can go to Wizpert and immediately talk to an expert to get the problem resolution.

Currently Wizpert is in beta phase and people can get free help from Wizperts. Later in future people will have to pay a little in order to get their problem resolved.

So lets talk about how to get help.

1. Go to the Wizpert URL, You will see the screen below if you are not a member, right now the membership is invite based. You can get an invite by providing your email address.

home

2. If you are a member then the below screen will be displayed to you

Select Wizpert

 

3. You have to select the category in which you are facing an issue and want to get it resolved.

After drilling down to the specific category you can select the best suitable Wizpert and chat with him.

Select Wizpert

4. Also the system will also show you the list of online Wizperts as well as offline Wizperts but you can only chose the one who is online.

Talk to a Wizpert

5. And this point is specifically for all the Wizperts, if you would like to place a Wizpert button on your blog directly in order to get people’s request. Just follow the steps described in the “Marketing” tab of your account “Settings” page. You will be able to place a button like shown below.

Blog Button

6. Last but not least, Wizperts can manage their profile/account information through the options described in below image.Wizpert Settings

So start using Wizpert and explore a new and exciting way of communication….

 

List of retired Microsoft Exams

Following is a huge List of retired Microsoft Exams …. :).

If you would like to see a list of retired Microsoft Certifications, please Click Here
If you would like to see a list of Top 5 IT certifications for 2013, please Click Here

The list is explained in the format of
Exam number
Exam title-Date retired.

70-086
Implementing and Supporting Microsoft Systems Management Server 2.0-2008

70-089
Designing, Implementing, and Managing Microsoft Systems Management Server 2003-October 31, 2010

70-123
Planning, Implementing, and Maintaining a Software Asset Management (SAM) Program-October 31, 2010

70-162
TS: Forefront Protection for EndPoint and Server, Configuring-July 31, 2012

70-210
Installing, Configuring, and Administering Microsoft Windows 2000 Professional-2008

70-214
Implementing and Administering Security in a Microsoft Windows 2000 Network-2008

70-215-Installing, Configuring, and Administering Microsoft Windows 2000 Server-2008

70-216-Implementing and Administering a Microsoft Windows 2000 Network Infrastructure-2008

70-217-Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure-2008

70-218
Managing a Microsoft Windows 2000 Network Environment-2008

70-219
Designing a Microsoft Windows 2000 Directory Services Infrastructure-2008

70-220
Designing Security for a Microsoft Windows 2000 Network-2008

70-221
Designing a Microsoft Windows 2000 Network Infrastructure-2008

70-222
Migrating from Microsoft Windows NT 4.0 to Microsoft Windows 2000-2008

70-223

Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server-2008

70-224
Installing, Configuring, and Administering Microsoft Exchange 2000 Server-2008

70-225
Designing and Deploying a Messaging Infrastructure with Microsoft Exchange 2000 Server-2008

70-226
Designing Highly Available Web Solutions with Microsoft Windows 2000 Server Technologies-2008

70-227
Installing, Configuring, and Administering Microsoft Internet Security and Acceleration (ISA) Server 2000, Enterprise Edition-2008

70-228
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition-March 31, 2009

70-229
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition-March 31, 2009

70-230
Designing and Implementing Solutions with Microsoft BizTalk Server 2000, Enterprise Edition-2008

70-232
Implementing and Maintaining Highly Available Web Solutions with Microsoft Windows 2000 Server Technologies and Microsoft Application Center 2000-2008

70-234
Designing and Implementing Solutions with Microsoft Commerce Server 2000-2008

70-235
TS: Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2006-June 30, 2011

70-241
TS: Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2006 R2-June 30, 2011

70-244
Supporting and Maintaining a Microsoft Windows NT Server 4.0 Network-2008

70-262
Microsoft Office Live Communications Server 2005 – Implementing, Managing, and Troubleshooting-October 31, 2010

70-271
Supporting Users and Troubleshooting a Microsoft Windows XP Operating System-June 30, 2011

70-272
Supporting Users and Troubleshooting Desktop Applications on a Microsoft Windows XP Operating System-June 30, 2011

70-281
Planning, Deploying, and Managing an Enterprise Project Management Solutions-October 31, 2010

70-282
Planning, Deploying, and Managing a Network Solution for the Small and Medium-Sized Business-September 30, 2011

70-284
Implementing and Managing Microsoft Exchange Server 2003-March 31, 2011

70-285
Designing a Microsoft Exchange Server 2003 Organization-March 31, 2011

70-292
Managing and Maintaining a Windows Server 2003 Environment for an MCSA Certified on Windows 2000-2008

70-296
Planning, Implementing, and Maintaining a Windows Server 2003 Environment for an MCSE Certified on Windows 2000-2008

70-300
Analyzing Requirements and Defining Microsoft .NET Solution Architectures-March 31, 2009

70-301
Managing, Organizing, and Delivering IT Projects by Using Microsoft Solutions Framework 3.0-March 31, 2009

70-305
Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET-March 31, 2009

70-306
Developing and Implementing Windows-Based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET-March 31, 2009

70-310
Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework-March 31, 2009

70-315
Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET-March 31, 2009

70-316
Developing and Implementing Windows-Based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET-March 31, 2009

70-320
Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework-March 31, 2009

70-330
Implementing Security for Applications with Microsoft Visual Basic .NET-March 31, 2009

70-340
Implementing Security for Applications with Microsoft Visual C# .NET-March 31, 2009

70-350
Implementing Microsoft Internet Security and Acceleration (ISA) Server 2004-October 31, 2010

70-351
TS: Microsoft Internet Security and Acceleration Server 2006, Configuring-March 31, 2011

70-403
TS: System Center Virtual Machine Manager 2008, Configuring-September 30, 2011

70-431
TS: Microsoft SQL Server 2005 ‒ Implementation and Maintenance-June 30, 2011

70-441
PRO: Designing Database Solutions by Using Microsoft SQL Server 2005-June 30, 2011

70-442
PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005-June 30, 2011

70-443
PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005-June 30, 2011

70-444
PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005-June 30, 2011

70-445
TS: Microsoft SQL Server 2005, Business Intelligence ‒ Development and Maintenance-June 30, 2011

70-446
PRO: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2005-June 30, 2011

70-447
UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005-June 30, 2011

70-453
Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008-July 31, 2012

70-454
Upgrade: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD-July 31, 2012

70-455
Upgrade: Transition Your MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI Developer-July 31, 2012

70-500
TS: Microsoft Windows Mobile 5.0, Implementing and Managing-March 31, 2011

70-501
TS: Windows Server 2003 Hosted Environments, Configuration and Management-October 31, 2010

70-510
TS: Visual Studio 2005 Team Foundation Server-March 31, 2011

70-526
TS: Microsoft .NET Framework 2.0 – Windows-Based Client Development-June 30, 2011

70-528
TS: Microsoft .NET Framework 2.0 – Web-Based Client Development-June 30, 2011

70-529
TS: Microsoft .NET Framework 2.0 – Distributed Application Development-June 30, 2011

70-540
TS: Microsoft Windows Mobile 5.0 – Application Development-March 31, 2011

70-541
TS: Microsoft Windows SharePoint Services 3.0 – Application Development-June 30, 2011

70-543
TS: Visual Studio 2005 Tools for Office-March 31, 2011

70-444 and 74-544
TS: Bing Maps Platform, Application Development-December 31, 2011

70-547
PRO: Designing and Developing Web-Based Applications by Using the Microsoft .NET Framework-June 30, 2011

70-548
PRO: Designing and Developing Windows-Based Applications by Using the Microsoft .NET Framework-June 30, 2011

70-549
PRO: Designing and Developing Enterprise Applications by Using the Microsoft .NET Framework-June 30, 2011

70-551
UPGRADE: MCAD Skills to MCPD Web Developer by Using the Microsoft .NET Framework-June 30, 2011

70-552
UPGRADE: MCAD Skills to MCPD Windows Developer by Using the Microsoft .NET Framework-June 30, 2011

70-553
UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 1-June 30, 2011

70-554
UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 1-June 30, 2011

70-555
TS: Microsoft Office Groove 2007, Configuring-June 30, 2011

70-556
TS: Microsoft Office PerformancePoint Server 2007, Applications-June 30, 2011

70-557
TS: Microsoft Forefront Client and Server, Configuring-June 30, 2011

70-558
UPGRADE: MCAD Skills to MCTS Windows Applications by Using the Microsoft .NET Framework-June 30, 2011

70-559
UPGRADE: MCAD Skills to MCTS Web Applications by Using the Microsoft .NET Framework-June 30, 2011

70-566
UPGRADE: Transition your MCPD Windows Developer Skills to MCPD Windows Developer 3.5-July 31, 2012

70-567
UPGRADE: Transition your MCPD Web Developer Skills to MCPD ASP.NET Developer 3.5-July 31, 2012

70-568
UPGRADE: Transition your MCPD Enterprise Application Developer Skills to MCPD Enterprise Application Developer 3.5, Part 1-July 31, 2012

70-569
UPGRADE: Transition your MCPD Enterprise Application Developer Skills to MCPD Enterprise Application Developer 3.5, Part 2-July 31, 2012

70-579
TS: Windows Mobile 6.5, Configuring-December 31, 2011

70-580
TS: Windows Mobile 6.5, Application Development-December 31, 2011

70-621
PRO: Upgrading Your MCDST Certification to MCITP Enterprise Support-March 31, 2011

70-624
TS: Deploying and Maintaining Windows Vista Client and 2007 Microsoft Office System Desktops-October 31, 2010

70-625
Connected Home Integrator-July 31, 2012

70-626
Consumer Sales Specialist-June 30, 2011

70-631
TS: Microsoft Windows SharePoint Services 3.0, Configuring-March 31, 2011

70-652
TS: Windows Server Virtualization, Configuring-September 30, 2011

70-653
Windows Small Business Server 2008, Configuring-July 31, 2012

70-654
TS: Windows Essential Business Server 2008, Configuring-June 30, 2011

70-655
TS: Windows Vista and Server Operating Systems, Pre-Installing for OEMs-June 30, 2011

74-131
Designing a Microsoft Office Enterprise Project Management (EPM) Solution-October 31, 2010

74-132
Deploying a Portal Solution with Microsoft SharePoint Products and Technologies-October 31, 2010

74-133
Customizing Portal Solutions with Microsoft SharePoint Products and Technologies-October 31, 2010

74-134
Pre-Installing Microsoft Products and Technologies-October 31, 2010

74-135
Developing E-Business Solutions Using Microsoft BizTalk Server 2004-October 31, 2010

74-137
Developing Microsoft Office Solutions Using XML with Office Professional Edition 2003-October 31, 2010

74-138
Planning and Building a Messaging and Collaboration Environment using Microsoft Office System and Microsoft Windows Server 2003-October 31, 2010

74-139
Deploying Business Desktops with Microsoft Windows Server 2003 and Microsoft Office 2003-October 31, 2010

74-404
Microsoft Office Communications Server 2007 R2 – U.C. Voice Specialization-May 31, 2012

74-675
Microsoft Response Point, Configuring-June 30, 2011

74-676
TS: Fast Enterprise Search Platform, Developing-July 31, 2012

74-924
Microsoft Office Communications Server 2007 R2 – U.C. Voice Specialization-October 31, 2010

78-702
Designing and Managing a Microsoft Business Intelligence Solution-September 30, 2011

MB2-421
CRM 3.0 Installation & Configuration-April 12, 2011

MB2-422
CRM 3.0 Customization-April 12, 2011

MB2-423
CRM 3.0 Applications-April 12, 2011

MB2-498
CRM 3.0 Extending Microsoft Dynamics-April 12, 2011

MB3-408
Microsoft Dynamics GP 9.0 Inventory and Order Processing-January 11, 2011

MB3-409
Microsoft Dynamics GP 9.0 Financials-January 11, 2011

MB3-412
Microsoft Dynamics GP 9.0 Installation and Configuration-January 11, 2011

MB3-413
Microsoft Dynamics GP 9.0 Project Series-January 11, 2011

MB3-430
Microsoft Dynamics GP 9.0 Manufacturing Applications-January 11, 2011

MB3-451
Microsoft Dynamics GP 9.0 Report Writer-January 11, 2011

MB3-461
Microsoft Dynamics GP 9.0 Modifier with VBA-January 11, 2011

MB3-462
Microsoft Dynamics GP 9.0 Integration Manager-January 11, 2011

MB3-465Microsoft Dynamics GP 9.0 Field Service Implementation-January 11, 2011

MB4-348
SL 6.5 Financials-March 31, 2011

MB4-349
SL 6.5 Installation & Configuration-March 31, 2011

MB5-294
FRx 6.7 Reporting Design-August 5, 2011

MB5-554
Small Business Financials 9.0-June 22, 2012

MB6-202
Axapta 3.0 Programming-January 12, 2010

MB6-203
Axapta 3.0 Financials-January 12, 2010

MB6-204
Axapta 3.0 Trade and Logistics-January 12, 2010

MB6-205
Axapta 3.0 Production-January 12, 2010

MB6-206
Axapta 3.0 Installation and Configuration-January 12, 2010

MB6-282
Axapta 3.0 HRM-January 12, 2010

MB6-283
Axapta 3.0 Questionnaire-January 12, 2010

MB6-284
Axapta 3.0 Projects-2010

MB6-285
Axapta 3.0 Sales and Marketing-December 31, 2011

MB6-288
Axapta 3.0 Product Builder-January 12, 2010

MB6-291
Axapta 3.0 Shop Floor Control-December 31, 2011

MB6-295
Axapta 3.0 Enterprise Portal Development-January 12, 2010

MB6-502
AX 4.0 Product Builder-September 30, 2011

MB6-503
AX 4.0 Installation and Configuration-September 30, 2011

MB6-504
AX 4.0 Project Series-September 30, 2011

MB6-506
AX 4.0 Questionnaire-September 30, 2011

MB6-507
AX 4.0 Financials-September 30, 2011

MB6-508
AX 4.0 Development Introduction-September 30, 2011

MB6-509
AX 4.0 Trade and Logistics-September 30, 2011

MB6-510
AX 4.0 Human Resource Management-September 30, 2011

MB6-511
AX 4.0 Production-September 30, 2011

MB6-512
AX 4.0 Enterprise Portal Development-September 30, 2011

MB6-513
AX 4.0 MorphX Solution Development-September 30, 2011

MB6-827
AX 2009 Payroll-June 3, 2011

MB7-221
Navision 4.0 C/SIDE Introduction-January 12, 2010

MB7-222
NAV 4.0 C/SIDE Solution Development-January 12, 2010

MB7-223
Navision 4.0 Warehouse Management-January 12, 2010

MB7-224
Navision 4.0 Manufacturing-January 12, 2010

MB7-225
Navision 4.0 Financials-January 12, 2010

MB7-226
Navision 4.0 Installation and Configuration-January 12, 2010

MB7-227
Navision 4.0 Trade and Inventory-January 12, 2010

MB7-231
Navision 4.0 Relationship Management-January 12, 2010

MB7-232
Navision 4.0 Service Management-January 12, 2010

MB7-233
Navision 4.0 Costing-January 12, 2010

MB7-514
Microsoft Dynamics NAV 5.0 C/SIDE Introduction-November 30, 2012

MB7-515
Microsoft Dynamics NAV 5.0 Financials-November 30, 2012

MB7-516
Microsoft Dynamics NAV 5.0 C/SIDE Solution Development-November 30, 2012

MB7-517

Microsoft Dynamics NAV 5.0 Installation and Configuration-November 30, 2012

70-236
TS: Exchange Server 2007, Configuring

70-237
Pro: Designing Messaging Solutions with Microsoft Exchange Server 2007

70-238
Pro: Deploying Messaging Solutions with Microsoft Exchange Server 2007

70-638
TS: Microsoft Office Communications Server 2007, Configuring

70-632
TS: Microsoft Office Project 2007, Managing Projects

70-633
TS: Microsoft Office Project Server 2007, Managing Projects

70-634
Pro: Microsoft Office Project Server 2007, Managing Projects and Programs

70-639
TS: Microsoft Office Project Server 2007, Configuring

70-542
TS: Microsoft Office SharePoint Server 2007 – Application Development

70-630
TS: Microsoft Office SharePoint Server 2007, Configuring

Continue reading

List of retired Microsoft certifications

images

Have a look at the List of retired Microsoft certifications which have been retired over the last five years.
If you would like to see a list of retired Microsoft Exams, please Click Here
If you would like to see a list of Top 5 IT certifications for 2013, please Click Here

1. Microsoft Dynamics

-Applications for Microsoft Dynamics CRM
-Applications for Microsoft Dynamics GP 10.0
-Microsoft Business Solutions Axapta 3.0 Financials
-Microsoft Business Solutions Axapta 3.0 HRM1
-Microsoft Business Solutions Axapta 3.0 Installation and Configuration
-Microsoft Business Solutions Axapta 3.0 Product Builder
-Microsoft Business Solutions Axapta 3.0 Production
-Microsoft Business Solutions Axapta 3.0 Programming
-Microsoft Business Solutions Axapta 3.0 Questionnaire
-Microsoft Business Solutions Axapta 3.0 Shop Floor Control
-Microsoft Business Solutions Axapta 3.0 Trade and Logistics
-Microsoft Dynamics AX 2009 Payroll
-Microsoft Dynamics AX 4.0 Development Introduction
-Microsoft Dynamics AX 4.0 Enterprise Portal Development
-Microsoft Dynamics AX 4.0 Financials
-Microsoft Dynamics AX 4.0 Human Resource Management
-Microsoft Dynamics AX 4.0 Installation and Configuration
-Microsoft Dynamics AX 4.0 MorphX Solution Development
-Microsoft Dynamics AX 4.0 Product Builder
-Microsoft Dynamics AX 4.0 Production
-Microsoft Dynamics AX 4.0 Project Series
-Microsoft Dynamics AX 4.0 Questionnaire
-Microsoft Dynamics AX 4.0 Trade and Logistics
-Microsoft Dynamics CRM 3.0 Applications
-Microsoft Dynamics CRM 3.0 Customization
-Microsoft Dynamics CRM 3.0 Extending Microsoft Dynamics
-Microsoft Dynamics CRM 3.0 Installation and Configuration
-Microsoft Dynamics GP 9.0 Field Service Implementation
-Microsoft Dynamics GP 9.0 Financials
-Microsoft Dynamics GP 9.0 Installation and Configuration
-Microsoft Dynamics GP 9.0 Integration Manager
-Microsoft Dynamics GP 9.0 Inventory and Order Processing
-Microsoft Dynamics GP 9.0 Manufacturing Applications
-Microsoft Dynamics GP 9.0 Modifier with VBA
-Microsoft Dynamics GP 9.0 Project Series
-Microsoft Dynamics GP 9.0 Report Writer
-Microsoft Dynamics Navision 4.0 C/SIDE Introduction
-Microsoft Dynamics Navision 4.0 C/SIDE Solution Development
-Microsoft Dynamics Navision 4.0 Costing
-Microsoft Dynamics Navision 4.0 Financials
-Microsoft Dynamics Navision 4.0 Installation and Configuration
-Microsoft Dynamics Navision 4.0 Manufacturing
-Microsoft Dynamics Navision 4.0 Relationship Management
-Microsoft Dynamics Navision 4.0 Service Management
-Microsoft Dynamics Navision 4.0 Trade and Inventory
-Microsoft Dynamics Navision 4.0 Warehouse Management
-Microsoft Dynamics SL 6.5 Financials
-Microsoft Dynamics SL 6.5 Installation and Configuration
-Microsoft FRx Reporting Design
-Microsoft Exchange Server

2. Microsoft Exchange Server

-Windows Server 2003, Messaging and Collaboration

3. Microsoft Office Communication Server

-MCTS: Microsoft Office Live Communications Server 2005
-Office Communications Server 2007 – U.C. Voice

4. Microsoft Office

-MCTS: Office 2003, XML
-MCTS: Office Groove 2007, Configuration
-MCTS: Office PerformancePoint Server 2007, Applications
-Microsoft Office Master: Microsoft Office 2007
-Microsoft Certified Application Specialist Instructor

5. Microsoft Project and Project Server

-MCTS: Office Project Server 2003, Business Planning Design Toolkit

6. Microsoft Sharepoint and Sharepoint Server

-MCTS: SharePoint Portal Server 2003, Custom Applications
-MCTS: SharePoint Portal Server 2003, Infrastructure
-MCTS: Microsoft Windows SharePoint Services 3.0, Application Development
-MCTS: Microsoft Windows SharePoint Services 3.0, Configuration
-Microsoft Office SharePoint Server, Business Intelligence

7. Microsoft SQL Server

-Microsoft Certified Database Administrator – SQL Server 2000
-MCITP: Database Developer on SQL Server 2005
-MCITP: Database Administrator on SQL Server 2005
-MCITP: Business Intelligence Developer on SQL Server 2005
-MCTS: SQL Server 2005
-MCTS: Microsoft SQL Server 2005, Business Intelligence Development

8. Microsoft System Center

-MCTS: System Center Virtual Machine Manager 2008, Configuration

9. Visual Studio

-Microsoft Certified Application Developer
-Microsoft Certified Solution Developer .NET
-MCPD: Web Developer
-MCPD: Windows Developer
-MCPD: Enterprise Application Developer
-MCTS: .Net Framework 2.0, Windows Applications
-MCTS: .Net Framework 2.0, Web Applications
-MCTS: Visual Studio 2005 Team Foundation Server
-MCTS: Visual Studio 2005 Tools for the Microsoft Office System

10. Windows Client

-MCTS: Windows OEM Pre-installation Kit Tools
-MCTS: Business Desktop Deployment Solution Accelerator 2.0
-MCTS: Business Desktop Deployment
-MCTS: Windows Vista and Server Operating Systems, Pre-installation
-MCDST: Desktop Support Technician on Windows XP

11. Windows Mobile

-MCTS: Microsoft Windows Mobile 5.0 Applications
-MCTS: Microsoft Windows Mobile 5.0, Configuration Implementing and Managing
-MCTS: Windows Mobile 6.5, Configuration
-MCTS: Windows Mobile 6.5, Application Development

12. Windows Server Technologies

-MCSE: NT 3.51
-MCSE: NT 3.51 (mixed)
-MCSE: NT 4.0 (mixed)
-MCSE: Windows 2000
-MCSE: Windows NT 4.0
-MCTS: Microsoft Forefront Client and Server, Configuration
-MCTS: Windows Essential Business Server 2008, Configuration
-MCTS: Windows Server 2003 Hosting, Configuration and Management
-MCTS: Windows Server Virtualization, Configuration
-MCTS: Windows Small Business Server 2008, Configuration

13. Other Technologies

-MCTS: Bing Maps Platform, Developing Applications
-MCTS: Biztalk Server 2006 R2, Custom Applications
-MCTS: BizTalk Server 2004, Custom Applications
-MCTS: Biztalk Server 2006, Custom Applications
-MCTS: Connected Home Integrator
-MCTS: Fast Enterprise Search Platform, Developing
-MCTS: Forefront Protection for EndPoint and Server, Configuration
-MCTS: Microsoft Internet Security and Acceleration (ISA) Server 2006, Configuration
-MCTS: Microsoft Response Point, Configuration

10 HTML5 tags you should know

HTML5 is equipped with new tags and attributes which gives you more power and efficiency for web development which is easily understood by search engines specially. It gives you some out of the box functionality which was not provided in earlier versions and you had to write complex JavaScript or some browser plugins were required. Here is a list of 10 HTML5 tags you should know.

1. <video> and <audio>

In earlier versions of HTML, browser plugins were required to play multimedia items. But now HTML5 supports new video and audio controls. The browser can display these controls and content can be manipulated using JavaScript. Also you can specify multiple sources for the content enabling the browser to play multimedia item regardless of the codec.

2. <input> type attributes

The <input> element is introduced with new values for the ‘type’ attribute and browser can render the respective type of control onto the page. Let’s say if you set the type to ‘datetime’, browser can show the calendar control to select the date and time. Earlier JavaScript was required to display and deal with such kind of control. Lots of type attributes are provided which will remove the JavaScript work.

3. <canvas>

The <canvas> tag gives your page a bitmapped surface to work on; it is similar to GDI+ or .NET Image object. Although layers should be replicated using multiple canvas objects on top of each other. But it’s a good way to build graphs and charts which was a weak point in the earlier versions of HTML.

4. <header> and <footer>

These tags are new semantic tags. These two tags render a div to display the important things related to your page. But they give you a long term benefits in terms of you search engine optimization efforts. So the search engines will be able to differentiate between normal contents and important things which are not actual contents.

5. <article> and <section>

These two tags are also semantic tags which will enhance your site’s search engine visibility. You can compose articles with multiple sections as well as a section can have multiple articles. Article is a block of contents. If we consider a blog, the main page will have a listing section for all the posts and each post will be an article with a section for the actual post and other section for comments.

6. <output>

It’s a unique tag for which content can be generated dynamically using JavaScript. This tag has a ‘value’ attribute which can be manipulated using DOM with JavaScript to change the value attribute in order to display the output on screen.

7. <details>

In most of the scenarios we need to display the expand/collapse content for which we needed the AJAX controls to do so but it required the installation of AJAX framework. Also we were able to achieve this functionality using JavaScript or server side coding. But <details> tag makes it much easier to achieve this functionality. It makes a block which expands and collapses the contents on click of the header.

8. <figure> and <figcaption>

<figure> is the container for image content and <figcaption> (the inner tag for <figure> tag) provides a caption for the contents of the <figure> tag. You may have multiple images within <figure> tag showing sales for the last four years and a <figcaption> tag showing text ‘Sales growth, 2009 – 2012’

9. <progress>and <meter>

These two tags are very much similar in terms of semantic meanings and they may look alike on the browser in many cases. We can use the <progress> tag to measure the completeness of a task. We can set the indeterminate mode for this tag in order to measure something unknown e.g. searching a DB. The <meter> tag is for measurement of values such as quantity, thermometer etc.

10. <datalist>

It looks like a drop down list where system provides a list of suggestions but users are free to input their values as well. This tag can be used in many ways e.g. based on user’s search history, display a search box with pre-populated items. In order to achieve this functionality currently without this tag requires a lot of JavaScript. But this HTML5 tag gives you a built in functionality to do so.

Top 5 IT certifications for 2013

This is the right time to set your 2013 goals because 2012 is approaching to its end. Achieving a professional certification is a way to improve your skills and enhance your chances of getting hired. Now a days there are so many certifications that are in the market so if you are confused about which certification to achieve in 2013, following are the top 5 IT certifications for 2013 based on expert opinion, research and Google trends.

If you would like to see a list of retired Microsoft Certifications, please Click Here
If you would like to see a list of retired Microsoft Exams, please Click Here

1. MCSA (Microsoft Certified Solutions Associate)

Following is the salary range and average salary for professionals having this certification:

  • Salary Range: $52,000 to $115,000
  • Average Salary: $59,000

Following are the most popular certifications for MCSA:

  • MCSA: Windows 2012 Server
  • MCSA: SQL Server 2012
  • MCSA: Windows 8
  • MCSA: SharePoint 2013

Remember that Microsoft Certified Solutions Associate (MCSA) certification is a prerequisite to the MCSE expert-level certifications. You can refer to Microsoft Learning website for further details of these certifications.

2. MCSE: Private Cloud

Private Cloud gives you expertise in managing and implementing Microsoft private cloud computing technologies. By this certification you can build your Microsoft private cloud solution to optimize IT services as well as gain the automation flexibility for your IT infrastructure.

Following is the salary range and average salary for professionals having this certification

  • Salary Range: $52,000 to $102,000
  • Average Salary: $61,000

This private cloud certification is as popular as the rival CompTIA and CCP cloud certifications. Microsoft is discontinuing its MCITP program in 2014 and promoting MCSE’s. This way you can get jump start for 2014 certifications.

 3. PMP (Project Management Professional)

Following is the salary range and average salary for professionals having this certification:

  • Salary Range: $65,000 to $93,000
  • Average Salary: $86,000

PMP is kind of certification which will never be outdated. This is a certification which fits in every field. PMP certification allows IT professional to plan, budget and manage IT projects. It will be a very good addition in your resume.

4. VCP (VMware Certified Professional)

Following is the salary range and average salary for professionals having this certification:

  • Salary Range: $59,000 to $80,000
  • Average Salary: $69,000

The main purpose of virtualization or creating virtual platforms for computing is to increase scalability and reduce infrastructure and hardware cost. There is a lot of potential in the virtualization industry and it is rapidly growing. VMware is the leader in virtualization software as well as certifications. They are becoming popular and their certifications are very much valuable.

5. CISSP (Certified Information Systems Security Professional)

Following is the salary range and average salary for professionals having this certification:

  • Salary Range: $65,000 to $111,000
  • Average Salary : $80,000

In order to protect organization’s systems, data and networks, information security architects are becoming very much popular these days. Nowadays companies are shifting towards storing data in cloud systems so security experts have a very important role to secure these systems just like they are secured in-house. That is why the CISSP certification is in high demand and normally the CISSP professionals receive highest average salary.

How to get comma separated values in a single select statement

Sometimes you want to get comma separated values from another table in the same select statement, for this you can use the following approaches

–Approach 1

SELECT SUBSTRING(((SELECT (‘, ‘ + Aud_Type)

FROM   Audience_Type

WHERE  Id_Aud_Type IN (SELECT value

FROM   dbo.fn_Split (‘1,2,3’, ‘,’))

FOR    XML PATH (”))), 3, 1000)

FROM   Request;

GO

–Approach 2

SELECT SUBSTRING(((SELECT (‘, ‘ + Aud_Type)

FROM   Audience_Type AS t2

WHERE  t2.RequestID = req.RequestID

FOR    XML PATH (”))), 3, 1000) AS Aud_Type

FROM   SOP_Request AS req;

GO

You just have to replace the table/column names (Aud_Type, Audience_Type, Id_Aud_Type, SOP_Request) with your ones

–Split Function  which is being used in approach 1

CREATE FUNCTION [dbo].[fn_Split]

(@sText VARCHAR (8000), @sDelim VARCHAR (20)=’ ‘)

RETURNS

@retArray TABLE (

idx   SMALLINT       PRIMARY KEY,

value VARCHAR (8000))

AS

BEGIN

DECLARE @idx AS SMALLINT,

@value AS VARCHAR (8000),

@bcontinue AS BIT,

@iStrike AS SMALLINT,

@iDelimlength AS TINYINT;

IF @sDelim = ‘Space’

BEGIN

SET @sDelim = ‘ ‘;

END

SET @idx = 0;

SET @sText = LTrim(RTrim(@sText));

SET @iDelimlength = DATALENGTH(@sDelim);

SET @bcontinue = 1;

IF NOT ((@iDelimlength = 0)

OR (@sDelim = ‘Empty’))

BEGIN

WHILE @bcontinue = 1

BEGIN

–If you can find the delimiter in the text, retrieve the first element and

–insert it with its index into the return table.

IF CHARINDEX(@sDelim, @sText) > 0

BEGIN

SET @value = SUBSTRING(@sText, 1, CHARINDEX(@sDelim, @sText) – 1);

BEGIN

INSERT  @retArray (idx, value)

VALUES           (@idx, @value);

END

–Trim the element and its delimiter from the front of the string.

–Increment the index and loop.

SET @iStrike = DATALENGTH(@value) + @iDelimlength;

SET @idx = @idx + 1;

SET @sText = LTrim(RIGHT(@sText, DATALENGTH(@sText) – @iStrike));

END

ELSE

BEGIN

–If you can’t find the delimiter in the text, @sText is the last value in

–@retArray.

SET @value = @sText;

BEGIN

INSERT  @retArray (idx, value)

VALUES           (@idx, @value);

END

–Exit the WHILE loop.

SET @bcontinue = 0;

END

END

END

ELSE

BEGIN

WHILE @bcontinue = 1

BEGIN

–If the delimiter is an empty string, check for remaining text

–instead of a delimiter. Insert the first character into the

–retArray table. Trim the character from the front of the string.

–Increment the index and loop.

IF DATALENGTH(@sText) > 1

BEGIN

SET @value = SUBSTRING(@sText, 1, 1);

BEGIN

INSERT  @retArray (idx, value)

VALUES           (@idx, @value);

END

SET @idx = @idx + 1;

SET @sText = SUBSTRING(@sText, 2, DATALENGTH(@sText) – 1);

END

ELSE

BEGIN

–One character remains.

–Insert the character, and exit the WHILE loop.

INSERT  @retArray (idx, value)

VALUES           (@idx, @sText);

SET @bcontinue = 0;

END

END

END

RETURN;

END

–ATLTUsers.eoEmployingorganization_ID in (SELECT value from dbo.fn_Split(”’+@EOID+ ”’, ”,”))’

Enjoy