#sqlpass #sqlfamily, Twitter, 12/28/2020 8:13:57 AM, 244226


FAQ | Problem?

#sqlpass #sqlfamily Twitter NodeXL SNA Map and Report for Monday, 28 December 2020 at 08:13 UTC
#sqlpass #sqlfamily Twitter NodeXL SNA Map and Report for Monday, 28 December 2020 at 08:13 UTC
From:
@SQLSocialite
Uploaded on:
December 28, 2020
Short Description:
#sqlpass #sqlfamily via NodeXL https://bit.ly/2KICJ7d
@sqlworldwide
@way0utwest
@sqlmal
@sqlsuperguru
@jenstirrup
@sqldataclouduk
@flyingcod
@sqlbek
@volkerbachmann
@spaghettidba

Top hashtags:
#sqlpass
#sqlfamily
#sqlserver
#pass
#mvpbuzz
#sqlbits
#dba
#datasaturdays

Description:
Description
The graph represents a network of 49 Twitter users whose recent tweets contained "#sqlpass #sqlfamily", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Monday, 28 December 2020 at 08:13 UTC.

The tweets in the network were tweeted over the 4-day, 4-hour, 26-minute period from Sunday, 20 December 2020 at 13:07 UTC to Thursday, 24 December 2020 at 17:33 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 : 49
Unique Edges : 70
Edges With Duplicates : 2
Total Edges : 72
Number of Edge Types : 5
Replies to : 3
Mentions : 16
Retweet : 27
Tweet : 5
MentionsInRetweet : 21
Self-Loops : 5
Reciprocated Vertex Pair Ratio : 0.0153846153846154
Reciprocated Edge Ratio : 0.0303030303030303
Connected Components : 6
Single-Vertex Connected Components : 2
Maximum Vertices in a Connected Component : 31
Maximum Edges in a Connected Component : 54
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 2.894294
Graph Density : 0.0280612244897959
Modularity : 0.662953
NodeXL Version : 1.0.1.441
Data Import : The graph represents a network of 49 Twitter users whose recent tweets contained "#sqlpass #sqlfamily", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Monday, 28 December 2020 at 08:13 UTC.

The tweets in the network were tweeted over the 4-day, 4-hour, 26-minute period from Sunday, 20 December 2020 at 13:07 UTC to Thursday, 24 December 2020 at 17:33 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 : #sqlpass #sqlfamily
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:
[15] https://twitter.com/DBAVUG/status/1341044559825006592
[7] https://spaghettidba.com/2020/12/18/sqlsaturday-is-dead-long-live-datasaturdays/
[3] https://twitter.com/AzureSQL/status/1341559409189683203
[2] https://twitter.com/SQLGene/status/1341376922631229442
[1] https://twitter.com/sqlserver/status/1341545267863142405

Top URLs in Tweet in G1:
[13] https://twitter.com/DBAVUG/status/1341044559825006592
[2] https://twitter.com/SQLGene/status/1341376922631229442

Top URLs in Tweet in G2:
[1] https://twitter.com/DBAVUG/status/1341044559825006592

Top URLs in Tweet in G3:
[7] https://spaghettidba.com/2020/12/18/sqlsaturday-is-dead-long-live-datasaturdays/

Top URLs in Tweet in G4:
[1] https://twitter.com/DBAVUG/status/1341044559825006592

Top URLs in Tweet in G6:
[3] https://twitter.com/AzureSQL/status/1341559409189683203

Top URLs in Tweet in G7:
[1] https://twitter.com/sqlserver/status/1341545267863142405

Top Domains
Top Domains in Tweet in Entire Graph:
[21] twitter.com
[7] spaghettidba.com

Top Domains in Tweet in G1:
[15] twitter.com

Top Domains in Tweet in G2:
[1] twitter.com

Top Domains in Tweet in G3:
[7] spaghettidba.com

Top Domains in Tweet in G4:
[1] twitter.com

Top Domains in Tweet in G6:
[3] twitter.com

Top Domains in Tweet in G7:
[1] twitter.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[40] sqlpass
[40] sqlfamily
[22] sqlserver
[7] pass
[7] mvpbuzz
[4] sqlbits
[3] dba
[3] datasaturdays
[3] database
[3] dataplatform



Top Hashtags in Tweet in G1:
[15] sqlfamily
[15] sqlpass
[13] sqlserver
[3] dba
[3] datasaturdays
[3] database
[3] dataplatform

Top Hashtags in Tweet in G2:
[7] sqlfamily
[7] sqlpass
[4] sqlbits
[1] sqlserver

Top Hashtags in Tweet in G3:
[9] sqlfamily
[9] sqlpass
[7] sqlserver
[7] pass
[7] mvpbuzz

Top Hashtags in Tweet in G4:
[3] sqlpass
[3] sqlfamily
[1] summit2019
[1] sqlsatstl
[1] slu
[1] sqlserver

Top Hashtags in Tweet in G5:
[1] sqlpass
[1] sqlfamily

Top Hashtags in Tweet in G6:
[3] sqlfamily
[3] sqlpass

Top Hashtags in Tweet in G7:
[2] sqlpass
[2] sqlfamily
[1] 11wks
[1] bordercollieaussiemix
[1] devops
[1] azure

Top Words
Top Words in Tweet in Entire Graph:
[40] #sqlpass
[40] #sqlfamily
[22] #sqlserver
[17] help
[15] please
[12] spreading
[12] news
[7] sqlsaturday
[7] dead
[7] long

