sqlpass, Twitter, 10/3/2021 5:39:01 AM, 263516


FAQ | Problem?

sqlpass_2021-10-02_22-19-04.xlsx
sqlpass_2021-10-02_22-19-04.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
October 03, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/2ZIrLpg
@sqlespresso
@sqlfabrik
@dcacco
@passdatasummit
@frankgeisler
@jama_press_uk
@dsfnet
@mayfconsulting
@kirnerka
@wianobot

Top hashtags:
#sqlpass
#sqlserver
#pass
#data
#performance
#optimization
#sqlpass_de
#sqlblog
#sql

Description:
Description
The graph represents a network of 29 Twitter users whose tweets in the requested range contained "sqlpass", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Sunday, 03 October 2021 at 05:19 UTC.

The requested start date was Sunday, 03 October 2021 at 00:01 UTC and the maximum number of days (going backward) was 14.

The maximum number of tweets collected was 7,500.

The tweets in the network were tweeted over the 12-day, 6-hour, 41-minute period from Monday, 20 September 2021 at 14:27 UTC to Saturday, 02 October 2021 at 21:08 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 : 29
Unique Edges : 15
Edges With Duplicates : 97
Total Edges : 112
Number of Edge Types : 4
Retweet : 32
MentionsInRetweet : 40
Tweet : 12
Mentions : 28
Self-Loops : 12
Reciprocated Vertex Pair Ratio : 0.111111111111111
Reciprocated Edge Ratio : 0.2
Connected Components : 9
Single-Vertex Connected Components : 3
Maximum Vertices in a Connected Component : 9
Maximum Edges in a Connected Component : 73
Maximum Geodesic Distance (Diameter) : 4
Average Geodesic Distance : 1.47929
Graph Density : 0.0369458128078818
Modularity : 0.254544
NodeXL Version : 1.0.1.447
Data Import : The graph represents a network of 29 Twitter users whose tweets in the requested range contained "sqlpass", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Sunday, 03 October 2021 at 05:19 UTC.

The requested start date was Sunday, 03 October 2021 at 00:01 UTC and the maximum number of days (going backward) was 14.

The maximum number of tweets collected was 7,500.

The tweets in the network were tweeted over the 12-day, 6-hour, 41-minute period from Monday, 20 September 2021 at 14:27 UTC to Saturday, 02 October 2021 at 21:08 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 : GraphServerTwitterSearch
Graph Term : sqlpass
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:
[23] https://passdatacommunitysummit.com/sessions#/?search=denny&type=Pre-conference+Session+(Full-day)
[4] https://passdatacommunitysummit.com/sessions#/263530
[3] https://sqlespresso.com/2020/04/21/coding-standards-gone-bad-in-sql-server/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://www.amazon.com/Dont-forget-Keys-Database-creators/dp/B09H1T1TRV/ref=sr_1_2?dchild=1&qid=1632912451&refinements=p_27:Martin+Watts&s=books&sr=1-2&text=Martin+Watts
[2] https://sqlespresso.com/2017/09/27/just-check-all-the-boxes/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://michaeljswart.com/2021/10/a-system-maintained-lastmodifieddate-column/
[1] https://sqlperformance.com/2021/09/sql-performance/refreshing-tables-partition-switching
[1] https://twitter.com/DCACco/status/1443819731165851651/photo/1
[1] https://twitter.com/DCACco/status/1443282693832204291/photo/1
[1] https://sqlespresso.com/2018/01/31/can-you-hear-it-now/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top URLs in Tweet in G1:
[23] https://passdatacommunitysummit.com/sessions#/?search=denny&type=Pre-conference+Session+(Full-day)
[4] https://passdatacommunitysummit.com/sessions#/263530
[3] https://sqlespresso.com/2020/04/21/coding-standards-gone-bad-in-sql-server/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://sqlespresso.com/2017/09/27/just-check-all-the-boxes/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://twitter.com/DCACco/status/1443819731165851651/photo/1
[1] https://sqlespresso.com/2018/01/31/can-you-hear-it-now/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://twitter.com/DCACco/status/1443282693832204291/photo/1
[1] https://passdatacommunitysummit.com/

