sqlpass, Twitter, 2/14/2021 6:05:11 AM, 248699


FAQ | Problem?

sqlpass_2021-02-13_21-45-00.xlsx
sqlpass_2021-02-13_21-45-00.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
February 14, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/2LNW0EK
@rpertusa
@sqlpass_de
@_tillmann
@nikoneugebauer
@adriandiaz81
@redgate
@hybridvug
@sqlmisssunshine
@retracement
@sqlespresso

Top hashtags:
#sqlpass
#sqlserver
#sqlblog
#powerbi
#msitpro
#msdev
#msbi
#powerplatform
#sqlfamily

Description:
Description
The graph represents a network of 75 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, 14 February 2021 at 05:45 UTC.

The requested start date was Sunday, 14 February 2021 at 01: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 9-day, 2-hour, 47-minute period from Monday, 01 February 2021 at 17:16 UTC to Wednesday, 10 February 2021 at 20:04 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 : 75
Unique Edges : 54
Edges With Duplicates : 87
Total Edges : 141
Number of Edge Types : 5
Retweet : 36
MentionsInRetweet : 52
Mentions : 31
Tweet : 18
Replies to : 4
Self-Loops : 19
Reciprocated Vertex Pair Ratio : 0.0263157894736842
Reciprocated Edge Ratio : 0.0512820512820513
Connected Components : 15
Single-Vertex Connected Components : 6
Maximum Vertices in a Connected Component : 20
Maximum Edges in a Connected Component : 38
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 1.903188
Graph Density : 0.0140540540540541
Modularity : 0.519868
NodeXL Version : 1.0.1.443
Data Import : The graph represents a network of 75 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, 14 February 2021 at 05:45 UTC.

The requested start date was Sunday, 14 February 2021 at 01: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 9-day, 2-hour, 47-minute period from Monday, 01 February 2021 at 17:16 UTC to Wednesday, 10 February 2021 at 20:04 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:
[6] https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/
[4] https://www.meetup.com/dbavug/events/275549751/
[3] https://www.meetup.com/de-DE/Azure-Dusseldorf-Meetup/events/275583592/
[3] https://sqlespresso.com/2020/09/09/resizing-tempdb-when-tempdb-wont-shrink/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[3] https://sqlespresso.com/2021/02/03/mastering-tempdb-the-basics/
[2] https://mailchi.mp/abc5588300db/power-bi-modeling
[1] https://twitter.com/retracement/status/1359183444044107776
[1] https://sqlperformance.com/2021/02/t-sql-queries/number-series-solutions-2
[1] https://www.youracclaim.com/badges/d4d39089-4e1e-495f-b522-00651de93eba/public_url
[1] https://mailchi.mp/7eac61376880/power-bi-power-automate-better-together-webinar-starting-wednesday-27th-jan-at-6pm-utc-gmt-7pm-cet-2pm-edt-4766186?e=[UNIQID]

Top URLs in Tweet in G2:
[1] https://www.sqlpass.de/pass-deutschland-e-v-townhall-meeting-am-9-2-2021/

Top URLs in Tweet in G3:
[1] https://www.red-gate.com/blog/news-blog/redgate-software-takes-over-from-pass

Top URLs in Tweet in G4:
[3] https://sqlespresso.com/2021/02/03/mastering-tempdb-the-basics/
[3] https://sqlespresso.com/2020/09/09/resizing-tempdb-when-tempdb-wont-shrink/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2019/01/30/azure-advisor/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2021/02/10/identifying-performance-problems-part-2/

Top URLs in Tweet in G5:
[2] https://mailchi.mp/abc5588300db/power-bi-modeling
[1] https://twitter.com/retracement/status/1359183444044107776
[1] https://mailchi.mp/7eac61376880/power-bi-power-automate-better-together-webinar-starting-wednesday-27th-jan-at-6pm-utc-gmt-7pm-cet-2pm-edt-4766186?e=[UNIQID]

Top URLs in Tweet in G6:
[6] https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/

Top URLs in Tweet in G7:
[1] https://twitter.com/MicrosoftDE/status/1356574587509764097
[1] https://www.youracclaim.com/badges/d4d39089-4e1e-495f-b522-00651de93eba/public_url
[1] https://sqlperformance.com/2021/02/t-sql-queries/number-series-solutions-2

Top URLs in Tweet in G8:
[4] https://www.meetup.com/dbavug/events/275549751/

Top URLs in Tweet in G9:
[3] https://www.meetup.com/de-DE/Azure-Dusseldorf-Meetup/events/275583592/
[1] https://www.sqlpass.de/events/datenartefakte-mit-azure-synapse-analytics-verbinden/

Top URLs in Tweet in G10:
[1] https://www.sqlservercentral.com/forums/topic/bring-back-in-person-sqlsaturday-where-legal/page/2

Top Domains
Top Domains in Tweet in Entire Graph:
[8] sqlespresso.com
[7] meetup.com
[6] microsoft.com
[3] mailchi.mp
[2] twitter.com
[2] sqlpass.de
[1] sqlperformance.com
[1] youracclaim.com
[1] sqlservercentral.com
[1] red-gate.com

