sqlpass, Twitter, 10/31/2021 6:43:19 AM, 265164


FAQ | Problem?

sqlpass_2021-10-30_22-19-04.xlsx
sqlpass_2021-10-30_22-19-04.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
October 31, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/3bw7R3m
@thesmilingdba
@sql_handle
@sqlworldwide
@sqlespresso
@dcacco
@way0utwest
@sqlgene
@passdatasummit
@reviewmydb
@sqlrus

Top hashtags:
#sqlpass
#sqlsatorlando
#sqlsat
#performance
#optimization
#sqlserver
#sqlserv
#sqlblog

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

The requested start date was Sunday, 31 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 13-day, 1-hour, 49-minute period from Sunday, 17 October 2021 at 21:07 UTC to Saturday, 30 October 2021 at 22:56 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 : 60
Unique Edges : 55
Edges With Duplicates : 117
Total Edges : 172
Number of Edge Types : 5
Mentions : 65
Replies to : 9
Retweet : 30
MentionsInRetweet : 52
Tweet : 16
Self-Loops : 16
Reciprocated Vertex Pair Ratio : 0.0853658536585366
Reciprocated Edge Ratio : 0.157303370786517
Connected Components : 13
Single-Vertex Connected Components : 4
Maximum Vertices in a Connected Component : 29
Maximum Edges in a Connected Component : 115
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 2.55814
Graph Density : 0.0251412429378531
Modularity : 0.431576
NodeXL Version : 1.0.1.447
Data Import : The graph represents a network of 60 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, 31 October 2021 at 05:19 UTC.

The requested start date was Sunday, 31 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 13-day, 1-hour, 49-minute period from Sunday, 17 October 2021 at 21:07 UTC to Saturday, 30 October 2021 at 22:56 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:
[11] https://passdatacommunitysummit.com/sessions#/263530
[4] https://www.brentozar.com/archive/2021/10/free-sqlpass-keynote-your-career-in-the-age-of-the-cloud/
[2] https://sqlsaturday.com/2021-10-30-sqlsaturday1021/#schedule
[2] https://sqlespresso.com/2018/03/27/template-explorer-gold-mine-for-newbies/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://sqlespresso.com/2019/12/04/introduction-to-the-performance-features-on-sql-server-on-linux/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://passdatacommunitysummit.com/learning-pathways#pathway-query-tuning
[2] https://event.passdatacommunitysummit.com/widget/redgate/summit2021/sessioncatalog/session/1629311235678001sMqW
[1] https://1drv.ms/f/s!AkjSyyIxsDsjgaAXGDhP-_Wdlt0NsQ
[1] https://sqlsaturday.com/2021-10-30-sqlsaturday1021/
[1] https://sqlperformance.com/2021/10/sql-statistics/synchronous-statistics-updates

Top URLs in Tweet in G1:
[3] https://www.brentozar.com/archive/2021/10/free-sqlpass-keynote-your-career-in-the-age-of-the-cloud/
[2] https://event.passdatacommunitysummit.com/widget/redgate/summit2021/sessioncatalog/session/1629311235678001sMqW
[2] https://sqlsaturday.com/2021-10-30-sqlsaturday1021/#schedule
[1] https://sqlsaturday.com/2021-10-30-sqlsaturday1021/

Top URLs in Tweet in G2:
[11] https://passdatacommunitysummit.com/sessions#/263530
[2] https://sqlespresso.com/2018/03/27/template-explorer-gold-mine-for-newbies/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://sqlespresso.com/2019/12/04/introduction-to-the-performance-features-on-sql-server-on-linux/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://twitter.com/DCACco/status/1448827234941292547/photo/1
[1] https://twitter.com/DCACco/status/1446718834912661509/photo/1
[1] https://twitter.com/DCACco/status/1447569439524859908/photo/1
[1] https://twitter.com/DCACco/status/1447946927954403341/photo/1
[1] https://twitter.com/DCACco/status/1448031016208191493/photo/1
[1] https://twitter.com/DCACco/status/1448143226913779712/photo/1
[1] https://twitter.com/DCACco/status/1448356123648663552/photo/1

Top URLs in Tweet in G3:
[1] https://1drv.ms/f/s!AkjSyyIxsDsjgaAXGDhP-_Wdlt0NsQ

Top URLs in Tweet in G5:
[1] https://www.meetup.com/SQLPass-DataProfessional/events/281388766/

Top URLs in Tweet in G6:
[1] https://www.brentozar.com/archive/2021/10/free-sqlpass-keynote-your-career-in-the-age-of-the-cloud/
[1] https://sqlperformance.com/2021/10/sql-statistics/synchronous-statistics-updates
[1] https://sqlperformance.com/2021/10/database-design/bad-habits-avoiding-null