Top URLs in Tweet in G3:
[2] https://www.amazon.com/Dont-forget-Keys-Database-creators/dp/B09H1T1TRV/ref=sr_1_2?dchild=1&qid=1632912451&refinements=p_27:Martin+Watts&s=books&sr=1-2&text=Martin+Watts

Top URLs in Tweet in G4:
[1] https://www.brentozar.com/archive/2013/05/questions-about-your-sqlpass-summit-submission/

Top URLs in Tweet in G5:
[1] https://michaeljswart.com/2021/10/a-system-maintained-lastmodifieddate-column/
[1] https://sqlperformance.com/2021/09/sql-performance/refreshing-tables-partition-switching

Top URLs in Tweet in G6:
[1] https://www.meetup.com/microsoft-data-platform-continuity-virtual-group/events/280735015/

Top URLs in Tweet in G7:
[1] https://www.meetup.com/hybrid-virtual-group/events/280597744/

Top Domains
Top Domains in Tweet in Entire Graph:
[28] passdatacommunitysummit.com
[6] sqlespresso.com
[2] amazon.com
[2] twitter.com
[2] meetup.com
[1] michaeljswart.com
[1] sqlperformance.com
[1] brentozar.com

Top Domains in Tweet in G1:
[28] passdatacommunitysummit.com
[6] sqlespresso.com
[2] twitter.com

Top Domains in Tweet in G3:
[2] amazon.com

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

Top Domains in Tweet in G5:
[1] michaeljswart.com
[1] sqlperformance.com

Top Domains in Tweet in G6:
[1] meetup.com

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

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[31] sqlpass
[28] sqlserver
[23] pass
[23] data
[8] performance
[8] optimization
[7] sqlpass_de
[6] sqlblog
[6] sql
[6] sqlite



Top Hashtags in Tweet in G1:
[23] pass
[23] data
[22] sqlserver
[21] sqlpass
[8] performance
[8] optimization
[6] sqlblog
[2] sqlserve
[2] database
[2] it

Top Hashtags in Tweet in G2:
[7] sqlpass_de
[2] azure
[2] cloud

Top Hashtags in Tweet in G3:
[6] sql
[6] sqlserver
[6] sqlite
[6] sqldeveloper
[6] sqlmap
[6] sqldatabase
[6] sqlserver2017
[6] sqlserveronlinux
[6] sqlserver2014
[2] sqltraining

Top Hashtags in Tweet in G4:
[2] sqlpass
[1] collabtalk

Top Hashtags in Tweet in G5:
[2] sqlpass

Top Hashtags in Tweet in G6:
[3] sqlpass
[3] mvpbuzz
[1] azuresql
[1] highavaiability
[1] azure

Top Hashtags in Tweet in G7:
[1] mvpbuzz
[1] sqlpass

Top Words
Top Words in Tweet in Entire Graph:
[47] pre
[46] cons
[31] #sqlpass
[30] community
[29] sql
[28] #sqlserver
[27] join
[25] dcac
[23] team
[23] members

Top Words in Tweet in G1:
[46] pre
[46] cons
[27] sql
[25] dcac
[23] join
[23] team
[23] members
[23] #pass
[23] #data
[23] community

Top Words in Tweet in G2:
[7] hallo
[7] liebe
[7] #sqlpass_de
[7] community
[7] 05
[7] 10
[7] 2021
[7] gibt
[7] 19
[7] 00

Top Words in Tweet in G3:
[6] #sql
[6] #sqlserver
[6] #sqlite
[6] #sqldeveloper
[6] #sqlmap
[6] #sqldatabase
[6] #sqlserver2017
[6] #sqlserveronlinux
[6] #sqlserver2014
[4] jama_press_uk

Top Words in Tweet in G4:
[2] conference
[2] session
[2] submission
[2] #sqlpass
[2] register

Top Words in Tweet in G5:
[2] canadian
[2] blogger
[2] #sqlpass

