ASP.NET
- Exploring ASP.NET Validation Controls
- ASP.NET MVC 4 – Part [0] – Setup Environment
- ASP.NET MVC 4 – Part [1] – Introduction
- ASP.NET MVC 4 – Part [2] – Project Items
- ASP.NET MVC 4 – Part [3] – Razor View Engine and ASPX View Engine
- ASP.NET MVC 4 – Part [4] – Phonebook Application
- ASP.NET MVC – Basic overview of different view engines
- ASP.NET Real-time Currency Converter using API (Google, Yahoo), Web service, and jQuery Ajax
- Insert, Update, Delete in ASP.NET Gridview, DataSource as SQL Server, MS Access (mdb/accdb), XML and Framework as 2.0 / 3.0 / 3.5 / 4.0 (VS 2005/2008/2010)
Windows Communication Foundation
- WCF – Message Exchange Patterns (MEPs)
- WCF – REST enabled Service
- WCF – Exception Handling, FaultException and FaultContracts
- WCF-Global Exception Handling using IErrorHandler
Client Side Scripting
- Getting Started With TypeScript ( Superset of JavaScript )
- jQuery – .bind(), .live(), .delegate(), .on() ( and also .unbind(), .die(), .undelegate(), .off() )
.NET Framework
C#
WPF
SQL Server
- String Data Types and Functions – SQL Server (2000, 2005, 2008, 2008 R2, 2012)
- SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
- Date and Time Data Types and Functions – SQL Server (2000, 2005, 2008, 2008 R2, 2012)
- SQL Server’s built-in scalar Logical Functions (IIF() and CHOOSE())
- SQL Server’s Mathematical Functions
- SQL Server’s FORMAT() Function
Utilities \ Plugins
- Troubleshooting Visual Studio Add-ins, Error Numbers and it’s possible solutions
- Web Search – Visual Studio Add-in , Search (Google, Yahoo, MSDN, Code Project, Stack Overflow and more…) for the selected text/item.
- Integrated Color Picker for Visual Studio IDE – VSPackage (AddIn)
- Getting started with Visual Studio Editor Margin Extensions
- Getting started with Visual Studio Editor Viewport Adornment Extensions
- .NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language-Utility
Shemeer's World of Programming 
Pingback: Articles | Mohammed Shayas's Blog
I often used your valuable summary about “String Data Types and Functions – SQL Server (2000, 2005, 2008, 2008 R2, 2012)”
Unfortunately, this article and others have been removed from codeproject.
Do you intend to republish the article somewhere else?
Thanks, Patrick
Sorry for the inconvenience. I will try to publish the same in my blog.