<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Krystal Kones Technologies</title>
	<atom:link href="http://blog.krystalkones.com/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://blog.krystalkones.com</link>
	<description></description>
	<lastBuildDate>Fri, 11 Feb 2011 10:40:22 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.4</generator>
		<item>
		<title>Why Drupal is the best CMS when it comes to SEO ?</title>
		<link>http://blog.krystalkones.com/?p=236</link>
		<comments>http://blog.krystalkones.com/?p=236#comments</comments>
		<pubDate>Fri, 11 Feb 2011 10:36:37 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[SEO & Internet Marketing]]></category>
		<category><![CDATA[Web Design and Development]]></category>
		<category><![CDATA[CMS]]></category>
		<category><![CDATA[Drupal]]></category>
		<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=236</guid>
		<description><![CDATA[Your website is the front door to your business – it provides a first impression of the organization to their perspective customers , generates leads, and propagates your brand message all across the world. However, good looking designs will not get you to the top of the Search Engine Results Page (SERP). That’s why we]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;">Your website is the front door to your business – it provides a first impression of the organization to their perspective customers , generates leads, and propagates your brand message all across the world. However, good looking designs will not get you to the top of the Search Engine Results Page (SERP). That’s why we all use Search Engine Optimization (SEO) techniques for websites, for today’s complex and multi functional content sites, is very different from the HTML of yesteryear.</p>
<p style="text-align: justify;">Drupal, the open source Content Management System (CMS) that runs is a very powerful system that can be used for large and multifunctional, complex sites, and it’s the best platform that exists today for SEO. Drupal’s built-in tools for automating SEO on massive amounts of content, along with control that gives you absolute power over every single website element, put it head and shoulders above the rest, including Joomla and WordPress.<span id="more-236"></span></p>
<blockquote><p>Here’s why Drupal is the best CMS when it comes to SEO:</p></blockquote>
<p style="text-align: justify;"><strong>1. Search engine URLs</strong>. Unlike WordPress, Drupal gives you complete control over URL structure. Each item of content created in Drupal (called a node) can be given a custom URL, called a URL alias. You can even set it to automatically generate user– and search engine-friendly URLs based on content type (blog post, page, user), title of the post, keyword, date, time, or any other information related to the node</p>
<p style="text-align: justify;"><strong> 2. Custom content types and views.</strong> Without having to write any code, you can use the Content Construction Kit (CCK) and view modules to create new content types and create advanced custom views for those types. Common examples include news stories, blog posts, albums, books, and tutorials, all of which can be created and displayed in a variety of ways.</p>
<p style="text-align: justify;"><strong>3. Ease of editing and revisions</strong>. Even the big companies make mistakes in their content drupal gives user an ease in editing and revisions of the content.</p>
<p style="text-align: justify;"><strong> 4. The Taxonomies.</strong> Drupal has a very powerful, built-in taxonomy (categorization) system that allows the user to organize and tag content with keyword-rich terms. You can also have hierarchical categories, with single or multiple parent categories</p>
<p style="text-align: justify;"><strong> 5. Multiple user managemen</strong>t. Drupal is almost as well-known for its community as it is for being easily optimized. That’s because Drupal was designed for community-based websites, and has a strong user role and access control functionality. There are no limits to the user roles and access levels you can create and customize – for example, “anonymous visitor,” “authenticated user,” “editor,” “webmaster,” “admin,” and “moderator.” You can also keep the advanced user management features turned off – like if you have multiple blogs – and enable them later when your site grows.</p>
<p style="text-align: justify;"><strong>6. Page titles.</strong> The page title is the single most important on-page thing you can do to improve the SEO of your website. Page titles, the line of text in the HTML of a Web page that summarizes what that page is about, act as the welcome mat for your website. Page titles:</p>
<ul>
<li>Tell visitors that they are in the right place</li>
<li>Display in the browser title bar</li>
<li>Hold important keywords so that your page can be properly categorized by Google and other search engines</li>
<li>Display whenever someone bookmarks your site</li>
<li>Are often used by search engines as the heading of the search result</li>
</ul>
<p style="text-align: justify;">Drupal can generate a page title automatically by using the site name and site slogan of the front page and the node title for individual nodes, but for more complex content, you may want to rearrange the automated page title for SEO purposes. Drupal’s page title module gives you full control over your page titles throughout your site. You can define a pattern that will create search engine-optimized titles automatically as you create new content, or take control by writing your own page titles anywhere you can create content.</p>
<p style="text-align: justify;"><strong> 7. Better integration with Google Analytics.</strong> Have you ever wondered how much your own clicking around and working on your website skews your analytics data? Not if you have a properly configured Drupal site. Using the free Google Analytics module for Drupal, you can dynamically show and hide analytics code based on several factors, including if the user is logged in as an admin. You can even not track certain sections of your site, not track certain user types (like people logged in as company employees), and cache the Google Analytics code locally, which will speed up your page load times. All within Drupal. No programming required. For free.</p>
<p style="text-align: justify;"><strong> 8 Free and available word wide. </strong>Unlike other platforms, Drupal has large number modules (what we call plug-ins, add-ins, or widgets – modular pieces of code that you can easily add to your site)</p>
<p style="text-align: justify;"><strong> 9. Getting started</strong> with Drupal SEO is easy. Just download the Drupal SEO checklist module, drop it into your sites/all/modules folder on your server, and turn it on from the modules admin page. Go through the simple, step-by-step instructions, and you’re well on your way to the best SEO experience you’ve ever had on a CMS.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=236</wfw:commentRss>
		<slash:comments>3</slash:comments>
		</item>
		<item>
		<title>MVC Architecture With .Net</title>
		<link>http://blog.krystalkones.com/?p=189</link>
		<comments>http://blog.krystalkones.com/?p=189#comments</comments>
		<pubDate>Fri, 11 Feb 2011 03:26:18 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[.Net]]></category>
		<category><![CDATA[MVC architecture]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=189</guid>
		<description><![CDATA[MVC stands for Model-View-Controller. MVC architecture was basically designed to reduce the complex structure into simpler ones. MVC architecture is a design pattern which follows the concept of layering. The layers are nothing but the logical separation of application code into functions present in different classes. This concept allow programmer to modify one component without]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;"><strong>MVC</strong> stands for Model-View-Controller. MVC architecture was basically designed to reduce the complex structure into simpler ones. MVC architecture is a design pattern which follows the concept of layering. The layers are nothing but the logical separation of application code into functions present in different classes. This concept allow programmer to modify one component without affecting others. This architecture helps to achieve code re-usability.</p>
<p style="text-align: justify;">MVC architecture mainly consists of three major components:</p>
<ol style="text-align: justify;">
<li><strong>Model </strong>- Models are designed to work with information in your database.</li>
<li><strong>View </strong>- View depicts the model into a format suitable for interaction, basically a user interface element.  A view is simply a web page, or a page fragment, like a header, footer, sidebar, etc.  Views are never called directly; they must be loaded by a controller.</li>
<li><strong>Controller </strong>- The controller takes input from user through mouse or keyboard and instructs the model and view to perform actions accordingly.<span id="more-189"></span></li>
</ol>
<p style="text-align: justify;">The role of controller is to dictate what to do behind the scenes and what to display in the view next.</p>
<p style="text-align: justify;">a. Controller receives a request.<br />
b. Controller decides the requested activities based on request parameters.<br />
c. Controller delegates tasks to be performed based on the request parameters.<br />
d. Controller delegates the next view to be shown.</p>
<p style="text-align: justify;"><!--more--></p>
<p style="text-align: justify;">Just because of these features our project manager suggested us to go with MVC architecture for one of our  project which is a web based application. So I started performing R&amp;D on MVC architecture. During R&amp;D, I found lots of difficulties to implement the MVC architecture because the IDE of Visual Studio installed on my machine does not provide any inbuilt features to develop the MVC web application. I discussed these issues with the project manager and due to project constraints, he suggested me to go with 3-tier architecture.</p>
<p style="text-align: justify;">At the end, I want to conclude that although there are lots of benefits of MVC architecture but in my opinion, it is not feasible to go with MVC architecture when you are using IDE of Visual Studio that does not provide MVC application as an inbuilt feature. It is better to go with 3-Tier Architecture. The 3-tier architecture will be covered in the next article.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=189</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>SEO &amp; The Most Popular CMS ” Joomla ” !!</title>
		<link>http://blog.krystalkones.com/?p=240</link>
		<comments>http://blog.krystalkones.com/?p=240#comments</comments>
		<pubDate>Fri, 11 Feb 2011 03:21:26 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[SEO & Internet Marketing]]></category>
		<category><![CDATA[Web Design and Development]]></category>
		<category><![CDATA[CMS]]></category>
		<category><![CDATA[Joomla]]></category>
		<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=240</guid>
		<description><![CDATA[Joomla is one of the most popular content management systems on the web . It’s much more complicated than WordPress, however, it provides a wide variety of features for small and medium size businesses and organizations. While WordPress is more of a blogging tool that can be customized to be a website, Joomla is a]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;"><strong>Joomla</strong> is one of the most popular content management systems on the web . It’s much more complicated than WordPress, however, it provides a wide variety of features for small and medium size businesses and organizations. While WordPress is more of a blogging tool that can be customized to be a website, Joomla is a true content management system with lots of extensions for additional advancements.</p>
<p style="text-align: justify;">Here is a list of features which joomla posses that helps the website to gain page ranks.</p>
<p style="text-align: justify;"><span id="more-240"></span></p>
<p style="text-align: justify;"><strong>1.Customized Page Titles:</strong> The joomla content is a collection of articles and user can easily set the customized urls for each article The latest version of Joomla comes with this functionality enabled. While the article manager of Joomla is a bit complicated, setting up custom page titles is a breeze. This is a must for SEO, and you must make sure that all your pages have custom page titles for better seo.</p>
<p style="text-align: justify;"><strong>2. Google XML Sitemap:</strong> A sitemap is an important component that lets Google know about the content on your site and the various links to those content. While Joomla has some difficulties with the development of a truly dynamic sitemap, you can get basic modules which can satisfy the basic need of a sitemap. However, it’s not as advanced as the XML sitemap plugin in WordPress. Ultimately, we would want to have a dynamic sitemap that updates the “Last edited” field each time a page changes or is edited.</p>
<p style="text-align: justify;"><strong>3.  Custom Keyword URLs:</strong> The words used in a URL are important to page optimization and seo rankings. Luckily, there are several Joomla extensions like sh404SEF that allow you to create custom URLs for your pages, where you can include your keywords.  With the basic joomla you can set alias field for each article as Just use the Alias field, and be sure that each page uses unique keywords. There are also similar plugins for custom meta tags and meta description.</p>
<p style="text-align: justify;"><strong>4.  Joomla Backlinks:</strong> There are also available plugins in Joomla for managing backlinks, and even preserving them. For example, use the Joomla Backlink Checker Tool to tell you what sites are linking to you, and what the value of these links are. You can also protect backlinks when you migrate to a more recent version of Joomla by enabling the Backlink Migration extension. This extension will re-route your backlink URLs, meaning that when people click on these, they won’t see a 404 page. This extension will work for all Legacy SEF URLS.</p>
<p style="text-align: justify;">Joomla is a powerful Content management systeml, with strong SEO components. And by the proper use of these components and constructed Joomla site can provide an excellent foundation for a site that is easy to crawl for search engines  and rich in keywords. The many native search engine friendly features often make it a better solution than simpler programs like WordPress.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=240</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>10 SEO Tips To Get Your WordPress Blog Ranking Highly In The Search Engines</title>
		<link>http://blog.krystalkones.com/?p=243</link>
		<comments>http://blog.krystalkones.com/?p=243#comments</comments>
		<pubDate>Fri, 11 Feb 2011 03:16:44 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[SEO & Internet Marketing]]></category>
		<category><![CDATA[Tips and Reviews]]></category>
		<category><![CDATA[SEO]]></category>
		<category><![CDATA[Tips]]></category>
		<category><![CDATA[Wordpress]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=243</guid>
		<description><![CDATA[WordPress is the most popular blogging tool. Below are the 10 SEO tips that will help you get all users on your blog. SEO Tip # 1: Use  Keywords ( Targeted ) in the Blog Post Titles. Post titles should make use of targeted keywords and should be mentioned every so often in the article. The titles]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;">WordPress is the most popular blogging tool. Below are the 10 SEO tips that will help you get all users on your blog.</p>
<p style="text-align: justify;"><strong>SEO Tip # 1: Use  Keywords ( Targeted ) in the Blog Post Titles. </strong>Post titles should make use of targeted keywords and should be mentioned every so often in the article. The titles should not be used again as another post title on the same site since this can confuse the search engines and influence your rankings. It is a good idea to make a list of keywords you would like to focus on and have them handy for your post titles.</p>
<p style="text-align: justify;"><strong>SEO Tip # 2: Make Page Titles Interesting and make sure to use targeted keywords. </strong>These should be carefully thought out. Use appropriate keywords that you want to target. It is especially important if you are going to have a list of pages appear on the front page of your site.</p>
<p style="text-align: justify;">Make your titles appealing and interesting in the first couple of words. Avoid unnecessary words like “a” and “the” at the beginning of the title, as you have a limited number of words to grab the attention of the person searching the search engines for a topic.<span id="more-243"></span></p>
<p style="text-align: justify;"><strong>SEO Tip # 3: Make Use of Google Sitemap.</strong>This is a tool that can get your site indexed faster by Google, and it is a must-have for any WordPress site. It helps Google find out what pages are on your site. You can make a sitemap with a simple plugin that allows you to turn on the sitemap at the flip of a button.</p>
<p style="text-align: justify;"><strong>SEO Tip # 4: Ping Your Posts in various social networks.</strong>Every time you make a post you can ping your post to a number of different websites. This will give you added exposure and help you develop backlinks if your post is linked back by webmasters. Every post should be pinged.</p>
<p style="text-align: justify;"><strong>SEO Tip # 5: Customize Your Permalinks or URLs for post. </strong>This is one of the most important things you can do for a WordPress blog as far as SEO goes. You want to get the title of your post in the URL itself. You can do this by customizing your permalink structure. Simply type in /%postname%/ in the custom option and the blog post name will appear.</p>
<p style="text-align: justify;">If you do not make the changes, the default structure will appear in the URL, which consists of numbers and question marks. This does nothing for SEO, and your posts would not be picked up as quickly, and would not rank as well.</p>
<p style="text-align: justify;"><strong>SEO Tip # 6: Create Tags for each post in a blog. </strong>Creating tags helps the search engines when they are crawling your site. They are only one or two words that briefly describe what your post is all about.</p>
<p style="text-align: justify;">Search engines use tags to help categorize, index and find your posts faster. Tagging can be done as soon as you complete a post, and only takes a few seconds to do.</p>
<p style="text-align: justify;"><strong>SEO Tip # 7: Do Some Linking. </strong>You can cross-link your posts to other posts you have on your blog. You can either do this manually, or by using a plugin.</p>
<p style="text-align: justify;">If you have a post that you think is important, or a sales page on your blog, you can link to it and make the post or page have an importance level of its own.</p>
<p style="text-align: justify;"><strong>SEO Tip # 8: Set Up Categories so that user can search by categories.</strong>Categories will tidy up your site into a neat and orderly presentation of content that is good for both your visitors and the search engines. It is like cataloguing a file cabinet full of loose papers into separate piles of information that are readily available.</p>
<p style="text-align: justify;">If you have the permalinks turned on for your blog, you will see the category listed in the URL as well as the name of the post. This helps with SEO, and your visitors will appreciate seeing what is on the post directly from the URL.</p>
<p style="text-align: justify;"><strong>SEO Tip # 9: Include Related Posts. </strong>You can add posts that are related to a post under any postings that you do. You can get a plugin that will place a number of posts that are related via their tags. You can configure how many related posts you want to show, which makes it easier for the search engines to make their way to your older content.</p>
<p style="text-align: justify;"><strong> </strong></p>
<p style="text-align: justify;"><strong> </strong></p>
<p style="text-align: justify;"><strong>SEO Tip # 10: Use an All-In-One SEO Pack. </strong>This plugin generates META tags automatically, or you can set any META keywords and descriptions you want. It works well with other plugins, and gives you the flexibility to try ranking for different keywords if you are not being properly recognized for one.</p>
<p style="text-align: justify;">Many webmasters would not consider doing without this one SEO plugin and have seen dramatic results by using it. It can be added to pre-existing sites as well if you want to try boosting your rankings.</p>
<p style="text-align: justify;">There are other things you can do to help optimize your SEO on a WP blog; but if you follow the recommendations listed above, you will be well on your way to having a blog that the search engines would love and pay attention to.</p>
<p style="text-align: justify;">These guidelines will set up a nice clean blog pattern that can be duplicated time and time again as you build more blogs. It is easy to set up, and you can gradually add more plugins and items to get your site in an even better position to make it to the top.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=243</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>White Hat/Black Hat/Grey Hat SEO Techniques</title>
		<link>http://blog.krystalkones.com/?p=187</link>
		<comments>http://blog.krystalkones.com/?p=187#comments</comments>
		<pubDate>Fri, 11 Feb 2011 03:10:47 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[SEO & Internet Marketing]]></category>
		<category><![CDATA[Black Hat Technique]]></category>
		<category><![CDATA[Grey Hat Technique]]></category>
		<category><![CDATA[SEO techniques]]></category>
		<category><![CDATA[white Hat method]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=187</guid>
		<description><![CDATA[While scrutinizing the SEO terminologies, many a times we come across the term White Hat, Black Hat and Grey Hat Seo techniques. Before accomplishing the SEO of any website in online world, one should glance at these subsets for furnishing a successful SEO campaign. White Hat or ethical SEO methods encompass all the strategies and]]></description>
			<content:encoded><![CDATA[<p>While scrutinizing the SEO terminologies, many a times we come across the term White Hat, Black Hat and Grey Hat Seo techniques. Before accomplishing the SEO of any website in online world, one should glance at these subsets for furnishing a successful SEO campaign.</p>
<p><strong>White Hat or ethical SEO methods</strong> encompass all the strategies and techniques that embody pleasant impression on the search engines like Google, Yahoo, etc. For this along with tweaking the codes of your website, you should focus on attaining quality links to your online enterprise.</p>
<p><span id="more-187"></span></p>
<p>All White hat SEO techniques pursue the search engine guidelines.<strong> Here some of the pure White Hat Techniques are explained</strong></p>
<ul>
<li><strong><span style="text-decoration: underline;">Assuring Quality Content</span></strong></li>
</ul>
<p>Content being the Caesar of your online image, should possess the value laden information. Content rich website seems pleasing to the search engines and visitors. Search engines just love content. You should emphasis on employing fresh and unique content to the site. At the same time duplicity should be avoided.</p>
<p><strong> </strong></p>
<ul>
<li><strong><span style="text-decoration: underline;">Consort  search engine while crawling your site</span></strong></li>
</ul>
<p>The website should be structured in seo friendly pattern. For this, here are some of the seo tips <strong></strong></p>
<p><strong>1. Title and meta tag</strong></p>
<p>These should bear the highly targeted keywords and key phrases of your site. These tags govern the most sensitive section of your code which if handled well, could help increase your rank.</p>
<p><strong>2. Keywords</strong></p>
<p>A thorough search about the targeted keywords should be done before inserting them in your site. Try to target multi-words phrases that are more relevant to your website representing your product and services.</p>
<p><strong>3. CSS Assignment</strong></p>
<p>A separate CSS should be included to accomplish all the design elements of your site. This avoids the distorted representation of the code and helps search engine crawl the site.</p>
<p><strong>4. Semantic Mark Up</strong></p>
<p>These should be utilizes in Seo friendly manner. The structured tag employed in hierarchical manner is preferred.</p>
<p>The other side of coin deals with <strong>Black Hat SEO or unethical SEO technique.</strong> It involves efforts like redirecting the search engine “spiders” to completely different pages than what human visitors see, mass-posting of “spam” comments (on blogs, forums, articles), or inserting wide range of keywords at the end of every web page. These techniques sometimes try to deceive the visitors and target all the other unethical means as well.</p>
<p><strong>Grey Hat Seo</strong> is all about utilizing these tactics falling in the grey area between transparent legitimate tactics and the search engine spam. These include seo techniques such as paid links, cloaking, duplicate content and some other with the same concern. Unless you are employing the fair phase of the coin, these tactics are not advised.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=187</wfw:commentRss>
		<slash:comments>13</slash:comments>
		</item>
		<item>
		<title>Database Design</title>
		<link>http://blog.krystalkones.com/?p=203</link>
		<comments>http://blog.krystalkones.com/?p=203#comments</comments>
		<pubDate>Sun, 06 Feb 2011 19:53:01 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Database]]></category>
		<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[Database Design]]></category>
		<category><![CDATA[Stored Procedure]]></category>
		<category><![CDATA[View]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=203</guid>
		<description><![CDATA[Common Mistakes in Database Design: Before starting this article first let you know that this article written on the basis of my personal experience. The mistakes listed below are generally done by the programmers because of “getting it done”.  This article helps you in database design as it covers common database design mistakes: Poor planning]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;"><strong>Common Mistakes in Database Design:</strong></p>
<p style="text-align: justify;">Before starting this article first let you know that this article written on the basis of my personal experience. The mistakes listed below are generally done by the programmers because of “getting it done”.  This article helps you in database design as it covers common database design mistakes:</p>
<ul style="text-align: justify;">
<li>Poor planning</li>
<li>Bad naming convention</li>
<li>Abstention of stored procedures</li>
<li>Abstention of views</li>
<li>Abstention of normalization</li>
</ul>
<p style="text-align: justify;">When we talk about the overall performance of any application then it is mainly concern with the design of the database. Not only performance but the maintenance of the database is also a major issue which can be done only by avoiding redundancy and maintaining the consistency &amp; integrity in the database. Poor database design leads an application in the wrong direction. While designing a database will make sure to avoid these basic mistakes. Here is one small example of database design.</p>
<p style="text-align: justify;"><span id="more-203"></span></p>
<p style="text-align: justify;"><strong>Example: </strong><br />
Suppose we want to store the information related with the employees of any company like: employee name, DOB, city and pin code.</p>
<p style="text-align: justify;"><strong>Wrong Approach: </strong></p>
<p style="text-align: justify;"><strong>Create Database:</strong><br />
CREATE DATABASE Employee_info_db<br />
<strong>Create Table:</strong><br />
<strong>1.Emp_details_tbl</strong><br />
CREATE TABLE Emp_details_tbl(<br />
[Emp_id] [int] IDENTITY(1,1) NOT NULL,<br />
[Emp_fname] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,<br />
[Emp_mname] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,<br />
[Emp_lname] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,<br />
[Emp_dob] [datetime] NOT NULL,<br />
[Emp_city] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,<br />
[Emp_pincode] [int] NOT NULL,<br />
CONSTRAINT [PK_Emp_details_tbl] PRIMARY KEY CLUSTERED ( [Emp_id] ASC )<br />
WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]</p>
<p style="text-align: justify;">If we store all the information in a single table the following anomalies arises:</p>
<ul style="text-align: justify;">
<li>It is not possible to insert any city if there is no employee corresponding to that city. This is called insert anomaly.</li>
<li>If we want to update the pin code of any city then we have to update it in various records corresponding to that particular city. This is called update anomaly.</li>
<li>If we delete the record of any employee and no other employee reside in his/her city then we lost the information related with that city (like pin code). This is called delete anomaly.</li>
<li>This design also creates the redundancy in the table in the form of pin code.</li>
</ul>
<p style="text-align: justify;"><strong>Follow this approach: </strong></p>
<p style="text-align: justify;"><strong>Create Database:</strong><br />
CREATE DATABASE Employee_info_db<br />
<strong>Create Tables:</strong><br />
<strong>1.Emp_details_tbl</strong><br />
CREATE TABLE Emp_details_tbl(<br />
[Emp_id] [int] IDENTITY(1,1) NOT NULL,<br />
[Emp_fname] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,<br />
[Emp_mname] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,<br />
[Emp_lname] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,<br />
[Emp_dob] [datetime] NOT NULL,<br />
[City_id] [int] NOT NULL,<br />
CONSTRAINT [PK_Emp_details_tbl] PRIMARY KEY CLUSTERED ( [Emp_id] ASC )<br />
WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]<br />
) ON [PRIMARY]</p>
<p style="text-align: justify;"><strong>2. City_tbl</strong><br />
CREATE TABLE City_tbl(<br />
[City_id] [int] IDENTITY(1,1) NOT NULL,<br />
[City] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,<br />
[Pincode] [int] NOT NULL,<br />
CONSTRAINT [PK_City_tbl] PRIMARY KEY CLUSTERED ( [City_id] ASC )<br />
WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]<br />
) ON [PRIMARY]</p>
<p style="text-align: justify;"><strong>Queries:</strong><br />
<strong>Select</strong><br />
select * from Emp_details_tbl;<br />
<strong>OutPut:</strong><br />
Emp_id   Emp_fname  Emp_mname Emp_lname   Emp_dob    City_id<br />
<strong>1              Ajay             NULL          Sharma     1986-01-02      1 </strong><br />
<strong>2              Rajni            NULL          Saxena      1986-12-10      2 </strong></p>
<p style="text-align: justify;">select * from City_tbl;<br />
<strong>OutPut:</strong><br />
City_id     City        Pincode<br />
<strong>1            Indore    452001</strong><br />
<strong>2            Bhopal   462003</strong></p>
<p style="text-align: justify;"><strong>Join</strong><br />
select emp.Emp_id,emp.Emp_fname,emp.Emp_lname,emp.Emp_dob,c.City,c.Pincode from Emp_details_tbl as emp join City_tbl as c on emp.City_id=c.City_id;<br />
<strong>OutPut:</strong><br />
Emp_id Emp_fname Emp_lname   Emp_dob       City      Pincode<br />
<strong>1             Ajay          Sharma     1986-01-02    Indore   452001</strong><br />
<strong>2             Rajni         Saxena      1986-12-10    Bhopal  462003</strong></p>
<p style="text-align: justify;"><strong>View</strong><br />
CREATE VIEW View_emp_detail<br />
AS<br />
SELECT Emp_details_tbl.Emp_id,Emp_details_tbl.Emp_fname,Emp_details_tbl.Emp_mname, Emp_details_tbl.Emp_lname,Emp_details_tbl.Emp_dob,City_tbl.City,City_tbl.Pincode<br />
FROM Emp_details_tbl INNER JOIN City_tbl<br />
ON Emp_details_tbl.City_id = City_tbl.City_id</p>
<p style="text-align: justify;"><strong>Fetch data from View:</strong><br />
Select * from View_emp_detail<br />
<strong>OutPut:</strong><br />
Emp_id Emp_fname  Emp_lname  Emp_dob     City       Pincode<br />
<strong>1                Ajay       Sharma     1986-01-02  Indore   452001</strong><br />
<strong>2                Rajni      Saxena      1986-12-10  Bhopal  462003</strong></p>
<p style="text-align: justify;"><strong>Stored Procedure</strong><br />
CREATE PROCEDURE sp_empdetails<br />
@cid int<br />
AS<br />
BEGIN<br />
– SET NOCOUNT ON added to prevent extra result sets from<br />
– interfering with SELECT statements.<br />
SET NOCOUNT ON;<br />
– Insert statements for procedure here<br />
SELECT Emp_id,Emp_fname,Emp_mname,Emp_lname,City_id FROM Emp_details_tbl WHERE City_id = @cid<br />
END</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=203</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Link building –Why and How?</title>
		<link>http://blog.krystalkones.com/?p=190</link>
		<comments>http://blog.krystalkones.com/?p=190#comments</comments>
		<pubDate>Sun, 06 Feb 2011 19:45:49 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[SEO & Internet Marketing]]></category>
		<category><![CDATA[Back Links]]></category>
		<category><![CDATA[Link Building]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=190</guid>
		<description><![CDATA[It’s imperative to know about link building while dealing with SEO campaign. One of the SEO tactics that any webmaster can perceive to promote the site online is to establish maximum “high quality links” for the website. “Link building is the technique to develop “inbound links” to your website for increasing the web traffic and]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;">It’s imperative to know about link building while dealing with SEO campaign. One of the SEO tactics that any webmaster can perceive to promote the site online is to establish maximum “high quality links” for the website.</p>
<p style="text-align: justify;">“Link building is the technique to develop “inbound links” to your website for increasing the web traffic and elevate your Rank in Search Engine like Google, Yahoo etc.”</p>
<p><span id="more-190"></span></p>
<p>The Google response to the questions</p>
<p>“<strong>How I can improve the ranking of my website?”</strong></p>
<p style="text-align: justify;">Is “Generally the webmasters can enhance their ranking by increasing the number   of quality sites that links to your WebPages.”</p>
<p style="text-align: justify;">In nutshell, we can say that valuable back links are considered as the web votes in Search Engine ranking formula. But this doesn’t end here. There are some auxiliary considerations confronting the rank of your website. These are</p>
<ul>
<li> Who links to your site?</li>
<li>Where to place the link?</li>
<li>What they say about you?</li>
<li>Why should you link to them? etc.</li>
</ul>
<p> These are rather more important factors as compared to the number of site linking to you.</p>
<p><strong><span style="text-decoration: underline;">Why to use back links?</span></strong></p>
<p style="text-align: justify;">Some webmasters builds back links to <strong>increase their back links, </strong>while other accomplishes it for <strong>enhancing their PageRank etc.</strong></p>
<p><strong>1. Increase Back Links through link building–</strong></p>
<p style="text-align: justify;">The more links your site possess, the plenty are the paths available for bots to discover your website and to cache it.  Few tactics to improvise back links are blog rolls, directory submission, article submission etc.</p>
<p><strong> </strong><strong>2. Building links to boost your Page Rank–</strong></p>
<p style="text-align: justify;">Although there may be lot of websites linking to you, but it is also valuable for these sites to have high Page Rank. It acts as a dimension for the Google to measure your website.</p>
<p style="text-align: justify;"><strong>Page rank</strong> is the identity of a particular site based on the fact that how many site points to you and the number of sites pointing to those websites. In short, getting linked to those websites with higher page rank are vulnerable than being linked with greater number of sites with lower page rank. This conveys Google that your website is linked to trusted domain.</p>
<p style="text-align: justify;"> The most relevant techniques to enhance your Page Rank is to get links from those sites having PR of 4 or above, or by social bookmarking, text link buying , mass press releasing,  and link baiting.</p>
<p><strong> </strong><strong>3. Link building for elevating Search Engine Ranking–</strong></p>
<p style="text-align: justify;">It’s not only the number of links that matters in the web world. What these links say about your site can make a huge difference. Getting links with the sites describing the keywords you’re going after is more recommended. These helps Google bots categorize your site and rank you according to the relevancy of your site.</p>
<p style="text-align: justify;">Techniques to enhance your web Rank are Link exchange, blog review, linking to those sites you targeting your keyword, etc.</p>
<p><strong>4. To generate traffic</strong></p>
<p style="text-align: justify;">However you may build links to increase backlinks or Page Rank or Search Engine ranking, but more worthwhile job will be linking with those sites which send you targeted traffic. This is a better investment than building links to fetch some love from search engines’ proprietary algorithms.</p>
<p style="text-align: justify;">This could be done through affiliate marketing, paid links, forums in your industry, social media networking etc.</p>
<p style="text-align: justify;">By following the above mentioned approaches you could expand your web visibility and fetch maximum targeted customers.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=190</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Difference Between MYSQL &amp; MSSQL</title>
		<link>http://blog.krystalkones.com/?p=245</link>
		<comments>http://blog.krystalkones.com/?p=245#comments</comments>
		<pubDate>Sun, 06 Feb 2011 19:26:04 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Database]]></category>
		<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[MySQL]]></category>
		<category><![CDATA[SQL Server]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=245</guid>
		<description><![CDATA[Difference between MYSQL and MSSQL Before starting this article, let me say that I always like to use SQL Server to interact with a database. My database experience started with SQL Server and followed by MYSQL Server. During this journey, I experienced many differences between these two and I found SQL Server as a total]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;"><strong>Difference between MYSQL and MSSQL</strong></p>
<p style="text-align: justify;">Before starting this article, let me say that I always like to use SQL Server to interact with a database. My database experience started with SQL Server and followed by MYSQL Server. During this journey, I experienced many differences between these two and I found SQL Server as a total package of ease-of-use, reliability, and good performance.</p>
<p style="text-align: justify;"><span id="more-245"></span></p>
<p style="text-align: justify;">Some of the differences are explained below:</p>
<p style="text-align: justify;">Microsoft SQL Server data management solution claims to provide secure and scalable applications. But MS SQL works only in Windows and is expensive while MySQL works on Windows and Unix and is free (Open Source).</p>
<p style="text-align: justify;"><strong>Security</strong><br />
Security is always a major concern for most businesses and a powerful consideration in choosing a database system. Both DBMS support security. MySQL provide security at the table level, via the SQL command. On the other hand, SQL server provides security at the column level. The SQL Server 2005 has implemented more advanced authorization and authentication features.</p>
<p style="text-align: justify;"><strong>Performance comparison</strong><br />
It is bit difficult to compare SQL Server and MySQL on the performance basis. The performance factor in between these two database types doesn’t depend on the database provider but it’s the experience of the database developers &amp; DBA which make it perform better than each other. To build a stable &amp; an efficient system you can use both of these RDBMS.</p>
<p style="text-align: justify;">Although we can say that, in terms of performance, MySQL is better than SQL on a variety of platforms. They are compactable and use less memory and CPU cycles. MySQL is also the most famous &amp; loved amongst the IT professional because of its multiple choices in custom storage engines. MySQL has multiple storage engines, which allows programmer to choose the one which is most suitable for each table in the application.</p>
<p>Difference between MSSQL and MYSQL related with the syntax are as follows:</p>
<ul>
<li>MSSQL support User Defined DataTypes (UDD) whereas MYSQL does not.</li>
<li>Use prefix “@”symbol for variable declaration in MSSQL, whereas in MYSQL “@” symbol is not required.<br />
<strong>Ex:</strong> declare @id int — MSSQL Syntax<br />
declare id int; –MYSQL Syntax</li>
<li>In MYSQL all statement must end with semicolon “<strong>;</strong>” but in MSSQL Semicolon “<strong>;</strong>” is not required.</li>
<li>If we want to access the top most record from database then syntax will be:</li>
</ul>
<p>In <strong>MSSQL:</strong> SELECT TOP1 from table_name<br />
In <strong>MYSQl:</strong> SELECT from table_name where limit 1;</p>
<ul>
<li><strong>Stored procedure in MYSQL</strong>:</li>
</ul>
<p>DELIMITER $$<br />
DROP PROCEDURE IF EXISTS ‘sp_emp_detail‘ $$<br />
CREATE DEFINER=‘root‘@‘localhost‘ PROCEDURE ‘sp_bug_assignedto‘(in id int)<br />
BEGIN<br />
select  * from emp_tbl where empid = id;<br />
END $$<br />
DELIMITER ;</p>
<p><strong>Calling:</strong><br />
CALL sp_emp_detail(1);</p>
<ul>
<li><strong>Stored procedure in MSSQL:</strong></li>
</ul>
<p>CREATE PROCEDURE sp_emp_detail<br />
@cid int<br />
AS<br />
BEGIN<br />
– SET NOCOUNT ON added to prevent extra result sets from<br />
– interfering with SELECT statements.<br />
SET NOCOUNT ON;<br />
– Insert statements for procedure here<br />
SELECT Emp_id,Emp_fname,Emp_mname,Emp_lname,City_id FROM Emp_details_tbl WHERE City_id = @cid<br />
END</p>
<p><strong>Calling:</strong><br />
Execute sp_emp_detail 1</p>
<p style="text-align: justify;"><strong>Conclusion:</strong><br />
It is not true that SQL Server is better than MySQL or vice versa. Both can be used to build stable, scalable and efficient system because the stability and effectiveness of an application and database depend on the experience of the database developers and database administrator not on the database’s provider.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=245</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>WordPress, Joomla &amp; Drupal: Which CMS is best?</title>
		<link>http://blog.krystalkones.com/?p=196</link>
		<comments>http://blog.krystalkones.com/?p=196#comments</comments>
		<pubDate>Sun, 06 Feb 2011 19:17:51 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[CMS]]></category>
		<category><![CDATA[Drupal]]></category>
		<category><![CDATA[Joomla]]></category>
		<category><![CDATA[Wordpress]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=196</guid>
		<description><![CDATA[WordPress (WP), Joomla and Drupal are three of the most popular and free content management systems which are widely available on the Internet, but there are lots of debates between users about which one is better. In this article I am going to discuss few pros and cons of each CMS. WordPress Pros: WordPress was]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;">WordPress (WP), Joomla and Drupal are three of the most popular and free content management systems which are widely available on the Internet, but there are lots of debates between users about which one is better. In this article I am going to discuss few pros and cons of each CMS.</p>
<blockquote><p><em><strong>WordPress</strong></em></p></blockquote>
<p style="text-align: justify;"><strong>Pros:</strong> WordPress was created with blogging and various blog features in mind and is ideally suited for small websites that require limited features and capabilities. It is easy to install and set up, and there are many free templates available for people who don’t have strong design skills. Also plugins are readily available for free download at the core site of WordPress.org.</p>
<p style="text-align: justify;"><strong>Cons:</strong> WordPress  is designed mainly for blogging purposes, which leads to limited functionality. A site that grows beyond something small in nature  and functionalities and capabilities will soon find that the limitations may make using it easy and simple, but those same limitations inhibit the ability to add extensive functionality.</p>
<p style="text-align: justify;">WordPress is recommended for anyone with light technical skills who is launching a site on their first CMS.<span id="more-196"></span></p>
<blockquote><p><strong>Joomla</strong></p></blockquote>
<p style="text-align: justify;"><strong>Pros:</strong> Joomla is justifiably popular because of its simple and visual interface — one of the same favorite traits of WordPress. The core site at Joomla.org has an extensive list of  Extensions and Plug ins and the discussion forum are populated with users who seem quite willing to help out newcomers and provides extensive way to work on joomla. One of the most interesting feature of joomla is templating which is rather simple and easy task.</p>
<p style="text-align: justify;"><strong>Cons:</strong>The plugins don’t always install correctly, and security concerns seem common. Like the limited functionality of WordPress, the limited templating system of Joomla is a challenge as well.</p>
<p style="text-align: justify;">Joomla is recommended for users with moderate technical skills and some experience in managing Web sites.</p>
<blockquote><p><strong>Drupal</strong></p></blockquote>
<p style="text-align: justify;"><strong>Pros</strong>: Of the three major systems, Drupal is the most technically advanced and well-regarded for its efficient design. Plugins integrate efficiently with a high success rate. The core drupal site has an extensive list of available and ready to use plugins</p>
<p style="text-align: justify;"><strong>Cons</strong>: The Drupal interface is not user friendly and takes time and requires extensive usage to understand the complete set of website features and functions. Although free templates are available, any changes require a more advanced knowledge of PHP than WordPress or Joomla. In addition, the user forums at Drupal.org are not as responsive as the forums for WordPress or Joomla.</p>
<p style="text-align: justify;">Drupal is recommended for anyone with advanced technical skills.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=196</wfw:commentRss>
		<slash:comments>3</slash:comments>
		</item>
		<item>
		<title>Web Designing</title>
		<link>http://blog.krystalkones.com/?p=77</link>
		<comments>http://blog.krystalkones.com/?p=77#comments</comments>
		<pubDate>Sun, 23 Jan 2011 17:30:25 +0000</pubDate>
		<dc:creator>Sanjeev</dc:creator>
				<category><![CDATA[Knowledge Bank]]></category>
		<category><![CDATA[Tips and Reviews]]></category>
		<category><![CDATA[Web Design and Development]]></category>

		<guid isPermaLink="false">http://blog.krystalkones.com/?p=77</guid>
		<description><![CDATA[Creating a website is not a easy task. There are lots and lots of things that you need to do in order to make your website successful. If you are planning to launch a website for a particular brand or product you should firstly visit different websites on the internet that sells the same items.]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;">Creating a website is not a easy task. There are lots and lots of things that you need to do in order to make your website successful. If you are planning to launch a website for a particular brand or product you should firstly visit different websites on the internet that sells the same items. Concern this website layout for references and overview the theme accordingly. No need to copy the same content to your site; just overlook the reference once about what your site is supposed to be like.</p>
<p style="text-align: justify;">When you have gathered enough data then it’s time for you to create a site you can regard as your own. For doing this you should know about the web design tool, programming languages etc. Some of the languages in which web designing work is accomplished are HTML, CSS, Java Script, JQUERY etc.</p>
<p><span id="more-77"></span></p>
<p style="text-align: justify;">For working in the dynamic content, you should be accomplished with language like PHP/ ASP/JSP, database knowledge, flash etc. It helps you make site very attractive and good looking. The appealing look should be accomplished with readability and understandability as well. For this a well furnished code need to be added to the site and less bug should be done. It helps you to get the right standard according to the validator.</p>
<p style="text-align: justify;">Excellent design is the pillar of your website. For this Use design tool like Photoshop, Illustrator, Firework etc need to be utilized effectively. All professionals work on these tools and deliver appealing design to the globe.</p>
<p style="text-align: justify;">In nutshell, an attractive and professional looking website is a premier for any business presentation. No one in the world bothers for a crappy looking website. If you are not acknowledged with the designing techniques, consult a web professional for making site for you. They provide good services and ensures that your need is fulfilled.</p>
<p style="text-align: justify;">Your website is your representative which could comprehend or destroy your online image. For forming a compelling impression on the users and delivering your product online, the visual appeal should be prominent and catchy.</p>
]]></content:encoded>
			<wfw:commentRss>http://blog.krystalkones.com/?feed=rss2&#038;p=77</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>

