Search Engine Optimization
Title Tag
John Huang's Blog – About SQL Server and Dot Net
Length: 48 character(s)
Length: 48 character(s)
Ideally, your title tag should contain between 10 and 70 characters (spaces included).
Make sure your title is explicit and contains your most important keywords.
Be sure that each page has a unique title.
Make sure your title is explicit and contains your most important keywords.
Be sure that each page has a unique title.
Meta Description
No Description
Length: 0 character(s)
Length: 0 character(s)
Meta descriptions contains between 100 and 300 characters (spaces included).
It allow you to influence how your web pages are described and displayed in search results.
Ensure that all of your web pages have a unique meta description that is explicit and contains your most important keywords (these appear in bold when they match part or all of the user's search query).
A good meta description acts as an organic advertisement, so use enticing messaging with a clear call to action to maximize click-through rate.
It allow you to influence how your web pages are described and displayed in search results.
Ensure that all of your web pages have a unique meta description that is explicit and contains your most important keywords (these appear in bold when they match part or all of the user's search query).
A good meta description acts as an organic advertisement, so use enticing messaging with a clear call to action to maximize click-through rate.
Meta Keywords
No Keywords
Meta Keywords are a specific type of meta tag that appear in the HTML code
of a Web page and help tell search engines what the topic of the page is.
However, google can't use meta keywords.
However, google can't use meta keywords.
Headings
| <H1> | <H2> | <H3> | <H4> | <H5> | <H6> |
|---|---|---|---|---|---|
| 1 | 10 | 3 | 0 | 0 | 0 |
| <H1> John Huang's Blog </H1> |
| <H2> Run T-SQL in Parallel </H2> |
| <H2> Get All Referenced Tables and Columns </H2> |
Use your keywords in the headings and make sure the first level (H1) includes your most important keywords. Never duplicate your title tag content in your header tag.
While it is important to ensure every page has an H1 tag, never include more than one per page. Instead, use multiple H2 - H6 tags.
While it is important to ensure every page has an H1 tag, never include more than one per page. Instead, use multiple H2 - H6 tags.
Google Preview
John Huang's Blog – About SQL Server and Dot Net
sqlnotes.info/
No Description
This is an example of what your Title Tag and Meta Description will look like in Google search results.
While Title Tags & Meta Descriptions are used to build the search result listings, the search engines may create their own if they are missing, not well written, or not relevant to the content on the page.
Title Tags and Meta Descriptions are cut short if they are too long, so it's important to stay within the suggested character limits.
While Title Tags & Meta Descriptions are used to build the search result listings, the search engines may create their own if they are missing, not well written, or not relevant to the content on the page.
Title Tags and Meta Descriptions are cut short if they are too long, so it's important to stay within the suggested character limits.
Alt Attribute
We found 8 images on this web page
8 ALT attributes are empty or missing.
8 ALT attributes are empty or missing.
| http://www.sqlnotes.info/SharedFiles/JohnH.png |
| http://www.sqlnotes.info/SharedFiles/cert-mstr-SQL08_rgb.png |
| http://www.sqlnotes.info/SharedFiles/mvp_horizontal_fullcolor_small.png |
Alternative text is used to describe images to give the search engine crawlers (and the visually impaired).
Also, more information to help them understand images, which can help them to appear in Google Images search results.
Also, more information to help them understand images, which can help them to appear in Google Images search results.
Keywords Cloud
- server22
- john12
- posted10
- reading7
- continue7
- responses7
- have7
- will6
- database6
- dbcc5
- t-sql4
- those4
- about4
- sqlserver4
- last4
This Keyword Cloud provides an insight into the frequency of keyword usage within the page.
It's important to carry out keyword research to get an understanding of the keywords that your audience is using. There are a number of keyword research tools available online to help you choose which keywords to target.
It's important to carry out keyword research to get an understanding of the keywords that your audience is using. There are a number of keyword research tools available online to help you choose which keywords to target.
Keyword Consistency
This table highlights the importance of being consistent with your use of keywords.
To improve the chance of ranking well in search results for a specific keyword, make sure you include it in some or all of the following: page URL, page content, title tag, meta description, header tags, image alt attributes, internal link anchor text and backlink anchor text.
To improve the chance of ranking well in search results for a specific keyword, make sure you include it in some or all of the following: page URL, page content, title tag, meta description, header tags, image alt attributes, internal link anchor text and backlink anchor text.
Text/HTML Ratio
HTML to Text Ratio is: 18.56%
| Text content size | 9352 bytes |
| Total HTML size | 50377 bytes |
Code to text ratio represents the percentage of actual text on a web page compared to the percentage of
HTML code, and it is used by search engines to calculate the relevancy of a web page.
A higher code to text ratio will increase your chances of getting a better rank in search engine results.
A higher code to text ratio will increase your chances of getting a better rank in search engine results.
GZIP compression
Wow! It's GZIP Enabled.
Your webpage is compressed from 49 KB to 12 KB (74.7 % size savings)
Your webpage is compressed from 49 KB to 12 KB (74.7 % size savings)
Gzip is a method of compressing files (making them smaller) for faster network transfers.
It allows to reduce the size of web pages and any other typical web files to about 30% or less of its original size before it transfer.
It allows to reduce the size of web pages and any other typical web files to about 30% or less of its original size before it transfer.
WWW Resolve
Great, a redirect is in place to redirect traffic from your non-preferred domain.
Redirecting requests from a non-preferred domain is important because search engines consider URLs with and without "www" as two different websites.
IP Canonicalization
No your domain IP 74.208.236.22 does not redirect to sqlnotes.info
To check this for your website, enter your IP address in the browser and see if your site loads with the IP address.
Ideally, the IP should redirect to your website's URL or to a page from your website hosting provider.
If it does not redirect, you should do an htaccess 301 redirect to make sure the IP does not get indexed.
Ideally, the IP should redirect to your website's URL or to a page from your website hosting provider.
If it does not redirect, you should do an htaccess 301 redirect to make sure the IP does not get indexed.
XML Sitemap
A sitemap lists URLs that are available for crawling and can include additional information like your site's latest updates, frequency of changes and importance of the URLs. This allows search engines to crawl the site more intelligently.
We recommend that you generate an XML sitemap for your website and submit it to both Google Search Console and Bing Webmaster Tools. It is also good practice to specify your sitemap's location in your robots.txt file.
We recommend that you generate an XML sitemap for your website and submit it to both Google Search Console and Bing Webmaster Tools. It is also good practice to specify your sitemap's location in your robots.txt file.
Robots.txt
A robots.txt file allows you to restrict the access of search engine robots that crawl the web and it can prevent these robots from accessing specific directories and pages. It also specifies where the XML sitemap file is located.
You can check for errors in your robots.txt file using Google Search Console (formerly Webmaster Tools) by selecting 'Robots.txt Tester' under 'Crawl'. This also allows you to test individual pages to make sure that Googlebot has the appropriate access.
You can check for errors in your robots.txt file using Google Search Console (formerly Webmaster Tools) by selecting 'Robots.txt Tester' under 'Crawl'. This also allows you to test individual pages to make sure that Googlebot has the appropriate access.
URL Rewrite
Good, all URLs look clean and friendly
Your site's URLs contain unnecessary elements that make them look complicated.
A URL must be easy to read and remember for users. Search engines need URLs to be clean and include your page's most important keywords.
Clean URLs are also useful when shared on social media as they explain the page's content.
A URL must be easy to read and remember for users. Search engines need URLs to be clean and include your page's most important keywords.
Clean URLs are also useful when shared on social media as they explain the page's content.
Underscores in the URLs
Great, you are not using underscores (these_are_underscores) in your URLs
Great, you are not using ?underscores (these_are_underscores) in your URLs.
While Google treats hyphens as word separators, it does not for underscores.
While Google treats hyphens as word separators, it does not for underscores.
Embedded Objects
Perfect, no embedded objects has been detected on this page
Embedded Objects such as Flash. It should only be used for specific enhancements.
Although Flash content often looks nicer, it cannot be properly indexed by search engines.
Avoid full Flash websites to maximize SEO.
Although Flash content often looks nicer, it cannot be properly indexed by search engines.
Avoid full Flash websites to maximize SEO.
Iframe
Perfect, no Iframe content has been detected on this page
Frames can cause problems on your web page because search engines will not crawl or index the content within them.
Avoid frames whenever possible and use a NoFrames tag if you must use them.
Avoid frames whenever possible and use a NoFrames tag if you must use them.
Domain Registration
Exactly how many years and months
Domain Age: Not Available
Created Date: Not Available
Updated Date: Not Available
Expiry Date: Not Available
Domain age matters to a certain extent and newer domains generally struggle to get indexed and rank high in search results for their first few months (depending on other associated ranking factors). Consider buying a second-hand domain name.
Do you know that you can register your domain for up to 10 years? By doing so, you will show the world that you are serious about your business.
Do you know that you can register your domain for up to 10 years? By doing so, you will show the world that you are serious about your business.
WHOIS Data
WhoIs domain information can help you determine the proper administrator, billing and technical
contact information.
contact information.
| WHOIS LIMIT EXCEEDED |
WhoIs domain information can help you determine the proper contact for any domain listed in the Whois database.
A WhoIs lookup identifies the administrator contact information, billing contact and the technical contact for each domain name listing or IP in the WhoIs database.
A WhoIs lookup identifies the administrator contact information, billing contact and the technical contact for each domain name listing or IP in the WhoIs database.
Indexed Pages
Indexed pages in search engines
This is the number of pages that we have discovered on your website.
A low number can indicate that bots are unable to discover your webpages, which is a common cause of a bad site architecture & internal linking, or you're unknowingly preventing bots and search engines from crawling & indexing your pages.
A low number can indicate that bots are unable to discover your webpages, which is a common cause of a bad site architecture & internal linking, or you're unknowingly preventing bots and search engines from crawling & indexing your pages.
Backlinks Counter
Number of backlinks to your website
Backlinks are links that point to your website from other websites. They are like letters of recommendation for your site.
Since this factor is crucial to SEO, you should have a strategy to improve the quantity and quality of backlinks.
Since this factor is crucial to SEO, you should have a strategy to improve the quantity and quality of backlinks.
Usability
URL
http://sqlnotes.info
Length: 8 characters
Length: 8 characters
Keep your URLs short and avoid long domain names when possible.
A descriptive URL is better recognized by search engines.
A user should be able to look at the address bar and make an accurate guess about the content of the page before reaching it (e.g., http://www.mysite.com/en/products).
A descriptive URL is better recognized by search engines.
A user should be able to look at the address bar and make an accurate guess about the content of the page before reaching it (e.g., http://www.mysite.com/en/products).
Favicon
Favicons improve a brand's visibility.
As a favicon is especially important for users bookmarking your website, make sure it is consistent with your brand.
As a favicon is especially important for users bookmarking your website, make sure it is consistent with your brand.
Custom 404 Page
Great, your website has a custom 404 error page.
When a visitor encounters a 404 File Not Found error on your site, you're on the verge of losing the visitor that you've worked so hard to obtain through the search engines and third party links.
Creating your custom 404 error page allows you to minimize the number of visitors lost that way.
Creating your custom 404 error page allows you to minimize the number of visitors lost that way.
Page Size
49 KB (World Wide Web average is 320 Kb)
Two of the main reasons for an increase in page size are images and JavaScript files.
Page size affects the speed of your website; try to keep your page size below 2 Mb.
Tip: Use images with a small size and optimize their download with gzip.
Page size affects the speed of your website; try to keep your page size below 2 Mb.
Tip: Use images with a small size and optimize their download with gzip.
Load Time
1.2 second(s)
Site speed is an important factor for ranking high in Google search results and enriching the user experience.
Resources: Check out Google's developer tutorials for tips on how to to make your website run faster.
Resources: Check out Google's developer tutorials for tips on how to to make your website run faster.
PageSpeed Insights (Desktop)
84 / 100
Page Speed
Sqlnotes.info desktop website speed is fast. Page speed is important for both search engines and visitors end.
Enter your suggestion box message
Language
Good, you have declared your language
Declared Language: EN-US
Declared Language: EN-US
Make sure your declared language is the same as the language detected by Google
Also, define the language of the content in each page's HTML code.
Also, define the language of the content in each page's HTML code.
Domain Availability
| Domains (TLD) | Status |
|---|---|
| sqlnotes.com | Already Registered |
| sqlnotes.net | Already Registered |
| sqlnotes.org | Available |
| sqlnotes.biz | Already Registered |
| sqlnotes.us | Already Registered |
Register the various extensions of your domain to protect your brand from cybersquatters.
Typo Availability
| Domains (TLD) | Status |
|---|---|
| qqlnotes.info | Already Registered |
| wqlnotes.info | Already Registered |
| eqlnotes.info | Already Registered |
| zqlnotes.info | Already Registered |
| xqlnotes.info | Already Registered |
Register the various typos of your domain to protect your brand from cybersquatters.
Email Privacy
Email address has been found in plain text!
We don't recommend adding plain text/linked email addresses to your webpages.
As malicious bots scrape the web in search of email addresses to spam. Instead, consider using a contact form.
As malicious bots scrape the web in search of email addresses to spam. Instead, consider using a contact form.
Safe Browsing
Something went wrong on the server. Please try again.
Safe Browsing to identify unsafe websites and notify users and webmasters so they can protect themselves from harm.
Mobile
Mobile View
The number of people using the Mobile Web is huge; over 75 percent of consumers have access to smartphones. ??
Your website should look nice on the most popular mobile devices.
Tip: Use an analytics tool to track mobile usage of your website.
Your website should look nice on the most popular mobile devices.
Tip: Use an analytics tool to track mobile usage of your website.
Mobile Compatibility
Perfect, no embedded objects detected.
Embedded Objects such as Flash, Silverlight or Java. It should only be used for specific enhancements.
But avoid using Embedded Objects, so your content can be accessed on all devices.
But avoid using Embedded Objects, so your content can be accessed on all devices.
Technologies
Server IP
| Server IP | Server Location | Service Provider |
|---|---|---|
| 74.208.236.22 | Not Available | Not Available |
Your server's IP address has little impact on your SEO. Nevertheless, try to host your website on a server which is geographically close to your visitors.
Search engines take the geolocation of a server into account as well as the server speed.
Search engines take the geolocation of a server into account as well as the server speed.
Analytics
Perfect, We detect an analytics tool installed on this website.
Web analytics let you measure visitor activity on your website.
You should have at least one analytics tool installed, but It can also be good to install a second in order to cross-check the data.
You should have at least one analytics tool installed, but It can also be good to install a second in order to cross-check the data.
W3C Validity
W3C not validated
W3Cis a consortium that sets web standards.
Using valid markup that contains no errors is important because syntax errors can make your page difficult for search engines to index. Run the W3C validation service whenever changes are made to your website's code.
Using valid markup that contains no errors is important because syntax errors can make your page difficult for search engines to index. Run the W3C validation service whenever changes are made to your website's code.
Doc Type
Your Web Page doctype is HTML 5
The Doctype is used to instruct web browsers about the document type being used.
For example, what version of HTML the page is written in.
Declaring a doctype helps web browsers to render content correctly.
For example, what version of HTML the page is written in.
Declaring a doctype helps web browsers to render content correctly.
Encoding
Great, language/character encoding is specified: UTF-8
Specifying language/character encoding can prevent problems with the rendering of special characters.
Visitors
Estimated Worth
$336 USD
Just a estimated worth of your website based on Alexa Rank.
Traffic Rank
6,335,277th most visited website in the World.
A low rank means that your website gets a lot of visitors.
Your Alexa Rank is a good estimate of the worldwide traffic to your website, although it is not 100 percent accurate.
Your Alexa Rank is a good estimate of the worldwide traffic to your website, although it is not 100 percent accurate.
Link Analysis
In-Page Links
We found a total of 83 links including both internal & external links of your site
| Anchor | Type | Follow |
|---|---|---|
| John Huang's Blog | Internal Links | Dofollow |
| Downloads | Internal Links | Dofollow |
| About Me | Internal Links | Dofollow |
| About My Posts | Internal Links | Dofollow |
| Contact Me | Internal Links | Dofollow |
While there's no exact limit to the number of links you should include on a page, best practice is to avoid exceeding 200 links.
Links pass value from one page to another, but the amount of value that can be passed is split between all of the links on a page. This means that adding unnecessary links will dilute the potential value attributed to your other links.
Using the Nofollow attribute prevents value from being passed to the linking page, but it's worth noting that these links are still taken into account when calculating the value that is passed through each link, so Nofollow links can also dilute pagerank.
Links pass value from one page to another, but the amount of value that can be passed is split between all of the links on a page. This means that adding unnecessary links will dilute the potential value attributed to your other links.
Using the Nofollow attribute prevents value from being passed to the linking page, but it's worth noting that these links are still taken into account when calculating the value that is passed through each link, so Nofollow links can also dilute pagerank.
Broken Links
Broken links were found on this web page
| http://www.sqlnotes.info/en |
Broken links send users to non-existing web pages. They are bad for your site's usability, reputation and SEO. If you find broken links in the future, take the time to replace or remove each one.
Social
Social Data
Cost and overhead previously rendered this semi-public form of communication unfeasible.
But advances in social networking technology from 2004-2010 has made broader concepts of sharing possible.