Top URLs in Tweet in G8:
[1] https://www.meetup.com/toronto-data-professionals-meetup-group/events/281196449/?fbclid=IwAR2ij5tcL1N3ireDklgWDvPDOJEDcZ2w2kOnkm6Qa7sVxJXP_M6Uh5ZNvYk
[1] https://www.meetup.com/toronto-data-professionals-meetup-group/events/281196449/

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

Top URLs in Tweet in G10:
[2] https://passdatacommunitysummit.com/learning-pathways#pathway-query-tuning
[1] https://passdatacommunitysummit.com/?utm_source=sqlauthority&utm_medium=social&utm_campaign=10042021

Top Domains
Top Domains in Tweet in Entire Graph:
[16] passdatacommunitysummit.com
[8] twitter.com
[5] sqlespresso.com
[5] meetup.com
[4] brentozar.com
[3] sqlsaturday.com
[2] sqlperformance.com
[1] 1drv.ms

Top Domains in Tweet in G1:
[3] sqlsaturday.com
[3] brentozar.com
[2] passdatacommunitysummit.com

Top Domains in Tweet in G2:
[11] passdatacommunitysummit.com
[8] twitter.com
[5] sqlespresso.com

Top Domains in Tweet in G3:
[1] 1drv.ms

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

Top Domains in Tweet in G6:
[2] sqlperformance.com
[1] brentozar.com

Top Domains in Tweet in G8:
[2] meetup.com

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

Top Domains in Tweet in G10:
[3] passdatacommunitysummit.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[46] sqlpass
[19] sqlsatorlando
[18] sqlsat
[17] performance
[17] optimization
[16] sqlserver
[8] sqlserv
[5] sqlblog
[5] powerbi
[3] sqlfamily



Top Hashtags in Tweet in G1:
[21] sqlpass
[18] sqlsatorlando
[17] sqlsat
[2] sqlsat1021
[1] sqlfamily
[1] sqlpassorlando
[1] sqlsaturday
[1] sqlsaturdayorl

Top Hashtags in Tweet in G2:
[17] performance
[17] optimization
[15] sqlserver
[13] sqlpass
[8] sqlserv
[5] sqlblog
[1] sqlsatorlando
[1] sqlsat
[1] database
[1] it

Top Hashtags in Tweet in G3:
[1] europass
[1] sqlfamily

Top Hashtags in Tweet in G4:
[5] powerbi
[1] passcommunitysummit
[1] sqlpass

Top Hashtags in Tweet in G6:
[5] sqlpass
[1] annoying
[1] passsummit
[1] summit16
[1] sqlfamily

Top Hashtags in Tweet in G7:
[2] sqlpass

Top Hashtags in Tweet in G8:
[2] sqlpass
[2] toronto
[1] data
[1] digital
[1] economy
[1] datacentric
[1] community
[1] learningtogether

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

Top Hashtags in Tweet in G10:
[1] passcommunitysummit
[1] sqlpass

Top Words
Top Words in Tweet in Entire Graph:
[46] #sqlpass
[32] sql
[31] tuning
[31] server
[19] #sqlsatorlando
[18] #sqlsat
[17] #performance
[17] #optimization
[17] critical
[17] environment

Top Words in Tweet in G1:
[21] #sqlpass
[18] #sqlsatorlando
[17] #sqlsat
[7] sqlworldwide
[7] way0utwest
[6] talking
[5] feaselkl
[4] weekend
[4] person
[4] spent

Top Words in Tweet in G2:
[30] sql
[30] server
[27] tuning
[17] #performance
[17] #optimization
[17] critical
[17] environment
[17] learn
[16] sqlespresso
[16] dcacco

Top Words in Tweet in G3:
[6] andrekamman
[6] sqlpass_de
[4] dirkhondong
[3] bobwardms
[2] volcano
[2] pass
[2] europe

Top Words in Tweet in G4:
[6] pass
[5] finished
[5] recording
[5] lighting
[5] talk
[5] quick
[5] tips
[5] help
[5] 100
[5] exam

Top Words in Tweet in G5:
[2] join
[2] southland
[2] data
[2] professionals
[2] tomorrow
[2] 10
[2] 21
[2] 30pm
[2] pdt
[2] hear

Top Words in Tweet in G6:
[5] #sqlpass
[2] pass
[2] time
[2] canadian
[2] blogger
[2] sqlperformance

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

Top Words in Tweet in G8:
[4] data
[2] paulswengrr
[2] toronto
[2] professionals
[2] community
[2] hosting
[2] session
[2] today
[2] 00
[2] pm

Top Words in Tweet in G10:
[4] session
[2] tackling
[2] monster
[2] stored
[2] procs
[2] last
[2] query
[2] tuning
[2] learning
[2] pathway

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[31] sql,server
[17] #performance,tuning
[17] tuning,#optimization
[17] #optimization,critical
[17] critical,sql
[17] server,environment
[17] environment,learn
[16] dcacco,#performance
[15] learn,right
[14] right,sqlespresso

