MSSQL tutorials full detail by jani

Today i tell you

What is a MSSQL? What is MSSQL capable of? What is MSSQL used for?

What is a MSSQL?

MSSQL is short for Microsoft SQL Server. It is a relational web hosting database that is used to store web site information like blog posts or user information.
MSSQL is the most popular type of database on Windows servers.
It is not free but it has many advanced features that make it suitable for businesses.

What is MSSQL capable of?

In basic terms, an MSSQL database is capable of storing any type of that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time. You will use SQL statements to accomplish all of this. In more technical terms, most versions of MSSQL have the following features:
*.Buffer management
*.Logging and Transaction
*.Concurrency and locking
*.Replication services
*.Analysis services
*.Notification services
*.Integration services
*.Full text search service
*.Stored procedures
*.Triggers
*.Views
*.Sub-SELECTs (i.e. nested SELECTs)

What is MS SQL used for?

MSSQL is the database of choice for web applications on a Windows platform (using .NET or ASP).
These languages make is extremely easy to connect to a MSSQL database. It is also used for many popular content management systems and other scripts.

what is htaccess full detail by jani

Tody i tell you

What is .htaccess?

Using .htaccess files lets you control the behavior of your site or a specific directory on your site. For example, if you place an .htaccess file in your root directory, it will affect your entire site ( www.yourdomain.com). If you place it in a /content directory, it will only affect that directory ( www.yourdomain.com/content). .htaccess works on our Linux servers. Using an .htaccess file, you can: *.Customize the Error pages for your site. *.Protect your site with a password. *.Enable server-side includes. *.Deny access to your site based on IP. *.Change your default directory page (index.html). *.Redirect visitors to another page. *.Prevent directory listing. *.Add MIME types. .htaccess files are a simple ASCII text file with the name .htaccess. It is not an extension like .html or .txt. The entire file name is .htaccess.

NOTE

:Make sure you create an .htaccess file using a plain text editor that doesn't use word wrap. Some editors (such as MS Word or Notepad with Word Wrap enabled) will insert special SCII codes to signify a line break. Your .htaccess file will not work if it has these special characters in it.

Change your default directory page via .htaccess full detail by jani

Tody i teach you

how to Change your default directory page (index.html)

When you load a directory on the web, for example www.yoursite.com or www.yoursite.com/articles/, the apache server usually looks for the index.html file. If it can’t find that it will look for index.php or index.cgi. Index.html is usually the page with the highest priority and the one which is loaded first. It is possible to change the default directory index page. Say, for example, you wanted visitors to go to notice.html instead of index.html. All you have to add to your .htaccess file is DirectoryIndex notice.html This can be extended so that the server looks for other files if it cannot find the first one. DirectoryIndex notice.html index.cgi index.php index.html Priority goes from left to right. So the server would look for notice.html. If that file is not there it will look for index.cgi, then index.php and then index.html. You can do to this within any directory on your site. Simply upload an .htaccess file with the above code. Remember, this will supercede the .htaccess file at the root of your domain.

Enable server-side includes via .htaccess full detail by jani

Tody i tell you

how to server side includs enable via .htaccess

SSI stands for server side includes, these are special HTML tags which you can include in your HTML documents to call CGI scripts or other HTML content. This is particularly useful, for example to include a navigation menu in your HTML documents, it allows you to use one document to display the navigation menu in all your other documents. This saves disk space and means if you need to update the content, you only need to modify one file. Two examples of HTML tags you would use to call SSI documents are shown below, these would be placed in your HTML document: This would load the CGI script 'script.cgi' which is located in the 'cgi-bin' directory. This example would call the HTML document 'document.html' which is located in the 'files' directory. It is important to use a relative URL, not a path or full URL. It is likely SSI will work on your web server, but you will probably need to use '.shtml' file extensions rather than '.html'. This can be frustrating if you already have a web site setup which uses '.html' extensions. In this case, you can enable SSI by following the instructions below. To enable SSI, create a .htaccess file following the main instructions and guidance which includes the following text: AddHandler server-parsed .html The above lines tell the Apache Web Server to allow server side includes in documents with the file extension '.html'. To enable SSI for multiple file extensions, create a .htaccess file following the main instructions and guidance which includes the following text: AddHandler server-parsed .html AddHandler server-parsed .shtml AddHandler server-parsed .htm The above lines tell the Apache Web Server to allow server side includes in documents with the file extension '.html', '.shtml' and '.htm'

