SEO report of sqlserverindia.com

Redirected to sqlindia.com/

SQLINDIA.COM - SQL Server, SQL, TSQL, SSAS, SSIS, SSRS, DBA ...

sqlindia.com/

SQL INDIA is a SQL Server technical blog covering articles on SQL, TSQL, SSAS, SSIS, SSRS, Database Administration, Automation. Author - Prasad Sahoo


 Tasks

  • Avoid using deprecated HTML tags.

 SEO

URL

Domain : sqlindia.com/

Character length : 13

Title
SQLINDIA.COM - SQL Server, SQL, TSQL, SSAS, SSIS, SSRS, DBA, Performance Tuning
Description
SQL INDIA is a SQL Server technical blog covering articles on SQL, TSQL, SSAS, SSIS, SSRS, Database Administration, Automation. Author - Prasad Sahoo
Keywords (meta keywords)
Good! The website does not use “meta keywords”.
Open Graph Protocol

Good! The OG (Open Graph) protocol is set on this website.

locale: en_US
type: website
title: SQLINDIA.COM - A SQL SERVER INDIA BLOG
description: SQL INDIA is a SQL Server technical blog covering articles on SQL, TSQL, SSAS, SSIS, SSRS, Database Administration, Automation. Author - Prasad Sahoo
url: http://sqlindia.com/
site_name: SQLINDIA.COM
image: http://sqlindia.com/wp-content/uploads/2014/08/deviprasad-sahoo.png

Dublin Core
Dublin Core is not used
Underscores in the URLs
Search engine friendly URLs
Good! The website uses SEO friendly URLs.
Checking the robots.txt file
There is robots.txt file.
https://sqlindia.com/robots.txt
User-agentDisallowed for the search engines
*
  • /wp-admin/


 Social

Social Engagement

No info found.

 Content

Doctype
HTML 5
Encoding
Perfect! The character encoding is set: UTF-8.
Language
We have found the language localisation: ”en”.
Title
SQLINDIA.COM - SQL Server, SQL, TSQL, SSAS, SSIS, SSRS, DBA, Performance Tuning

Character length : 79

Improve! The website address (title) should be between 10 and 70 characters in length.
Text / HTML ratio
Ratio : 10%

Error! The text / HTML code ratio is under 15 percent on this website. This value shows that the website has relatively few text content.
Headings
H1H2H3H4H5H6
1219100
Heading structure in the source code
  • <H1> SQLINDIA.COM
  • <H4> 
  • <H2> New functions STRING_AGG() and CONCAT_WS() in Azure SQL
  • <H2> SQL Server 2016 edition comparison
  • <H2> Pivot – Rows into columns in SQL Server using R
  • <H2> Merry Christmas to the SQL family
  • <H2> How to check if a column exists in a table – SQL Server
  • <H2> How to generate Fibonacci Series in SQL Server
  • <H2> Dynamic ORDER BY in SQL Server using CASE WHEN
  • <H2> Performance impact between NVARCHAR(MAX) and NVARCHAR(100)
  • <H2> Capture TRUNCATE and DELETE events using Audit in SQL Server
  • <H2> Get column names of a table in comma delimited format
  • <H2> Convert columns into rows in SQL Server using VALUES and UNPIVOT
  • <H2> Decimal round off to 0.5 in SQL Server
  • <H2> How to convert decimal type hour minutes to time type in SQL Server
  • <H2> How to convert existing datetime into UTC in SQL Server
  • <H2> How to get date with ordinal numbers like 1st 2nd in SQL Server
  • <H2> How to search pdf contents in SQL Server
  • <H2> Database diagram support objects cannot be installed – FIXED
  • <H2> Find or Search a value in all SQL Server database tables
  • <H2> Correlated or Derived JOIN in SQL Server
  • <H2> SQL Server db_executor role to grant execute permission
  • <H2> How to execute stored procedure in excel with parameters
  • <H3> SQL Server newsletter
  • <H3> Recent Posts
  • <H3> Archives
  • <H3> Tags
  • <H3> 
  • <H3> SQLINDIA Feed
  • <H3> Useful Blogs
  • <H3> Useful Tools
  • <H3> Official Links
