NodeXL Graph Gallery: Interactive Graph


Donate to the Social Media Research Foundation's NodeXL development fund

#SQLHelp Twitter NodeXL SNA Map and Report for Friday, 22 May 2020 at 17:11 UTC (experimental version)
NOTE: This version of the graph is not available with the browser you are using. A more recent version of the browser is required.
Zoom in Zoom out Reset the graph
Go to the graph's main page

From:
@SQLSocialite
Uploaded on:
May 22, 2020
Short Description:
#SQLHelp via NodeXL https://bit.ly/2XloO9h
@pshore73
@sqlha
@mrdenny
@jdanton
@pearlknows
@sqlmac
@therockstardba
@dbargenis
@tsql_simon
@claudioessilva

Top hashtags:
#sqlhelp
#sqlserver
#sqlfamily
#sql
#idera
#sqlsafe
#datascience
#codenewbies
#mdx
#cubes

Description:
Description
The graph represents a network of 117 Twitter users whose recent tweets contained "#SQLHelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 360 tweets. The network was obtained from Twitter on Friday, 22 May 2020 at 17:11 UTC.

The tweets in the network were tweeted over the 8-day, 3-hour, 39-minute period from Thursday, 14 May 2020 at 12:50 UTC to Friday, 22 May 2020 at 16:30 UTC.

Additional tweets that were mentioned in this data set were also collected from prior time periods. These tweets may expand the complete time period of the data.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

The graph is directed.

The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.

The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.


Author Description


Overall Graph Metrics
Vertices : 117
Unique Edges : 153
Edges With Duplicates : 101
Total Edges : 254
Number of Edge Types : 5
Replies to : 99
Tweet : 68
Mentions : 74
MentionsInRetweet : 1
Retweet : 12
Self-Loops : 68
Reciprocated Vertex Pair Ratio : 0.131147540983607
Reciprocated Edge Ratio : 0.231884057971014
Connected Components : 32
Single-Vertex Connected Components : 17
Maximum Vertices in a Connected Component : 60
Maximum Edges in a Connected Component : 193
Maximum Geodesic Distance (Diameter) : 7
Average Geodesic Distance : 3.052153
Graph Density : 0.0101679929266136
Modularity : 0.446289
NodeXL Version : 1.0.1.433
Data Import : The graph represents a network of 117 Twitter users whose recent tweets contained "#SQLHelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 360 tweets. The network was obtained from Twitter on Friday, 22 May 2020 at 17:11 UTC.

The tweets in the network were tweeted over the 8-day, 3-hour, 39-minute period from Thursday, 14 May 2020 at 12:50 UTC to Friday, 22 May 2020 at 16:30 UTC.

Additional tweets that were mentioned in this data set were also collected from prior time periods. These tweets may expand the complete time period of the data.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

Layout Algorithm : The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.
Graph Source : TwitterSearch
Graph Term : #SQLHelp
Groups : The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.
Edge Color : Edge Weight
Edge Width : Edge Weight
Edge Alpha : Edge Weight
Vertex Radius : Betweenness Centrality

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[2] https://wire19.com/steps-enhancing-sql-server-performance/
[1] https://blog.purestorage.com/what-is-sql-servers-io-block-size/
[1] https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-freeproccache-transact-sql?view=sql-server-ver15
[1] https://tenbulls.co.uk/2015/12/18/restoring-cdc-enabled-databases/
[1] https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability?view=sql-server-2017#CDC
[1] https://www.sqlskills.com/
[1] https://data.medicare.gov/
[1] https://www.sqlskills.com/blogs/paul/post/CHECKDB-From-Every-Angle-Consistency-Checking-Options-for-a-VLDB.aspx
[1] https://www.snia.org/sites/default/orig/SDC2012/presentations/SMB2-3/GunterZink_SQL_Server_App_Data.pdf
[1] https://www.meetup.com/B-BIG-Baltimore-Business-Intelligence-Group/events/wggcmrybchbbc/

Top URLs in Tweet in G1:
[1] https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability?view=sql-server-2017#CDC
[1] https://sqldbpool.com/2011/01/07/how-to-create-alias-in-sql-server/
[1] https://sqlserver.pro/how-to-fix-sql-server-management-studio-graphics-problem/

Top URLs in Tweet in G2:
[1] https://stackoverflow.com/questions/53047144/azure-sql-database-tls
[1] https://twitter.com/millennium_mary/status/1232954615794040832
[1] https://www.youtube.com/watch?v=U9IoCLiyiFE

[1] https://data.medicare.gov/

Top URLs in Tweet in G3:
[1] https://www.sqlskills.com/

Top URLs in Tweet in G4:
[1] https://www.sqlskills.com/blogs/paul/post/CHECKDB-From-Every-Angle-Consistency-Checking-Options-for-a-VLDB.aspx
[1] https://www.snia.org/sites/default/orig/SDC2012/presentations/SMB2-3/GunterZink_SQL_Server_App_Data.pdf
[1] https://lmgtfy.com/?q=How+to+setup+external+table+in+SQl+server+2016

