WebsiteOutlook
Basic Information
Alexa Rank19952
PageRank4/10
Backlinks106
Page Authority48.48/100
Domain Authority56.04/100
Moz Rank4.08/10
Pageviews55.13K/ Day
Worth122.2K
Website Information
Title
Journey to SQL Authority with Pinal Dave | SQL, SQL Server, MySQL, Big Data and NoSQL
viewport
width=device-width
google-site-verification
OzU_5xIy7EG57tYokexMnIJ2C4BXOb1OIl7AVl9SiiQ
msvalidate.01
8F6DBB52BE58D7F617791A1BE13F446A
generator
WordPress.com
twitter:site
@wordpressdotcom
application-name
Journey to SQL Authority with Pinal Dave
msapplication-window
width=device-width;height=device-height
msapplication-tooltip
SQL, SQL Server, MySQL, Big Data and NoSQL
msapplication-task
name=WordPress.com Forums;action-uri=http://forums.wordpress.com/;icon-uri=http://s2.wp.com/i/favicon.ico
title
Journey to SQL Authority with Pinal Dave on WordPress.com
description
SQL, SQL Server, MySQL, Big Data and NoSQL
Important Html Tags
  • H1 6
  • H2 1
  • H3 13
  • H4 0
  • STRONG 9
  • A 120
  • IMG 6
Page Size
64.09Kb
Code to Text Ratio
28.41% (Text size 18.2Kb and Code size 45.88Kb)
Http Header
HTTP/1.1 301 Moved Permanently
Cache-Control: max-age=900
Content-Type: text/html
Location: http://sqlauthority.wordpress.com
Server: Microsoft-IIS/7.5
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
Date: Fri, 04 Sep 2015 05:16:43 GMT
Content-Length: 0
Age: 1
Connection: keep-alive

HTTP/1.1 301 Moved Permanently
Server: nginx
Date: Fri, 04 Sep 2015 05:16:44 GMT
Content-Type: text/html
Content-Length: 178
Connection: keep-alive
Location: https://sqlauthority.wordpress.com/
X-ac: 1.ord _dca

HTTP/1.1 301 Moved Permanently
Server: nginx
Date: Fri, 04 Sep 2015 05:16:44 GMT
Content-Type: text/html; charset=utf-8
Transfer-Encoding: chunked
Connection: keep-alive
Vary: Cookie
Location: http://blog.sqlauthority.com/
X-ac: 1.ord _dca

HTTP/1.1 200 OK
Server: nginx
Date: Fri, 04 Sep 2015 05:16:44 GMT
Content-Type: text/html; charset=UTF-8
Transfer-Encoding: chunked
Connection: keep-alive
Vary: Accept-Encoding
Last-Modified: Fri, 04 Sep 2015 05:16:38 GMT
Cache-Control: max-age=294, must-revalidate
X-nananana: Batcache
Vary: Cookie
X-hacker: If you're reading this, you should visit automattic.com/jobs and apply to join the fun, mention this header.
X-Pingback: http://blog.sqlauthority.com/xmlrpc.php
Link: ; rel=shortlink
X-ac: 1.ord _dca