Word cloud
  • sql126
  • server79
  • tricks39
  • sahoo22
  • prasad22
  • read21
  • interview20
  • questions18
  • comment17
  • tsql14
  • how13
  • howto12
  • azure11
  • using10
  • dba10
  • performance9
  • tuning8
  • table8
  • into8
  • april8
  • september8
  • column8
  • october7
  • june7
  • march7
  • columns7
  • january7
  • script7
  • database6
  • best6
  • question6
  • admin6
  • step6
  • very6
  • microsoft6
  • system6
  • all6
  • practices6
  • july6
  • august6
  • functions6
  • tutorial6
  • christmas6
  • rows6
  • comparison6
  • new6
  • december5
  • data5
  • concat_ws5
  • objects5
  • search5
  • automation5
  • excel5
  • merry5
  • string_agg5
  • datetime4
  • convert4
  • procedure4
  • edition4
  • support4
Keyword matrix
wordtitledescriptionsheading
sql
server
tricks
sahoo
prasad
read
Two Word cloud
  • sql server30
  • prasad sahoo21
  • read more16
  • interview questions11
  • sql tricks10
  • server sql9
Three Word cloud
  • sql server sql6
  • sql server using4
  • server interview questions4
  • questions sql server4
  • read more interview3
  • server tricks tsql3
404 Page
The website has a 404 error page.
Flash content
Good! The website does not have any flash contents.
Frame
Error! The website uses iFrame solutions. This type of contents are not indexed by Google.
Images
We found 1 images on this web page.

Good! Every image has an alternative text attributes set on this website.

 Readability

Flesch–Kincaid Grade Level
5.40
Flesch Reading Ease
67.20
Coleman Liau Index
12.00
Automated Readability Index (ARI)
4.10
Dale–Chall Readability
8.40
SMOG Index
9.10
Spache Readibility
5.00
Number of letters
7579
Number of words
1594
Number of sentences
253
Average words per sentences
6
Number of syllables
2510
Syllables in words
2402
Average syllables in words
1.57
Number of words in first three syllables
266
Percentage of word / syllables
16.69
Words not in Dale-Chall easy-word list
813
Words not in Spache easy-word list
298

 Technologies

Mobile optimization
This website is optimal for mobile devices!
Deprecated HTML elements
Good! No deprecated HTML tags are detected.
Redirection (www / not www)
Good! The web address is accessible in only one version. The www version is redirected to the version without www.
Deprecated HTML elements
Good! No deprecated HTML tags are detected.
Printability
Suggestion! Unfortunately, no printer-friendly CSS found.
Meta Tag (viewport tag, mobile devices)
Error! The meta tag named viewport is missing.

 Speed test

Server response time
The server response time is fast enough.
Loading time
4,347 ms
Table layout
Good! No nested tables found.
Render blocking resources
Good! No render blocking elements found!

 Speed test – Javascript

Javascript
Error! Too many javascript files found which slows down the page load on the website.
  • http://sqlindia.com/wp-includes/js/jquery/jquery.js?ver=1.12.4
  • http://sqlindia.com/wp-includes/js/jquery/jquery-migrate.min.js?ver=1.4.1
  • http://sqlindia.com/wp-content/plugins/ultimate-form-builder-lite/js/jquery.selectbox-0.2.min.js?ver=1.2.5
  • http://sqlindia.com/wp-content/plugins/ultimate-form-builder-lite/js/frontend.js?ver=1.2.5
  • http://sqlindia.com/wp-content/themes/sqlindia/js/colormag-custom.js?ver=4.6.5
  • http://sqlindia.com/wp-content/themes/sqlindia/js/jquery.bxslider.min.js?ver=4.1.2
  • http://sqlindia.com/wp-content/themes/sqlindia/js/colormag-slider-setting.js?ver=4.6.5
  • http://sqlindia.com/wp-content/themes/sqlindia/js/navigation.js?ver=4.6.5
  • http://sqlindia.com/wp-content/themes/sqlindia/js/news-ticker/jquery.newsTicker.min.js?ver=1.0.0
  • http://sqlindia.com/wp-content/themes/sqlindia/js/news-ticker/ticker-setting.js?ver=20150304
  • http://sqlindia.com/wp-content/themes/sqlindia/js/sticky/jquery.sticky.js?ver=20150309
  • http://sqlindia.com/wp-content/themes/sqlindia/js/sticky/sticky-setting.js?ver=20150309
  • http://sqlindia.com/wp-content/themes/sqlindia/js/fitvids/jquery.fitvids.js?ver=20150311
  • http://sqlindia.com/wp-content/themes/sqlindia/js/fitvids/fitvids-setting.js?ver=20150311
  • http://sqlindia.com/wp-content/plugins/jetpack/_inc/facebook-embed.js
  • http://sqlindia.com/wp-content/plugins/jetpack/_inc/twitter-timeline.js?ver=4.0.0
  • http://sqlindia.com/wp-includes/js/wp-embed.min.js?ver=4.6.5