Protect your site with a password via htaccess full detail by jani

Tody i tell you

how to password protect some of the page via .htaccess

If you want to password protect some of your web pages, then you need to use a .htaccess file with a .htpasswd password file. This tutorial will tell you step

What You Need

You will be executing commands directly on the web server, and the only way to do that is via SSH. SSH is basically a secure form of telnet, and you can use SSH to do anything you might typically do with telnet. So, you must have a SSH client to connect to the web server via SSH. You will also need a FTP client if you want to create your .htaccess file on your own system, then upload it to the web server. The only other thing you need is a web hostingaccount from Anchor. This would simply be your FTP account information that you received when your service started. To connect via SSH you would just use the same hostname, username, and password as your FTP account. Step By Step Instructions Let's suppose you want to restrict files in a directory called members to username member one with password member one password. Here's what to do: 1. Create a file called.htaccessin directory members that looks like this: AuthType Basic AuthName "Restricted access" AuthUserFile /home/USERNAME/.htpasswd require valid-user Notes: *. In the AuthUserFile line, replace USERNAME with your ftp username. *.The .htaccess file must be an ASCII text document. *.A .htaccess file can be created in any word processor but must be saved as text only. *.IF you upload your .htaccess file via FTP, the FTP client must be set to ASCII mode for transfer. *.For security reasons, the .htaccess file on the server cannot be seen in a directory listing. If you don't see it after uploading it, don't worry. *. Also note thatAuthNamecan be anything you want. The AuthName field gives the Realm name for which the protection is provided. This name is usually given when a browser prompts for a password, and is also usually used by a browser in correlation with the URL to save the password information you enter so that it can authenticate automatically on the next challenge. 2. Use the htpasswd command, from your home directory, to create a password file called.htpasswd in your home directory: SSH to your home directory. This is simply done by connecting with your SSH client and NOT entering any path, and NOT changing directories after connecting. After connecting to your home directory via SSH, enter: # htpasswd -c .htpasswd memberone Type the password --memberonepassword-- twice as instructed. 3. That's the setup done. Now test by trying to access a file in the directorymembers; your browser should demand a username and password, and not give you access to the file if you don't entermemberoneandmemberonepassword. Multiple Usernames/Passwords If you want to give access to a directory to more than one username/password pair, follow the steps above to create the .htaccess file and to create the .htpasswd file with one user. Then, add additional users to the .htpasswd file by using thehtpasswdcommand without the-c: # htpasswd .htpasswd membertwo New password: Re-type new password: Adding password for user membertwo Changing Passwords If you want to change the password for an existing user, simply issue the same command as when you added the user. You will then be prompted for a new password. For example, if the user membertwo already exists and you want to change the password, just SSH to your home directory and enter: # htpasswd .htpasswd membertwo Password Protecting Multiple Directories If you want to password protect multiple directories, and allow all users access to all password protected directories, then all you need to do is put the same .htaccess file in each directory that you want to password protect. However, if you want to password protect multiple directories, and only allow certain users access to each directory, then you can create a different password file (all in your home directory) for each password protected directory. Let's say you have 3 different directories (members, admins, board) you want password protected, and each one has a different set of users that you want to allow access. Then just do the following: Create three .htaccess files and put them in their appropriate directory: AuthType Basic AuthName "Restricted access" AuthUserFile /home/USERNAME/.htpasswd.members require valid-user AuthType Basic AuthName "Restricted access" AuthUserFile /home/USERNAME/.htpasswd.admins require valid-user AuthType Basic AuthName "Restricted access" AuthUserFile /home/USERNAME/.htpasswd.board require valid-user Remember to replace USERNAME with your ftp username (in lower case). Create three .htpasswd files in your home directory:

Customize the Error pages via .htaccess full detail by jani

Tody i tell you

how to customize error or 404 page on your site