Top Domains in Tweet in G2:
[1] sqlpass.de

Top Domains in Tweet in G3:
[1] red-gate.com

Top Domains in Tweet in G4:
[8] sqlespresso.com

Top Domains in Tweet in G5:
[3] mailchi.mp
[1] twitter.com

Top Domains in Tweet in G6:
[6] microsoft.com

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

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

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

Top Domains in Tweet in G10:
[1] sqlservercentral.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[36] sqlpass
[16] sqlserver
[10] sqlblog
[6] powerbi
[6] msitpro
[6] msdev
[6] msbi
[6] powerplatform
[5] sqlfamily
[4] mvpbuzz



Top Hashtags in Tweet in G3:
[4] sqlpass
[2] sqlsaturday
[2] sqlfamily

Top Hashtags in Tweet in G4:
[10] sqlserver
[10] sqlblog
[10] sqlpass
[3] idera
[3] performancetuning
[3] simpletalk
[3] redgate

Top Hashtags in Tweet in G5:
[6] sqlpass
[4] mvpbuzz
[1] hybridvug

Top Hashtags in Tweet in G6:
[6] powerbi
[6] sqlpass
[6] msitpro
[6] msdev
[6] msbi
[6] powerplatform

Top Hashtags in Tweet in G7:
[3] sqlpass
[2] sqlpass_de
[1] passsummit
[1] sqlfamily
[1] azurecertified
[1] sqlserver

Top Hashtags in Tweet in G8:
[6] sqlpass
[5] sqlserver
[4] azuresql
[1] azuresqldatabase
[1] sqlsaturday
[1] sqlfamily

Top Hashtags in Tweet in G9:
[3] azure
[2] sqlpass_de
[1] azuresynapse
[1] azurepurview

Top Hashtags in Tweet in G10:
[1] sqlsaturday
[1] sqlpass
[1] sqlfamily

Top Words
Top Words in Tweet in Entire Graph:
[36] #sqlpass
[16] #sqlserver
[13] pass
[13] redgate
[10] blog
[10] #sqlblog
[9] 2021
[9] delighted
[9] announce
[9] tempdb

Top Words in Tweet in G1:
[2] netcoreconf
[2] tenerifedev
[2] crossdvlup
[2] co365
[2] madriddotnet
[2] women4tt
[2] womendot
[2] riojadotnet
[2] cartujadotnet
[2] sug_cat

Top Words in Tweet in G2:
[7] heute
[7] abend
[7] große
[7] pass
[7] deutschland
[7] town
[7] hall
[7] meeting
[7] nähere
[7] informationen

Top Words in Tweet in G3:
[12] redgate
[6] assets
[5] community
[5] news
[5] delighted
[5] announce
[5] pass
[5] sqlsaturday
[5] acquired
[5] check

Top Words in Tweet in G4:
[10] blog
[10] #sqlserver
[10] #sqlblog
[10] #sqlpass
[9] tempdb
[6] sqlespresso
[4] archive
[3] identifying
[3] performance
[3] problems

Top Words in Tweet in G5:
[7] next
[7] modeling
[7] power
[7] bi
[6] #sqlpass
[6] hybridvug
[6] sqlmisssunshine
[4] #mvpbuzz
[4] 10th
[4] feb

Top Words in Tweet in G6:
[6] fyi
[6] latest
[6] #powerbi
[6] roadmap
[6] 2021
[6] wave
[6] #sqlpass
[6] #msitpro
[6] #msdev
[6] #msbi

Top Words in Tweet in G7:
[3] #sqlpass
[2] anyone
[2] #sqlpass_de
[2] virtual

Top Words in Tweet in G8:
[7] tgrohser
[7] '#
[7] vs
[7] social
[7] media
[6] #sqlpass
[6] temporary
[6] tables'
[5] #sqlserver
[5] registration

Top Words in Tweet in G9:
[7] februar
[3] wstrasser
[3] virtueller
[3] deutschlandtournee
[3] 18
[3] #azure
[3] meetup
[2] dã
[2] sseldorf
[2] #sqlpass_de

Top Words in Tweet in G10:
[4] one
[4] another
[2] love
[2] shown
[2] absence
[2] during
[2] pandemic
[2] presence
[2] please
[2] think

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[10] #sqlserver,#sqlblog
[9] delighted,announce
[8] heute,abend
[8] abend,große
[8] große,pass
[8] pass,deutschland
[8] deutschland,town
[8] town,hall
[8] hall,meeting
[8] meeting,nähere

Top Word Pairs in Tweet in G1:
[2] netcoreconf,tenerifedev
[2] tenerifedev,crossdvlup
[2] crossdvlup,co365
[2] co365,madriddotnet
[2] madriddotnet,women4tt
[2] women4tt,womendot
[2] womendot,riojadotnet
[2] riojadotnet,cartujadotnet
[2] cartujadotnet,sug_cat