Top URLs in Tweet in G5:
[1] https://tenbulls.co.uk/2015/12/18/restoring-cdc-enabled-databases/
[1] https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-freeproccache-transact-sql?view=sql-server-ver15
[1] https://blog.purestorage.com/what-is-sql-servers-io-block-size/

Top URLs in Tweet in G6:
[1] https://docs.microsoft.com/en-us/sql/t-sql/functions/current-timestamp-transact-sql?view=sql-server-ver15
[1] https://www.meetup.com/B-BIG-Baltimore-Business-Intelligence-Group/events/wggcmrybchbbc/
[1] https://gist.github.com/zaksoyer/1ff513e6af7d7e251f70a3aebdbafbc3

Top Domains
Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[174] sqlhelp
[10] sqlserver
[8] sqlfamily
[8] sql
[4] idera
[4] sqlsafe
[2] datascience
[2] codenewbies
[1] mdx
[1] cubes



Top Hashtags in Tweet in G1:
[46] sqlhelp
[1] veeam
[1] sqlfamily
[1] ssms

Top Hashtags in Tweet in G2:
[18] sqlhelp
[3] sqlserver
[1] sql
[1] sqlfamily
[1] dominoforever
[1] hclmaster
[1] hcldomino
[1] hclnotes
[1] sutolcz
[1] letsconnect

Top Hashtags in Tweet in G3:
[30] sqlhelp
[5] sqlserver
[3] sqlfamily
[2] sql
[1] database
[1] dataanalytics
[1] datascience
[1] nosql

Top Hashtags in Tweet in G4:
[29] sqlhelp
[1] datascience
[1] sqlespresso

Top Hashtags in Tweet in G5:
[13] sqlhelp

Top Hashtags in Tweet in G6:
[4] sqlhelp
[1] mdx
[1] cubes
[1] baltimore
[1] businessintelligence
[1] sqlfamily
[1] mvpbuzz
[1] sql

Top Hashtags in Tweet in G7:
[6] sqlhelp

Top Hashtags in Tweet in G8:
[7] sqlhelp
[4] idera
[4] sqlsafe
[1] powerbi

Top Hashtags in Tweet in G9:
[1] sqlhelp

Top Hashtags in Tweet in G10:
[1] sqlhelp

Top Words
Top Words in Tweet in Entire Graph:
[] Top Word Pairs in Tweet in Entire Graph
[] Entire Graph Count
[] Top Word Pairs in Tweet in G1

Top Words in Tweet in G1:
[47] #sqlhelp
[14] sql
[12] server
[9] same
[9] key
[8] license
[8] anyone
[7] mrdenny
[6] tsql_simon
[6] gavdraper

Top Words in Tweet in G2:
[18] #sqlhelp
[10] sql
[10] server
[7] repl
[5] know
[4] anyone
[3] data
[3] still
[3] pub
[3] ag

Top Words in Tweet in G3:
[31] #sqlhelp
[7] reorg
[6] sql
[6] one
[6] index
[5] pearlknows
[5] ag
[5] mrdenny
[5] #sqlserver
[4] query

Top Words in Tweet in G4:
[30] #sqlhelp
[11] sql
[9] use
[9] server
[8] data
[5] much
[5] sequeldba
[5] 2016
[4] jdanton
[4] 64k

Top Words in Tweet in G5:
[13] #sqlhelp
[4] sqlmac
[4] change
[4] read
[3] more
[3] many
[3] access
[3] sqlstudent144
[3] example
[2] make

Top Words in Tweet in G6:
[4] #sqlhelp
[2] purplefrogalex
[2] using

Top Words in Tweet in G7:
[7] #sqlhelp
[5] database
[4] secondary
[4] value
[3] sync
[3] sql
[3] server
[3] file
[3] size
[3] 2012

Top Words in Tweet in G8:
[8] told
[7] #sqlhelp
[5] compression
[4] know
[4] talk
[4] #idera
[4] #sqlsafe
[4] use
[4] work
[4] compress

Top Words in Tweet in G9:
[2] data

Top Words in Tweet in G10:
[2] azure

Top Word Pairs
Top Word Pairs in Tweet in G2:
[9] sql,server
[6] repl,pub
[5] azure,sql
[4] anyone,know
[4] srv2,repl
[4] repl,remote
[4] remote,dist
[3] dist,ag
[3] ag,srv3
[3] srv3,repl

Top Word Pairs in Tweet in G3:
[8] sqlrus,mrdenny
[3] full,scans
[2] highly,fragmented
[2] update,stats
[2] skip,reorg
[2] fill,factor
[2] #sqlhelp,#sqlfamily
[2] #sqlhelp,anyone
[2] anyone,issues
[2] issues,between

Top Word Pairs in Tweet in G4:
[3] sql,server
[2] server,2016
[2] jdanton,sequeldba
[2] oltp,workload
[2] sysjobschedules,sysjobactivity
[2] range,locks
[2] pshore73,sqlha
[2] sqlha,sqlrus
[2] sqlrus,mrdenny
[2] sql,db