File size of all javascript files combined
0.00
Javascript minifying
Great! The Javascript files are minified.

 Speed test – CSS

CSS
Error! Too many CSS files detected that slows down the page load.
  • http://sqlindia.com/wp-content/plugins/ultimate-form-builder-lite/css/jquery.selectbox.css?ver=1.2.5
  • http://sqlindia.com/wp-content/plugins/ultimate-form-builder-lite/css/frontend.css?ver=1.2.5
  • http://sqlindia.com/wp-content/themes/sqlindia/style.css?ver=4.6.5
  • http://sqlindia.com/wp-content/themes/sqlindia/fontawesome/css/font-awesome.css?ver=4.2.1
  • http://sqlindia.com/wp-content/plugins/jetpack/css/jetpack.css?ver=4.3.1
File size of all css files combined
0.00
CSS minifying
Great! The CSS elements are minified.

 Speed test – Compression

Uncompressed size of the of the HTML
0.00
Gzip compression
Your site uses compression.

 Speed test – Browser cache

Browser cache
The browser cache is set correctly for all elements.

 Speed test – Images

File size of all images combined
0.00
Image optimisation
All images are optimized.

 Traffic

Alexa
2909435

Main traffic sources

 Links

We found a total of 211 different links.
Internal links: 182
External links: 29

External links:

Internal links:

Link text (anchor) Link strength

 Website security

IP
192.185.46.42
External hidden links
Good! No hidden external links found
Looking for eval()
Good! No eval(bas64_decode()) scripts are found
Checking for XSS vulnerability
No XSS vulnerability found
Email encryption
Good! We have not found any unencrypted email addresses.

 Sites on same ip

coloradowomanhealth.com

coloradowomanhealth.com

sqlserverindia.com

sqlserverindia.com

endlessincomesystem.com

endlessincomesystem.com

appliededucationfoundation.org

appliededucationfoundation.org

rosecolored.life

rosecolored.life

creditosrapidosnet.com

creditosrapidosnet.com

findgiftshop.net

findgiftshop.net

roseduncandesign.com

roseduncandesign.com

oakrenotech.ca

oakrenotech.ca

szilvasi-home.hu

szilvasi-home.hu

 Icons

Favicon
Error! No favicon is found. Using favicon helps to build a better brand quicker.

 Order of Heading elements on mobile by position

  • H3 : Menu, ( 0px from top )
  • H1 : SQLINDIA.COM, ( 141.796875px from top )
  • H2 : SQL Server, SQL, TSQL, SSAS, SSIS, SSRS, DBA, Performance Tuning, ( 172.796875px from top )
  • H1 : New functions STRING_AGG() and CONCAT_WS() in Azure SQL, ( 250.875px from top )
  • H1 : SQL Server 2016 edition comparison, ( 571.15625px from top )
  • H1 : Pivot – Rows into columns in SQL Server using R, ( 866.4375px from top )
  • H1 : Merry Christmas to the SQL family, ( 1161.71875px from top )
  • H1 : How to check if a column exists in a table – SQL Server, ( 1398px from top )

 Typos