Top Word Pairs in Tweet in G2:
[7] heute,abend
[7] abend,große
[7] große,pass
[7] pass,deutschland
[7] deutschland,town
[7] town,hall
[7] hall,meeting
[7] meeting,nähere
[7] nähere,informationen
[7] informationen,findet

Top Word Pairs in Tweet in G3:
[5] community,news
[5] news,delighted
[5] delighted,announce
[5] announce,pass
[5] pass,sqlsaturday
[5] sqlsaturday,assets
[5] assets,acquired
[5] acquired,redgate
[5] redgate,check
[4] redgate,community

Top Word Pairs in Tweet in G4:
[10] #sqlserver,#sqlblog
[7] #sqlblog,#sqlpass
[6] sqlespresso,blog
[4] blog,archive
[3] blog,identifying
[3] identifying,performance
[3] performance,problems
[3] problems,part
[3] part,#idera
[3] #idera,#sqlserver

Top Word Pairs in Tweet in G5:
[7] modeling,power
[7] power,bi
[4] #sqlpass,#mvpbuzz
[4] 10th,feb
[4] feb,6pm
[4] 6pm,utc
[4] delighted,announce
[4] announce,2nd
[4] 2nd,webinar
[4] webinar,year

Top Word Pairs in Tweet in G6:
[6] fyi,latest
[6] latest,#powerbi
[6] #powerbi,roadmap
[6] roadmap,2021
[6] 2021,wave
[6] wave,#sqlpass
[6] #sqlpass,#msitpro
[6] #msitpro,#msdev
[6] #msdev,#msbi
[6] #msbi,#powerplatform

Top Word Pairs in Tweet in G8:
[7] '#,vs
[7] vs,social
[7] social,media
[6] media,temporary
[6] temporary,tables'
[5] #sqlpass,#sqlserver
[5] registration,details
[4] tables',wednesday
[4] wednesday,february
[4] details,#sqlpass

Top Word Pairs in Tweet in G9:
[3] februar,virtueller
[3] virtueller,deutschlandtournee
[3] deutschlandtournee,18
[3] 18,februar
[3] februar,#azure
[2] wstrasser,februar
[2] #azure,dã
[2] dã,sseldorf
[2] sseldorf,meetup

Top Word Pairs in Tweet in G10:
[4] one,another
[2] love,one
[2] another,shown
[2] shown,absence
[2] absence,one
[2] another,during
[2] during,pandemic
[2] pandemic,presence
[2] presence,please
[2] please,think

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@sqlpass_de
@tgrohser
@redgate
@sqlespresso
@hybridvug
@sqlmisssunshine
@sqlchicken
@dbavug
@wstrasser
@retracement

Top Mentioned in G1:
@tenerifedev
@crossdvlup
@co365
@madriddotnet
@women4tt
@womendot
@riojadotnet
@cartujadotnet
@sug_cat
@rpertusa

Top Mentioned in G2:
@sqlpass_de
@nocentino
@radtravis

Top Mentioned in G3:
@redgate
@_alexyates_

Top Mentioned in G4:
@sqlespresso

Top Mentioned in G5:
@hybridvug
@sqlmisssunshine
@retracement
@sqlpass_de

Top Mentioned in G6:
@sqlchicken

Top Mentioned in G8:
@tgrohser
@dbavug
@tg
@lastpass

Top Mentioned in G9:
@wstrasser

Top Mentioned in G10:
@jenstirrup

Top Tweeters
Top Tweeters in Entire Graph:
@winobs
@dataaugmented
@datachick
@jenstirrup
@lazndamase
@sqlchicken
@beingpunjabi_
@sinclairinat0r
@retracement
@klunkysql

Top Tweeters in G1:
@adriandiaz81
@co365
@netcoreconf
@miguelegea
@dotnetmalaga
@rpertusa
@dotnetters
@riojadotnet
@tenerifedev
@techclubtajamar

Top Tweeters in G2:
@nikoneugebauer
@derfredo
@nocentino
@bweissman
@thrond
@volkerbachmann
@radtravis
@dbberater
@sqlpass_de
@tsql_ninja

Top Tweeters in G3:
@klunkysql
@a_bansal
@redgate
@_alexyates_
@sqlservernerd
@rob_rich
@jmurts
@yangjiayi82

Top Tweeters in G4:
@sinclairinat0r
@sqlespresso
@mundosql
@quarantafilippo
@stridergdm
@dataslugger

Top Tweeters in G5:
@retracement
@_tillmann
@sqlmisssunshine
@jqmtweets
@daisy72718566
@hybridvug

Top Tweeters in G6:
@winobs
@dataaugmented
@lazndamase
@sqlchicken
@beingpunjabi_
@powerplatfrmbot

Top Tweeters in G7:
@sqlmal
@dirkhondong
@mbourgon
@_missdani
@pass_rm_canada
@tculo

Top Tweeters in G8:
@sqlworldwide
@lastpass
@dbavug
@tg
@tgrohser

Top Tweeters in G9:
@wstrasser
@frankgeisler
@brainbug23
@rgmuensterland

Top Tweeters in G10:
@jenstirrup
@sqlbobscot


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.