sqlpass, Twitter, 9/19/2021 5:49:50 AM, 262382


FAQ | Problem?

sqlpass_2021-09-18_22-19-04.xlsx
sqlpass_2021-09-18_22-19-04.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
September 19, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/3lAWKLf
@sqlespresso
@dcacco
@sqlha
@sql_unicorn
@dirkhondong
@sqlgroup
@sqlserverradio
@blythemorrow
@irishsql
@mrdenny

Top hashtags:
#sqlpass
#pass
#data
#sqlserver
#sqlblog
#bi
#datafactory
#azure
#reporting
#webcast

Description:
Description
The graph represents a network of 25 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, 19 September 2021 at 05:19 UTC.

The requested start date was Sunday, 19 September 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 10-day, 8-hour, 59-minute period from Tuesday, 07 September 2021 at 21:07 UTC to Saturday, 18 September 2021 at 06:07 UTC.

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 : 25
Unique Edges : 22
Edges With Duplicates : 65
Total Edges : 87
Number of Edge Types : 5
Retweet : 17
MentionsInRetweet : 24
Mentions : 36
Tweet : 8
Replies to : 2
Self-Loops : 8
Reciprocated Vertex Pair Ratio : 0.16
Reciprocated Edge Ratio : 0.275862068965517
Connected Components : 7
Single-Vertex Connected Components : 2
Maximum Vertices in a Connected Component : 11
Maximum Edges in a Connected Component : 67
Maximum Geodesic Distance (Diameter) : 4
Average Geodesic Distance : 1.801242
Graph Density : 0.0483333333333333
Modularity : 0.278537
NodeXL Version : 1.0.1.447
Data Import : The graph represents a network of 25 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, 19 September 2021 at 05:19 UTC.

The requested start date was Sunday, 19 September 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 10-day, 8-hour, 59-minute period from Tuesday, 07 September 2021 at 21:07 UTC to Saturday, 18 September 2021 at 06:07 UTC.

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:
[13] https://passdatacommunitysummit.com/sessions?search=denny&type=Pre-conference+Session+(Full-day)
[10] https://passdatacommunitysummit.com/sessions#/?search=denny&type=Pre-conference+Session+(Full-day)
[4] https://www.dcac.com/training/webcasts/building-a-regret-free-foundation-for-your-data-factory
[2] https://twitter.com/DCACco/status/1436017553688567822/photo/1
[1] https://assets.red-gate.com/hub/pass/pass-community-insights-infographic.pdf
[1] https://sqlperformance.com/2021/09/sql-performance/sql-server-latches-other-latches-to-know-about
[1] https://sqlperformance.com/2021/09/t-sql-queries/table-expressions-part-11
[1] https://sqlespresso.com/2021/02/17/sql-index-creation-using-drop-existing-on/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2019/02/20/azure-key-vault-logging/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2018/12/19/static-data-masking-ssms-18-0-preview/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top URLs in Tweet in G1:
[1] https://sqlespresso.com/2021/02/17/sql-index-creation-using-drop-existing-on/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2018/12/19/static-data-masking-ssms-18-0-preview/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://www.dcac.com/training/webcasts/building-a-regret-free-foundation-for-your-data-factory
[1] https://twitter.com/DCACco/status/1436017553688567822/photo/1
[1] https://sqlespresso.com/2019/02/20/azure-key-vault-logging/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top URLs in Tweet in G2:
[13] https://passdatacommunitysummit.com/sessions?search=denny&type=Pre-conference+Session+(Full-day)
[10] https://passdatacommunitysummit.com/sessions#/?search=denny&type=Pre-conference+Session+(Full-day)
[3] https://www.dcac.com/training/webcasts/building-a-regret-free-foundation-for-your-data-factory
[1] https://twitter.com/DCACco/status/1436017553688567822/photo/1

Top URLs in Tweet in G4:
[1] https://sqlsolutionsgroup.com/events/pass-data-community-summit-nov-2021-randy-knight-and-scott-klein/?utm_content=179294611&utm_medium=social&utm_source=twitter&hss_channel=tw-329841372

Top URLs in Tweet in G6:
[1] https://assets.red-gate.com/hub/pass/pass-community-insights-infographic.pdf

Top URLs in Tweet in G7:
[1] https://www.meetup.com/SQLPass-DataProfessional/
[1] https://sqlperformance.com/2021/09/sql-performance/sql-server-latches-other-latches-to-know-about
[1] https://sqlperformance.com/2021/09/t-sql-queries/table-expressions-part-11

Top Domains
Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[24] sqlpass
[23] pass
[23] data
[17] sqlserver
[3] sqlblog
[3] bi
[3] datafactory
[3] azure
[3] reporting
[3] webcast



Top Hashtags in Tweet in G1:
[4] sqlpass
[3] sqlserver
[3] sqlblog
[1] bi
[1] datafactory
[1] azure
[1] reporting
[1] webcast
[1] adf
[1] azuredata

Top Hashtags in Tweet in G2:
[23] pass
[23] data
[15] sqlpass
[13] sqlserver
[2] bi
[2] datafactory
[2] azure
[2] reporting
[2] webcast
[2] adf