First make the error pages. They are just standard html pages, but the links (to images etc.) must be absolute and look like this: http://www.myDomain.com /mypost/theImage.gif When the error pages are uploaded you need to create an .htaccess file. Here is somevery important informationon how to create and upload an .htaccess file: *. The first problem you will run into is that your OS probably won't like a file name beginning with a dot. .htaccess files actually don't have names, just an extension!! *.The solution is simple, save the file ashtaccess.txtin GoLive and change the name to.htaccess(with the dot!) after you uploaded it. The extension .txt will force GoLive to upload the file in ASCII mode, exactly what we want! So, what should go into the .htaccess file? Here is an example: ErrorDocument 404 /errors/notfound.html ErrorDocument 401 /errors/authreqd.html ErrorDocument 500 /errors/internalerror.html ErrorDocument 403 /errors/forbid.html You can name the error pages whatever you like , just make sure that you connect the right document to the right error number, and that you don't use any special characters or spaces in the paths and file names. In the example above all the error pages are located in the folder "errors", the paths must be absolute (starting with the root "/"). When you created the .htaccess file you save it, upload it and change the file name like I mentioned earlier. The .htaccess file must be located in your root folder, since it only affects the folder where it's located and all sub folders. If you place the file further down the file structure the higher levels will not get your custom error pages. You don't need to create custom pages for all errors, if you just want a 404 the server will use the default pages for all other errors. The errors that you might want to cover are: *.400 - Bad request *.401 - Authorization Required *.403 - Forbidden *.404 - Not Found *.500 - Internal Server Error That's it!

how to update url when site moving one location to another

Tody i tell you

how to update url when move your site from one location to another

If you have ever had to move your site from one location to another you know how painful it is to go back and rewrite every link and URL to point to the new location. The Velvet Blues Plugin for WordPress will do exactly that. It allows you to input your new website URL and then it automatically updates every link in your blog. instructions, To get started, first you want to download the Velvet Blues Plugin. Once you have activated it go to the settings tab in your admin panel and select “update URLs”. You will then be shown a screen that allows you to type in your old website URL as well as your new website URL. Choose which URLs you would like to have updated and as soon as you press update URLs all of the links in your site that you selected will be modified. Although this saves a lot of time, you will still have to go back and manually change any links that are hardcoded. This is by far the easiest and effective solution that we know of that allows you to update your post URLs in WordPress when switching sites

what are the keyword and how it works

Tody i will teach you that

what are the keywords

Keywords are one of the components of website promotion. Creating a keyword list is one of the first step when you start promoting your website. The words that should be included into the list depend on website subject, their frequency and competitiveness. You can check frequency of a keyword with such service as Google Adwords. The list of keywords you get should be distributed between site pages, taking into account page rank - it is better to add more frequent keywords to pages with higher rank

what is meta tags how add them

What are the meta tags how to add them

Meta tags are tags that store information about a web page for browsers and search engines. With the help of meta tags web crawlers get info about the website, the keywords being used and other data. Correct content of meta tags is important for successful SEO promotion of a website. The main tags are keywords and description. Meta tags must be added between the tags< head >< /head >in the website templates. When adding meta tags, remember about the following rules: Include only the keywords that are used on the corresponding page of your website; Avoid repeating the same keywords; Make keywords and descriptions unique for each page

what is SMO FULL DETAIL BY JANI

Tody i will explain

what is SMO?

(Social Media Optimization) is a complex of measures of website optimization for social media. It includes various methods that allow to draw visitors from various social networks. This is achieved by posting website content to social media, integration with social plugins etc. uCoz has the following tools for working with social media: Social Bar- a bar on your website with the help of which visitors can easily like website content and share it to social media; Social Media Publisher– a module for automatic posting of website entries to selected social networks.

10 free websites where you create blog and start blogging