Top Words in Tweet in G6:
[3] #sqlpass
[3] #mvpbuzz
[2] spend
[2] sunday
[2] home
[2] office
[2] different
[2] talks
[2] delivering
[2] four

Top Words in Tweet in G7:
[4] join
[2] later
[2] today
[2] 6pm
[2] udt
[2] advanced
[2] data
[2] modelling
[2] power
[2] bi

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[46] pre,cons
[23] join,dcac
[23] dcac,team
[23] team,members
[23] members,pre
[23] cons,#pass
[23] #pass,#data
[23] #data,community
[23] community,summit
[23] summit,each

Top Word Pairs in Tweet in G1:
[46] pre,cons
[23] join,dcac
[23] dcac,team
[23] team,members
[23] members,pre
[23] cons,#pass
[23] #pass,#data
[23] #data,community
[23] community,summit
[23] summit,each

Top Word Pairs in Tweet in G2:
[7] hallo,liebe
[7] liebe,#sqlpass_de
[7] #sqlpass_de,community
[7] community,05
[7] 05,10
[7] 10,2021
[7] 2021,gibt
[7] gibt,19
[7] 19,00
[7] 00,nächste

Top Word Pairs in Tweet in G3:
[6] #sql,#sqlserver
[6] #sqlserver,#sqlite
[6] #sqlite,#sqldeveloper
[6] #sqldeveloper,#sqlmap
[6] #sqlmap,#sqldatabase
[6] #sqldatabase,#sqlserver2017
[6] #sqlserver2017,#sqlserveronlinux
[6] #sqlserveronlinux,#sqlserver2014
[4] jama_press_uk,#sql
[4] #sqlserver2014,#sqltraini

Top Word Pairs in Tweet in G4:
[2] session,submission

Top Word Pairs in Tweet in G5:
[2] canadian,blogger

Top Word Pairs in Tweet in G6:
[3] #sqlpass,#mvpbuzz
[2] spend,sunday
[2] sunday,home
[2] home,office
[2] office,different
[2] different,talks
[2] talks,delivering
[2] delivering,four
[2] four,sessions
[2] sessions,next

Top Word Pairs in Tweet in G7:
[2] join,later
[2] later,today
[2] today,6pm
[2] 6pm,udt
[2] udt,advanced
[2] advanced,data
[2] data,modelling
[2] modelling,power
[2] power,bi
[2] bi,aas

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@sqlespresso
@dcacco
@mrdenny
@sqlfabrik
@jama_press_uk
@frankgeisler
@mehrenmueller
@mjswart
@rgmuensterland
@sqlworldwide

Top Mentioned in G1:
@sqlespresso
@dcacco
@mrdenny
@passdatasummit

Top Mentioned in G2:
@sqlfabrik
@frankgeisler
@rgmuensterland

Top Mentioned in G3:
@jama_press_uk

Top Mentioned in G5:
@mjswart

Top Mentioned in G6:
@sqlworldwide

Top Mentioned in G7:
@mehrenmueller
@hybridvug

Top Tweeters
Top Tweeters in Entire Graph:
@brento
@mrdenny
@sqldbawithbeard
@klunkysql
@koprowskit
@dsfnet
@derfredo
@lmontek42
@sqlespresso
@dirkhondong

Top Tweeters in G1:
@mrdenny
@sqldbawithbeard
@lmontek42
@sqlespresso
@leroy_edi
@dcacco
@mayfconsulting
@shbwatson
@passdatasummit

Top Tweeters in G2:
@derfredo
@dirkhondong
@crazyaboutcloud
@frankgeisler
@sqlpaparazzo
@kirnerka
@rgmuensterland
@sqlfabrik

Top Tweeters in G3:
@databasesimple
@wianobot
@jama_press_uk

Top Tweeters in G4:
@brento
@koprowskit
@dsfnet

Top Tweeters in G5:
@mjswart
@pass_rm_canada

Top Tweeters in G6:
@klunkysql
@sqlworldwide

Top Tweeters in G7:
@mehrenmueller
@hybridvug


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.