Top Hashtags in Tweet in G3:
[1] sqlserver
[1] professionaldevelopement
[1] sqlfamily
[1] sqlpass

Top Hashtags in Tweet in G4:
[1] sql
[1] sqlfam
[1] learnsql
[1] sqlpass
[1] passsummit
[1] summit2021
[1] sql2021
[1] mssql
[1] sqlexpert
[1] sqlebrity

Top Hashtags in Tweet in G5:
[1] sqlpass_de

Top Hashtags in Tweet in G6:
[1] passdatacommunitysummit
[1] sqlpass

Top Hashtags in Tweet in G7:
[2] sqlpass

Top Words
Top Words in Tweet in Entire Graph:
[46] pre
[46] cons
[26] community
[24] dcac
[24] summit
[24] #sqlpass
[23] join
[23] team
[23] members
[23] #pass

Top Words in Tweet in G1:
[4] #sqlpass
[3] blog
[3] archive
[3] #sqlserver
[3] #sqlblog
[2] data
[2] sqlha
[2] _randolph_west
[2] irishsql
[2] sqlespresso

Top Words in Tweet in G2:
[46] pre
[46] cons
[24] dcac
[23] join
[23] team
[23] members
[23] #pass
[23] #data
[23] community
[23] summit

Top Words in Tweet in G3:
[4] great
[3] interview
[3] sqlserverradio
[3] podcast
[3] talked
[3] lot
[3] storytelling
[3] dbas
[3] pitch
[2] blythemorrow

Top Words in Tweet in G4:
[6] consultant
[3] ssg
[3] founder
[3] principal
[3] randy
[3] knight
[3] senior
[3] scott
[3] klein
[3] both

Top Words in Tweet in G6:
[2] feedback
[2] gift
[2] making
[2] sure
[2] squeeze
[2] yours
[2] top
[2] 10
[2] things
[2] learned

Top Words in Tweet in G7:
[2] canadian
[2] blogger
[2] sqlperformance
[2] latches
[2] #sqlpass

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

Top Word Pairs in Tweet in G1:
[3] blog,archive
[3] #sqlserver,#sqlblog
[3] #sqlblog,#sqlpass
[2] sqlha,_randolph_west
[2] _randolph_west,irishsql
[2] irishsql,sqlespresso
[2] sqlespresso,jdanton
[2] jdanton,sqlcheesecake
[2] sqlcheesecake,being
[2] being,fan

Top Word Pairs in Tweet in G2:
[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 G3:
[3] great,interview
[3] interview,sqlserverradio
[3] sqlserverradio,podcast
[3] podcast,talked
[3] talked,lot
[3] lot,storytelling
[3] storytelling,dbas
[3] dbas,pitch
[2] blythemorrow,great

Top Word Pairs in Tweet in G4:
[3] ssg,founder
[3] founder,principal
[3] principal,consultant
[3] consultant,randy
[3] randy,knight
[3] knight,senior
[3] senior,consultant
[3] consultant,scott
[3] scott,klein
[3] klein,both

Top Word Pairs in Tweet in G6:
[2] feedback,gift
[2] gift,making
[2] making,sure
[2] sure,squeeze
[2] squeeze,yours
[2] yours,top
[2] top,10
[2] 10,things
[2] things,learned

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

Top Replied-To
Top Replied-To in Entire Graph:
@sqlha
@cathrinew

Top Replied-To in G1:
@sqlha

Top Replied-To in G5:
@cathrinew

Top Mentioned
Top Mentioned in Entire Graph:
@sqlespresso
@dcacco
@mrdenny
@sqlserverradio
@_randolph_west
@irishsql
@jdanton
@sqlcheesecake
@blythemorrow
@sqlgroup

Top Mentioned in G1:
@_randolph_west
@irishsql
@sqlespresso
@jdanton
@sqlcheesecake
@dcacco
@sql_unicorn
@sqlha

Top Mentioned in G2:
@sqlespresso
@mrdenny
@dcacco

Top Mentioned in G3:
@sqlserverradio
@blythemorrow

Top Mentioned in G4:
@sqlgroup

Top Mentioned in G5:
@datasatoslo

Top Mentioned in G6:
@redgate
@passdatasummit

Top Tweeters
Top Tweeters in Entire Graph:
@sql_handle
@jdanton
@sqlcheesecake
@mrdenny
@sqlha
@_randolph_west
@klunkysql
@sqlrus
@irishsql
@redgate

Top Tweeters in G1:
@jdanton
@sqlcheesecake
@sqlha
@_randolph_west
@irishsql
@sqlespresso
@sql_unicorn

Top Tweeters in G2:
@mrdenny
@sqlrus
@victoria_holt
@dcacco

Top Tweeters in G3:
@sql_handle
@klunkysql
@blythemorrow
@sqlserverradio

Top Tweeters in G4:
@volkerbachmann
@sqlscott
@sqlgroup

Top Tweeters in G5:
@cathrinew
@dirkhondong
@datasatoslo

Top Tweeters in G6:
@redgate
@passdatasummit

Top Tweeters in G7:
@pass_rm_canada
@laurielcarr


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.