WebsiteOutlook
Basic Information
Alexa Rank20725
PageRank4/10
Backlinks41
Page Authority45.38/100
Domain Authority49.82/100
Moz Rank3.87/10
Pageviews53.08K/ Day
Worth117.7K
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 12
  • H4 0
  • STRONG 12
  • A 113
  • IMG 7
Page Size
64.06Kb
Code to Text Ratio
30.65% (Text size 19.63Kb and Code size 44.42Kb)
Http Header
HTTP/1.1 302 Found
Connection: close
Pragma: no-cache
cache-control: no-cache
Location: /

HTTP/1.1 302 Found
Connection: close
Pragma: no-cache
cache-control: no-cache
Location: /

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: Sun, 28 Jun 2015 08:12:39 GMT
Content-Length: 0
Age: 1
Connection: keep-alive

HTTP/1.1 301 Moved Permanently
Server: nginx
Date: Sun, 28 Jun 2015 08:12:40 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: Sun, 28 Jun 2015 08:12:40 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: Sun, 28 Jun 2015 08:12:40 GMT
Content-Type: text/html; charset=UTF-8
Transfer-Encoding: chunked
Connection: keep-alive
Vary: Accept-Encoding
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
Last-Modified: Sun, 28 Jun 2015 08:12:40 GMT
Cache-Control: max-age=300, must-revalidate
X-nananana: Batcache
X-ac: 1.ord _dca

SemRush Metrics
Semrush Rank28761Rank based on keywords, cost and organic traffic
Keywords7872Number of keywords in top 20 Google SERP
Organic Traffic35182Number of visitors coming from top 20 search results
Cost (in USD)69160How much need to spend if get same number of visitors from PPC ads
Keyword Analysis
KeywordPosition% traffickeyword costTraffic costQuery volumeResults
union vs union all12.530.000.001900172000000
sql authority11.090.000.004804670000
powershell commands41.074.092.235400695000
sql server trim10.960.000.00720702000
sql interview questions100.843.401.4699002680000
sql server interview questions30.7427.4810.3729001700000
pinal dave10.640.000.00480288000
maxdop10.640.000.0048052000
select distinct110.580.000.00440020900000
cannot open database requested by the login the login failed10.520.000.00390274000
msdtc on server is unavailable10.520.000.0039023000
sql not equal50.510.000.0036002530000
insert into select100.460.000.005400144000000
sql convert varchar to int10.420.000.003206470000
joins in sql server10.426.731.46320976000
candidate key30.400.000.00160021200000
carriage return100.070.000.0044004630000
convert varchar to int10.340.000.00260489000
sql server joins10.349.681.71260938000
rowcount50.340.060.012400653000
string or binary data would be truncated50.340.000.002400177000
sql update join30.330.000.00130013100000
datediff sql110.320.000.002400428000
sqlcmd100.300.180.023600398000
showplan permission denied in database10.280.000.002101000
enable identity insert10.280.000.0021026400000
sql last day of month10.280.000.002102570000
invoke-sqlcmd20.260.000.0072052000
left join vs left outer join40.250.000.0013001300000
data warehouse interview questions30.2511.381.481000680000
sql select into110.250.000.0019009660000
sql case statement100.2415.942.0029001530000
sql pivot100.244.540.572900910000
sql if100.240.280.032900121000000
sql insert multiple rows50.220.000.001600885000
sql import csv10.222.950.34170883000
trim sql server10.220.000.001701080000
sql server database in recovery10.2226.753.091702690000
bulk insert csv10.220.000.00170212000
cannot open database requested by the login10.220.000.00170843000
sql convert to int10.220.000.00170883000
sql count duplicates10.220.000.00170413000
sql server import csv10.220.000.00170768000
dbcc checkident30.220.000.0088033000
sql server case statement30.220.000.00880970000
line feed20.210.000.00590216000000
sql server rename column20.210.000.00590494000
sql insert into select70.210.000.00190011400000
case when sql110.2113.561.47160049900000
sql cursor80.200.000.0024001520000
Organic Competitor
WebsiteRankKeywordsTrafficCost (in USD)
mssqltips.com30803700932170122267
sqlteam.com6722340291255923614
sqlmag.com5627050501557347684
sqlservercentral.com5846553201488233279
simple-talk.com3860255892459665197
databasejournal.com4967153491813049401
sqlserverplanet.com121327133359753033
techonthenet.com281324618508924430249
brentozar.com1010282140753326495
sql-server-helper.com1063871269706016141
Social Popularity
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
DNS Report
HostTypeClassTTLExtra
sqlauthority.comAIN3600ip: 184.168.221.28
sqlauthority.comNSIN86400target: pdns06.domaincontrol.com
sqlauthority.comNSIN86400target: pdns05.domaincontrol.com
sqlauthority.comSOAIN3600mname: pdns05.domaincontrol.com
rname: dns.jomax.net
serial: 2014090500
refresh: 28800
retry: 7200
expire: 604800
minimum-ttl: 600
sqlauthority.comMXIN3600pri: 0
target: smtp.secureserver.net
sqlauthority.comMXIN3600pri: 10
target: mailstore1.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.