Tody i tell you 10 site where you can blogging Blog.com It’s free to start a blog here, and you’ll be able to choose from several gorgeous themes. You can also upgrade to their premium package and receive your own domain name. Blogger.com Perhaps one of the most well-known platforms, Blogger is backed by Google, so it’s trustworthy and reliable. It’s incredibly simple to start using Blogger as the site takes you step-by-step through creating your site. There are a lot of customization options and you can purchase templates through outside website as well. Penzu.com Penzu is loved because of it’s versatility: There are three different types of journals you can start when you sign up for the site: Daily Diary (public), Expressive Journal (private), and Travel Journal (great if you’re going on a trip). You can also try the site out before you sign up for it as well. Squarespace.com Defintiely the most creative, modern and professional of the 10 platforms, SquareSpace is the only pricey option but will surely deliver the best results. Amazing for photographers, store owners, bloggers, musicians and business owners, this platform features tons of templates that will keep your blog looking polished and professional. Price: 14-day free trial, then $8-$24/month based on your preference Svbtle.com A super-slick and modern platform, Svbtle feels more like a doodle pad. Tumblr.com Tumblr is easily the best of the 10 platforms when it comes to visuals. Images, videos, music—it’s all really easy to display on your tumblr profile. And, there are tons of creative ways that you can showcase them. People can also “reblog” your posts leaving you with more followers and a larger fanbase. Webs.co m This is a great platform to use if you’re looking to create more of a professional environment for your readers. You can drag and drop elements around your site for the ultimate customized page. The site also featured an ecommerce feature—great if you’re trying to sell a product. Price: Free Weebly.com Weebly features tons of unique and modern themes to start you blog off looking fresh. It also offers ecommerce, an iPhone app for posting on the go, and easy linking to your social media. This site is surely dummy-free and makes it as easy as possible for you to dive right into the blogging scene. Wix.com Wix features hundreds of unique and very professional-looking templates that can easily be customized to keep your blog unique and different from everyone else’s. You can also add apps onto your site as well as an online store and your links to your social media accounts. WordPress.com Another hugely popular platform, WordPress is super-flexible for anyone whether you’re a blogger who writes or a photographer who wants to show their portfolio. You can also upgrade and get your own domain name. Like Tumblr, other WordPress users can like, see, and reblog your posts leaving you with the potential for more followers and readers.

wix sites admin seo friendly meta tags advise with full detaill

Tody i teach you how to seo friendly meta tags create and update This information includes:

*.Title

*.Description

Page meta tags are given priority over site meta data. This allows you to choose a unique title and description for each page, relevant to the content of that page. Therefore, if you have filled in your home page meta tags, they will be displayed in Google search results. If the meta tags are deemed weak or incomplete, Google will choose the next most relevant content on the page to display, so make sure to fill these out fully, in accordance with the guidelines outlined in this tutorial. Wix submits your Meta tag data directly to Google. All you need to do is update the information within the Site Optimization area accessible within your editor. For pages that do not have a title and description filled in, the site meta tags will be used- available inSettings>SEO (Google).

Important Meta Tags Title:

Your Page Title is the headline of each page. It is not visible on your page but appears in the source code of the page, where it is visible to search engines. Both the page and site title appear in your browser bar. Once your site has loaded, the page title will be displayed, while the site title will be displayed in your browser bar while your site is loading. If the site title is blank, then the original site name will be displayed. If you do not want there to be any change in the browser bar when your site is loading, simply make the page and site titles identical. In Google and other search engines your Site Title is displayed as the headline of your site Search engines read your Page Title the same way we read the headline of a newspaper. Important points to keep in mind when writing your

Page Title:

*.The title must not exceed 70 characters, spaces included. *.Adding your business name to your title is a good idea. *.If you have a physical location or locations, include your city/state/county/suburb. *.Local information helps Search Engines to direct local users, attracting more visits from local searches. *.Try incorporating your most relevant search phrase into your title i.e. the word you think a client would type into a search engine to find your site. *.Make sure your title is easy to read and attractive - a relevant and descriptive title is more likely to ‘convince’ users to click it in search results. *.Use the pipe sign (|) to distinguish different parts in your title. Title example: Hair by Allan | Hairstylist in La Verne, Los Angeles

Description:

Description provides potential site visitors a summary of what your page is about. It is not visible on your site's page, but appears below your title in search results. Important points for writing your Description: *.Description should not be less than 50 characters or exceed 160 characters (Google trims the description after 160 characters), spaces included. *.Your Description is an opportunity to advertise your site pages. It allows a user to understand what your pages are about before they are accessed. *.If possible, try to incorporate your relevant search phrases logically and organically, as part of a description relevant to the page content. *.Make sure to create a compelling description in order to entice users to click. Keywords: The keyword meta tag fields, which can be entered in the both the page and site settings sections, are not considered by Google and other major search engines. As such, these tags do not affect the way your site is indexed and ranked. Instead, search engines assign value to the content added to your site pages. Despite their lack of importance for major search engines, if you are working with a service or a company that utilizes these keywords you are welcome to use them. You can add up to 15 keyword tags for your Wix site. Each keyword can be 1-4 words long. Click her how to wix sites meta tags update

how to submit blogger sitemap in yahoo and bing simply by jani

how to submit sitemap in yahoo and bing

I have receive many requests from my readers to publish a complete tutorial on how to submit blog sitemap in Bing. They told me that their blog posts are not getting index in Bing and Yahoo. That’s why today I bring this tutorial for all of you so that you can learn a best way to get all of your blog posts indexed in these search engines. Being indexed in all search engines increase our organic trafficthat is must for success of our blog. Before I told you how to get blog posts indexed, let’s first learn how to submit blog sitemap in Bing. How To Submit Blog Sitemap To Bing and Yahoo? There is no need to submit the blog sitemap in Yahoo. Submitting blog in BING will do the full job. Now let’s start the tutorial. 1.Go to Bing Webm aster Tools and log in with your Hotmail Account. 2.Add your blog URL and click on Add button at the top of the page. 3.Now copy the below code and paste into Add a Sitemap field on next page. http://www.yourblogname.com/atom.x ml?redirect=false&start-index=1&max-results=500 4.Click on Add Button. 5.Now you need to verify your blog ownership by adding Meta tag in your blog template. 6.Copy the meta tag and perform below steps: *.Go to Blogger > Template *.Find and paste meta tag *.Save the template *.You are done! 7.Now go back to your Bing Webmaster Tools page and click on Verify button. 8.If you have more than 500 published posts in your blog, then you must need to add more sitemaps. Go to your site dashboard in Bing Webmaster Tools and submit below sitemaps there. For Posts between 501 – 1000 http:// www.yourblogname.com/atom.xml?redirect=false&start-index=501&max-results=500 For Posts between 1001 – 1500 http:// www.yourblogname.com/atom.xml?redirect=false&start-index=1001&max-results=1500 Now you have successfully added your blog sitemap. It can take few days, usually 3 days, to get index your blog posts. Now your blog is ready to gain organic traffic from Bing and Yahoo. Congrats

How to ADD Meta Tags keywords,title and Description in Blogger simply

to add meta tags discription,keyword and tittle simply

: Adding Meta tags title, keywords and Description to your blog will increase your Google Page Rank.It is very important to add meta tags to your blogger blogs.It Helps you to increase your search results in Different Search Engines. Keywords,tittle and Description are the important meta tags for your blog. It is also a important part of SEO ( Search Engine Optimizatio n).It also attracts your visitors to easily define your blog. It also index your blog in different search engines like Yahoo/bing and Google. But the most important part is not to exceed limit of your meta tags.There is a limit of256 keywordsthat you can add to your blog but by increasing this limit there is a threat from Google to penalize you. Your Blog description should be in 140 to 155 characters.Your blog description should be matched with your posts and niche. You keywords should be also matched with your blog category. Steps to ADD Meta TagsTitle, Description and Keywords in Blogger Blogs?

Step 1:

First Go to your Blogger Dashboard.

Step 2:

Click on the Edit HTML button to extract your blog template.

Step 3:

Search for >b:include data='blog' name='all-head-content'/> by using Ctrl+F. Step 4:Copy the following code and paste the code below it. >meta content='BLOG DESCRIPTION HERE' name='description'/> >meta content='BLOG KEYWORDS HERE' name='keywords'/> note:1 first symbol > replace it < with

Note:

Make Changes: 1.Change'BLOG DESCRIPTION HERE'with your Blog Description. 2.Change 'BLOG KEYWORDS HERE' with your blog keywords #Now Save your Template All is done.