Top Word Pairs in Tweet in G1:
[10] #sqlsat,#sqlpass
[6] #sqlpass,#sqlsat
[3] #sqlsatorlando,#sqlsat
[3] #sqlpass,way0utwest
[3] way0utwest,clouddatadriven
[3] sqlgene,feaselkl
[3] watching,bloopers
[3] bloopers,co
[3] co,gx3prg8p9r
[3] gx3prg8p9r,bring

Top Word Pairs in Tweet in G2:
[30] sql,server
[17] #performance,tuning
[17] tuning,#optimization
[17] #optimization,critical
[17] critical,sql
[17] server,environment
[17] environment,learn
[16] dcacco,#performance
[15] learn,right
[14] right,sqlespresso

Top Word Pairs in Tweet in G3:
[6] andrekamman,sqlpass_de
[4] dirkhondong,andrekamman
[2] pass,europe
[2] bobwardms,andrekamman

Top Word Pairs in Tweet in G4:
[5] finished,recording
[5] recording,lighting
[5] lighting,talk
[5] talk,quick
[5] quick,tips
[5] tips,help
[5] help,pass
[5] pass,100
[5] 100,exam
[5] exam,analyzing

Top Word Pairs in Tweet in G5:
[2] join,southland
[2] southland,data
[2] data,professionals
[2] professionals,tomorrow
[2] tomorrow,10
[2] 10,21
[2] 21,30pm
[2] 30pm,pdt
[2] pdt,hear
[2] hear,aiwithalicia

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

Top Word Pairs in Tweet in G8:
[2] toronto,data
[2] data,professionals
[2] professionals,community
[2] community,hosting
[2] hosting,session
[2] session,today
[2] today,00
[2] 00,pm
[2] pm,data
[2] data,centric

Top Word Pairs in Tweet in G10:
[2] session,tackling
[2] tackling,monster
[2] monster,stored
[2] stored,procs
[2] procs,last
[2] last,session
[2] session,query
[2] query,tuning
[2] tuning,learning
[2] learning,pathway

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@dcacco
@sqlespresso
@way0utwest
@andrekamman
@sqlpass_de
@sqlworldwide
@thesmilingdba
@sqlatspeed
@feaselkl
@itdatadiva

Top Mentioned in G1:
@way0utwest
@sqlworldwide
@feaselkl
@thesmilingdba
@sqlatspeed
@clouddatadriven
@passdatasummit
@sqlgene
@sqldba
@jamesserra

Top Mentioned in G2:
@sqlespresso
@dcacco
@sqlrus
@thesmilingdba
@reviewmydb

Top Mentioned in G3:
@andrekamman
@sqlpass_de
@dirkhondong
@guyinacube
@bobwardms

Top Mentioned in G4:
@itdatadiva

Top Mentioned in G5:
@aiwithalicia
@dustinvannoy
@laurielcarr

Top Mentioned in G7:
@sqlbob
@sqlinthewild

Top Mentioned in G8:
@paulswengrr
@sqlfamily

Top Mentioned in G9:
@microsoft
@azure

Top Mentioned in G10:
@sqlrunr

Top Tweeters
Top Tweeters in Entire Graph:
@dataaugmented
@ricardo_ik_ahau
@sql_handle
@brento
@way0utwest
@sqldba
@rafaelgolden
@azure
@powerplatfrmbot
@retracement

Top Tweeters in G1:
@way0utwest
@sqldba
@rafaelgolden
@pshore73
@sqlgene
@sql_r
@sqlworldwide
@sqlatspeed
@chrisavwood
@thesmilingdba

Top Tweeters in G2:
@ricardo_ik_ahau
@sql_handle
@sqlrus
@sqlespresso
@pedromartinezsv
@dcacco
@divaldobarros1
@georginsilva
@gilvanaschulz
@alexandrecoppo3

Top Tweeters in G3:
@guyinacube
@dirkhondong
@andrekamman
@bobwardms
@sqlpass_de

Top Tweeters in G4:
@dataaugmented
@powerplatfrmbot
@adipesa
@itdatadiva
@pbi_orlandopug

Top Tweeters in G5:
@steverezhener
@laurielcarr
@dustinvannoy
@aiwithalicia

Top Tweeters in G6:
@brento
@retracement
@mihailmateev
@pass_rm_canada

Top Tweeters in G7:
@sqlmal
@sqlinthewild
@sqlbob

Top Tweeters in G8:
@arthurz
@paulswengrr
@sqlfamily

Top Tweeters in G9:
@azure
@microsoft
@hybridvug

Top Tweeters in G10:
@alzdba
@sqlrunr


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.