Top Words in Tweet in G1:
[15] #sqlfamily
[15] #sqlpass
[13] please
[13] help
[13] #sqlserver
[10] spreading
[10] news
[3] sharing
[3] #dba
[3] friends

Top Words in Tweet in G2:
[7] #sqlfamily
[7] #sqlpass
[6] learn
[4] look
[4] #sqlbits
[4] sqlbits
[4] sqlservercentrl
[4] way0utwest
[4] datarelay_uk
[4] events

Top Words in Tweet in G3:
[9] #sqlfamily
[9] #sqlpass
[7] sqlsaturday
[7] dead
[7] long
[7] live
[7] datasaturdays
[7] #sqlserver
[7] #pass
[7] #mvpbuzz

Top Words in Tweet in G4:
[3] #sqlpass
[3] #sqlfamily
[2] pictures

Top Words in Tweet in G6:
[3] thank
[3] those
[3] involved
[3] internally
[3] facilitate
[3] initiatives
[3] amount
[3] effort
[3] stress
[3] helped

Top Words in Tweet in G7:
[2] #sqlpass
[2] #sqlfamily

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[24] #sqlfamily,#sqlpass
[12] please,help
[12] help,spreading
[12] spreading,news
[12] news,#sqlfamily
[12] #sqlpass,#sqlserver
[10] #sqlserver,#sqlfamily
[7] sqlsaturday,dead
[7] dead,long
[7] long,live

Top Word Pairs in Tweet in G1:
[10] please,help
[10] help,spreading
[10] spreading,news
[10] news,#sqlfamily
[10] #sqlfamily,#sqlpass
[10] #sqlpass,#sqlserver
[3] sharing,help
[3] help,#dba
[3] #dba,#sqlserver
[3] #sqlserver,#sqlfamily

Top Word Pairs in Tweet in G2:
[4] look,#sqlbits
[4] #sqlbits,sqlbits
[4] sqlbits,sqlservercentrl
[4] sqlservercentrl,way0utwest
[4] way0utwest,datarelay_uk
[4] datarelay_uk,events
[4] events,dataweekender
[4] dataweekender,eightkbconf
[4] eightkbconf,see
[4] see,#sqlfamily

Top Word Pairs in Tweet in G3:
[9] #sqlfamily,#sqlpass
[7] sqlsaturday,dead
[7] dead,long
[7] long,live
[7] live,datasaturdays
[7] datasaturdays,#sqlserver
[7] #sqlserver,#sqlfamily
[7] #sqlpass,#pass
[7] #pass,#mvpbuzz
[2] sqlserver,hey

Top Word Pairs in Tweet in G6:
[3] thank,those
[3] those,involved
[3] involved,internally
[3] internally,facilitate
[3] facilitate,initiatives
[3] initiatives,amount
[3] amount,effort
[3] effort,stress
[3] stress,helped
[3] helped,drive

Top Word Pairs in Tweet in G7:
[2] #sqlpass,#sqlfamily

Top Replied-To
Top Replied-To in Entire Graph:
@sqlserver
@buckwoodymsft

Top Replied-To in G3:
@sqlserver

Top Replied-To in G5:
@buckwoodymsft

Top Mentioned
Top Mentioned in Entire Graph:
@sqlbits
@sqlservercentrl
@way0utwest
@datarelay_uk
@dataweekender
@eightkbconf
@dbavug
@sqlgene
@sqlpass
@blythemorrow

Top Mentioned in G1:
@dbavug
@sqlgene

Top Mentioned in G2:
@sqlbits
@sqlservercentrl
@way0utwest
@datarelay_uk
@dataweekender
@eightkbconf
@sqlpass

Top Mentioned in G4:
@sqlmal
@auntkathi
@dbasheldon
@mikelynn
@_missdani

Top Mentioned in G5:
@blythemorrow
@desertislesql

Top Tweeters
Top Tweeters in Entire Graph:
@sql_handle
@jenstirrup
@way0utwest
@sqlagentman
@derfredo
@sqlservercentrl
@loriedwards
@spaghettidba
@sqlpass
@glennalanberry

Top Tweeters in G1:
@jenstirrup
@glennalanberry
@sqlbobscot
@sqlgene
@sqlworldwide
@sqlzelda
@kennyneal
@cjokrap
@tvwizard
@desertdba

Top Tweeters in G2:
@way0utwest
@sqlservercentrl
@sqlpass
@sqlbek
@volkerbachmann
@flyingcod
@datarelay_uk
@sqlbits
@dataweekender
@sqldataclouduk

Top Tweeters in G3:
@sql_handle
@derfredo
@spaghettidba
@sqlserver
@mmarie
@andrekamman
@arcticdba
@viorelciucu
@sqldancer

Top Tweeters in G4:
@sqlmal
@sqlsuperguru
@_missdani
@mikelynn
@auntkathi
@dbasheldon

Top Tweeters in G5:
@yetanothersql
@desertislesql
@buckwoodymsft
@blythemorrow

Top Tweeters in G6:
@sqlagentman
@loriedwards
@sqldbguy

Top Tweeters in G7:
@codegumbo
@sqljen


We use necessary cookies to make our site work. We’d like to set additional cookies to understand site usage, make site improvements and to remember your settings. We also use cookies set by other sites to help deliver content from their services.