SemRush Metrics
Semrush Rank29284Rank based on keywords, cost and organic traffic
Keywords7749Number of keywords in top 20 Google SERP
Organic Traffic35408Number of visitors coming from top 20 search results
Cost (in USD)57194How much need to spend if get same number of visitors from PPC ads
Keyword Analysis
KeywordPosition% traffickeyword costTraffic costQuery volumeResults
union vs union all12.520.000.001900182000000
sql interview questions111.609.279.21121003180000
login failed for user nt authority anonymous logon11.160.000.0088031000
sql authority11.080.000.004803530000
sql server interview questions21.060.000.0029001320000
sql server trim10.950.000.00720705000
msdtc on server is unavailable10.510.000.0039019000
pinal dave10.510.000.00390297000
sql not equal50.500.000.0036004120000
sql distinct110.470.000.0036009580000
string or binary data would be truncated40.470.000.002400180000
insert into select100.450.000.005400152000000
cannot open database requested by the login the login failed10.420.000.00320247000
sql convert varchar to int10.420.000.00320499000
joins in sql server10.4210.632.79320943000
candidate key30.400.000.00160025500000
sql pivot110.380.000.0029001220000
convert varchar to int10.340.000.00260466000
rowcount50.330.090.012400657000
sql update join30.330.000.00130016500000
sql concatenate110.310.000.002400963000
sql cast100.3014.182.6736002220000
showplan permission denied in database10.270.000.002101000
cannot open database requested by the login10.270.000.00210762000
sql count duplicates10.270.000.00210408000
invoke-sqlcmd20.260.000.0072058000
sql trim110.250.000.001900876000
case when sql110.2510.911.70190051700000
sql merge110.250.000.0019009000000
define primary90.240.000.002900301000000
sql insert multiple rows60.220.000.001600895000
sql server case60.220.000.00160019300000
sql import csv10.220.000.001701290000
trim sql server10.220.000.00170939000
dbcc checkident30.220.000.0088035000
trim in sql server10.220.000.00170677000
sql bulk insert30.220.000.00880643000
sql select into70.210.000.00190021100000
case statement110.210.050.001600101000000
sql server convert110.210.000.0016005710000
sql cte110.210.000.001600416000
union all110.210.000.001600187000000
dbcc shrinkfile110.210.000.00160068000
sql concatenate100.200.000.002400963000
data warehouse interview questions40.1914.981.831000702000
specified cast is not valid40.190.000.0010003810000
sql server 2012 download60.185.340.60130015700000
minus in sql server10.180.000.00140543000
install sql server 200810.184.450.511402860000
invalid floating point operation10.180.000.00140413000
Organic Competitor
WebsiteRankKeywordsTrafficCost (in USD)
mssqltips.com29918689634519148561
sqlteam.com7028039101222315914
sqlmag.com5548549011633255367
sqlservercentral.com5999850911486232238
simple-talk.com3805653402584465217
databasejournal.com4760552141972849307
sqlserverplanet.com119383142662823494
techonthenet.com308025810478955409488
brentozar.com973382047814328827
sql-server-helper.com1067581329724512763
Social Popularity
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
DNS Report
HostTypeClassTTLExtra
sqlauthority.comAIN3600ip: 184.168.221.28
sqlauthority.comNSIN86400target: pdns05.domaincontrol.com
sqlauthority.comNSIN86400target: pdns06.domaincontrol.com
sqlauthority.comSOAIN3600mname: pdns05.domaincontrol.com
rname: dns.jomax.net
serial: 2014090500
refresh: 28800
retry: 7200
expire: 604800
minimum-ttl: 600
sqlauthority.comMXIN3600pri: 10
target: mailstore1.secureserver.net
sqlauthority.comMXIN3600pri: 0
target: smtp.secureserver.net
sqlauthority.comTXTIN3600txt: google-site-verification=OzU_5xIy7EG57tYokexMnIJ2C4BXOb1OIl7AVl9SiiQ
entries: Array
IP Address Information
Server IP
184.168.221.28
Server Location
Scottsdale,AZ,United States
ISP
Location on MAP
Whois Record
	  [Querying whois.verisign-grs.com]
[Redirected to whois.godaddy.com]
[Querying whois.godaddy.com]
[whois.godaddy.com]
Domain Name: SQLAUTHORITY.COM
Registrar URL: http://www.godaddy.com
Registrant Name: Pinalkumar Dave
Registrant Organization:
Name Server: PDNS05.DOMAINCONTROL.COM
Name Server: PDNS06.DOMAINCONTROL.COM
DNSSEC: unsigned

For complete domain details go to:
http://who.godaddy.com/whoischeck.aspx?domain=SQLAUTHORITY.COM

The data contained in GoDaddy.com, LLC's WhoIs database,
while believed by the company to be reliable, is provided "as is"
with no guarantee or warranties regarding its accuracy.  This
information is provided for the sole purpose of assisting you
in obtaining information about domain name registration records.
Any use of this data for any other purpose is expressly forbidden without the prior written
permission of GoDaddy.com, LLC.  By submitting an inquiry,
you agree to these terms of usage and limitations of warranty.  In particular,
you agree not to use this data to allow, enable, or otherwise make possible,
dissemination or collection of this data, in part or in its entirety, for any
purpose, such as the transmission of unsolicited advertising and
and solicitations of any kind, including spam.  You further agree
not to use this data to enable high volume, automated or robotic electronic
processes designed to collect or compile this data for any purpose,
including mining this data for your own personal or commercial purposes.

Please note: the registrant of the domain name is specified
in the "registrant" section.  In most cases, GoDaddy.com, LLC
is not the registrant of domain names listed in this database.