qlserverindia.com, sqqlserverindia.com, qqlserverindia.com, swqlserverindia.com, wqlserverindia.com, seqlserverindia.com, eqlserverindia.com, szqlserverindia.com, zqlserverindia.com, sxqlserverindia.com, xqlserverindia.com, scqlserverindia.com, cqlserverindia.com, slserverindia.com, sqwlserverindia.com, swlserverindia.com, sqelserverindia.com, selserverindia.com, sqslserverindia.com, sslserverindia.com, sqalserverindia.com, salserverindia.com, sq1lserverindia.com, s1lserverindia.com, sq2lserverindia.com, s2lserverindia.com, sqserverindia.com, sqlpserverindia.com, sqpserverindia.com, sqloserverindia.com, sqoserverindia.com, sqlserverindia.com, sqserverindia.com, sqliserverindia.com, sqiserverindia.com, sqlkserverindia.com, sqkserverindia.com, sqlmserverindia.com, sqmserverindia.com, sql.serverindia.com, sq.serverindia.com, sqlerverindia.com, sqlsqerverindia.com, sqlqerverindia.com, sqlswerverindia.com, sqlwerverindia.com, sqlseerverindia.com, sqleerverindia.com, sqlszerverindia.com, sqlzerverindia.com, sqlsxerverindia.com, sqlxerverindia.com, sqlscerverindia.com, sqlcerverindia.com, sqlsrverindia.com, sqlsewrverindia.com, sqlswrverindia.com, sqlsesrverindia.com, sqlssrverindia.com, sqlserverindia.com, sqlsrverindia.com, sqlsedrverindia.com, sqlsdrverindia.com, sqlsefrverindia.com, sqlsfrverindia.com, sqlserrverindia.com, sqlsrrverindia.com, sqlse3rverindia.com, sqls3rverindia.com, sqlse4rverindia.com, sqls4rverindia.com, sqlseverindia.com, sqlsereverindia.com, sqlseeverindia.com, sqlserdverindia.com, sqlsedverindia.com, sqlserfverindia.com, sqlsefverindia.com, sqlsergverindia.com, sqlsegverindia.com, sqlser4,verindia.com, sqlse4,verindia.com, sqlsertverindia.com, sqlsetverindia.com, sqlser5verindia.com, sqlse5verindia.com, sqlsererindia.com, sqlserverindia.com, sqlsererindia.com, sqlservcerindia.com, sqlsercerindia.com, sqlservderindia.com, sqlserderindia.com, sqlservferindia.com, sqlserferindia.com, sqlservgerindia.com, sqlsergerindia.com, sqlservberindia.com, sqlserberindia.com, sqlserv erindia.com, sqlser erindia.com, sqlservrindia.com, sqlservewrindia.com, sqlservwrindia.com, sqlservesrindia.com, sqlservsrindia.com, sqlserverindia.com, sqlservrindia.com, sqlservedrindia.com, sqlservdrindia.com, sqlservefrindia.com, sqlservfrindia.com, sqlserverrindia.com, sqlservrrindia.com, sqlserve3rindia.com, sqlserv3rindia.com, sqlserve4rindia.com, sqlserv4rindia.com, sqlserveindia.com, sqlservereindia.com, sqlserveeindia.com, sqlserverdindia.com, sqlservedindia.com, sqlserverfindia.com, sqlservefindia.com, sqlservergindia.com, sqlservegindia.com, sqlserver4,india.com, sqlserve4,india.com, sqlservertindia.com, sqlservetindia.com, sqlserver5india.com, sqlserve5india.com, sqlserverndia.com, sqlserveriundia.com, sqlserverundia.com, sqlserverijndia.com, sqlserverjndia.com, sqlserverindia.com, sqlserverndia.com, sqlserverilndia.com, sqlserverlndia.com, sqlserveriondia.com, sqlserverondia.com, sqlserveri8ndia.com, sqlserver8ndia.com, sqlserveri9ndia.com, sqlserver9ndia.com, sqlserveri*ndia.com, sqlserver*ndia.com, sqlserveridia.com, sqlserverinbdia.com, sqlserveribdia.com, sqlserveringdia.com, sqlserverigdia.com, sqlserverinhdia.com, sqlserverihdia.com, sqlserverinjdia.com, sqlserverijdia.com, sqlserverinmdia.com, sqlserverimdia.com, sqlserverin dia.com, sqlserveri dia.com