Top Word Pairs in Tweet in G5:
[7] sequeldba,yes
[5] login,sa
[3] sa,access
[2] more,cumbersome
[2] read,replica

Top Word Pairs in Tweet in G6:

Top Word Pairs in Tweet in G7:
[] sql,server
[] file,size
[] anyone,seen
[] seen,before
[] before,'log
[] 'log,file
[] size,kb
[] kb,'
[] ',counter
[] counter,'dm_os_performance_counters'

Top Word Pairs in Tweet in G8:
[3] #sqlhelp,know
[3] know,talk
[2] talk,#idera
[2] #idera,#sqlsafe
[2] #sqlsafe,use
[2] use,work
[2] work,compress
[2] compress,backups
[2] backups,told
[2] told,magical

Top Word Pairs in Tweet in G9:

Top Replied-To
Top Replied-To in Entire Graph:
@pshore73
@mrdenny
@sqlmac
@sequeldba
@jdanton
@airbornegeek
@pearlknows
@sqlha
@awickham
@begintry

Top Replied-To in G1:
@mrdenny
@pshore73
@begintry
@awickham
@airbornegeek
@tsql_simon
@gratefuldba
@sqljuju
@reviewmydb
@sqlnick

Top Replied-To in G3:
@pearlknows
@mrdenny
@sqlha
@harshil_doshi
@sqljax
@absolutedba
@sqlmonkeynyc
@sqlrus
@sqlmac
@pshore73

Top Replied-To in G4:
@jdanton
@pshore73
@dbargenis
@sequeldba
@gbargsley
@paulrandal
@kevin3nf
@airbornegeek
@rickvanover
@sudhakarmandava

Top Replied-To in G5:
@sqlmac
@sequeldba
@joeannperderder
@sqljuju
@sozdba

Top Replied-To in G6:
@purplefrogsys
@realthepage

Top Replied-To in G7:
@claudioessilva
@therockstardba
@wsmelton

Top Replied-To in G8:
@tjaybelt

Top Mentioned
Top Mentioned in Entire Graph:
@mrdenny
@sqlrus
@gavdraper
@tsql_simon
@softcatsam
@stridergdm
@jdanton
@sequeldba
@sqlskills
@pluralsight

Top Mentioned in G1:
@gavdraper
@stridergdm
@jdanton
@tsql_simon
@softcatsam
@mrdenny
@sqlrus
@pshore73
@jdbacon13
@airbornegeek

Top Mentioned in G3:
@mrdenny
@sqlrus
@sqlskills
@pluralsight
@kevin3nf
@sql2thesequel
@mssqltips
@sqlservercentrl
@pearlknows

Top Mentioned in G4:
@mrdenny
@sequeldba
@sqlha
@sqlrus
@gbargsley
@tsql_simon
@gavdraper
@softcatsam
@naruto3650

Top Mentioned in G5:
@sqlstudent144

Top Mentioned in G6:
@purplefrogalex

Top Mentioned in G9:
@sqlgene
@cathrinew
@dannijuhl

Top Mentioned in G10:
@azure
@azuresupport

Top Tweeters
Top Tweeters in Entire Graph:
@codedailybot
@sql_handle
@jdanton
@azuresupport
@brento
@airbornegeek
@mrdenny
@sqlstudent144
@dbargenis
@e_nterdiscipl

Top Tweeters in G1:
@airbornegeek
@mrdenny
@sqlha
@_randolph_west
@nikoneugebauer
@cl
@johnsterrett
@begintry
@rondba
@dirkhondong

Top Tweeters in G2:
@a_bansal
@unclebiguns
@mjswart
@7_hyde_0
@skreebydba
@chrisavwood
@millennium_mary
@martinkenj
@jamie_wick
@weederbug

Top Tweeters in G3:
@sql_handle
@e_nterdiscipl
@pluralsight
@sqlservercentrl
@pshore73
@mssqltips
@pearlknows
@i_sophist
@kevin3nf
@harshil_doshi

Top Tweeters in G4:
@jdanton
@dbargenis
@rickvanover
@paulrandal
@kekline
@sequeldba
@gbargsley
@mehersql
@naruto3650
@sudhakarmandava

Top Tweeters in G5:
@sqlstudent144
@retracement
@sqlrus
@sqljuju
@joeannperderder
@sozdba
@sqlmac

Top Tweeters in G6:
@hugo_kornelis
@purplefrogalex
@realthepage
@purplefrogsys

Top Tweeters in G7:
@therockstardba
@claudioessilva
@wsmelton
@danielsilv9

Top Tweeters in G8:
@brento
@tjaybelt
@desertislesql
@sqlbyobi

Top Tweeters in G9:
@cathrinew
@sqlgene
@splaxi
@dannijuhl

Top Tweeters in G10:
@azuresupport
@azure
@sqlbi_anthony