More Sites

  • Title: lenovo-shop.pl
  • Description:
  • Internet Protocol (IP) address:
  • Tech:
    • CMS
      • Wordpress CMS
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Javascript
      • jQuery
      • Php (Hypertext Preprocessor)
      • Pingback
      • SVG (Scalable Vector Graphics)
  • Title: My Blog – My WordPress Blog
  • Description:
  • Internet Protocol (IP) address:
  • Tech:
    • CMS
      • Wordpress CMS
    • Other
      • CSS (Cascading Style Sheets)
      • Google Font API
      • Html (HyperText Markup Language)
      • Html5
      • Javascript
      • jQuery
      • Php (Hypertext Preprocessor)
      • Pingback
      • SVG (Scalable Vector Graphics)
  • Title: Lion Guard Security
  • Description: Installing Security Cameras in Your Home. Repairing Computer Issues. Schedule an Appointment.
  • Internet Protocol (IP) address:
  • Tech:
    • Analytic
      • Google Analytics
    • Other
      • CSS (Cascading Style Sheets)
      • Google Font API
      • Html (HyperText Markup Language)
      • Html5
      • Iframe
      • Javascript
  • Title: Holidayhouse-Capetown.co.uk
  • Description: Vakantiehuizen met allure in Kaapstad, Zuid Afrika, op loopafstand van het centrum.
  • Internet Protocol (IP) address:
  • Tech:
    • Other
      • Html (HyperText Markup Language)
      • Php (Hypertext Preprocessor)
  • Title: Work with Jessica Higdon
  • Description:
  • Internet Protocol (IP) address:
  • Tech:
    • CMS
      • Wordpress CMS
    • Analytic
      • Google Analytics
    • Other
      • AWeber
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Iframe
      • Javascript
      • jQuery
      • Php (Hypertext Preprocessor)
      • SuperFish
      • SVG (Scalable Vector Graphics)
  • Title: Sugam Elevators - Best Elevators for you
  • Description: Elevator & Escalator System for Duplex Flats, Apartments, Show Rooms, Multiplexes, Hospitals, Offices, Bungalows and Malls
  • Sites loading time: 9825
  • Internet Protocol (IP) address:
  • Javascript total size: 193.29KB
  • CSS total size: 111.33KB
  • Image total size: 1.11MB
  • Total size: 1.52MB
  • Tech:
    • CMS
      • Wordpress CMS
    • Other
      • CSS (Cascading Style Sheets)
      • Flexslider
      • Font Awesome
      • Google Font API
      • Html (HyperText Markup Language)
      • Html5
      • Javascript
      • jQuery
      • jQuery UI
      • Php (Hypertext Preprocessor)
      • Pingback
      • SVG (Scalable Vector Graphics)
  • Title: 身野晏壽のたいおうさく戦記
  • Description:
  • Internet Protocol (IP) address:
  • Tech:
    • CMS
      • Wordpress CMS
    • Other
      • CSS (Cascading Style Sheets)
      • Font Awesome
      • Html (HyperText Markup Language)
      • Html5
      • Javascript
      • jQuery
      • jQuery Cycle
      • Php (Hypertext Preprocessor)
      • Pingback
      • SVG (Scalable Vector Graphics)
  • Title: Transglobal Travel Services
  • Description: Operator of the Verena Hotels booking platform and a global provider of travel services.
  • Internet Protocol (IP) address:
  • Tech:
    • Analytic
      • Google Analytics
    • Other
      • CSS (Cascading Style Sheets)
      • Google Font API
      • Html (HyperText Markup Language)
      • Html5
      • Javascript
      • SVG (Scalable Vector Graphics)
  • Title: 朝隽建筑设计
  • Description: 朝隽建筑设计(CJ Design)是一家台湾综合性设计服务公司,专业从事商业影院、办公精装及高端别墅会所的室内设计等全方位的服务。公司集中了来自于台湾香港等设计团队以及本地优秀设计师。这样的综合性团队提供富于创造性和创新精神的设计作品,并提供全方位服务。
  • Internet Protocol (IP) address:
  • Tech:
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Javascript
  • Title: Oak Ridge Web Design | Website Design Oak Ridge | Web Design Oak Ridge | Design Pigeon Oak Ridge
  • Description: Tennessee Web Designer Web Designer in Tennessee Website Designer Tennessee Designer Tennessee Web
  • Internet Protocol (IP) address:
  • Tech:
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Javascript
      • Php (Hypertext Preprocessor)
      • Swf Object