#SQLHelp, Twitter, 5/15/2021 9:40:46 PM, 254823


FAQ | Problem?

#SQLHelp Twitter NodeXL SNA Map and Report for Saturday, 15 May 2021 at 21:35 UTC
#SQLHelp Twitter NodeXL SNA Map and Report for Saturday, 15 May 2021 at 21:35 UTC
From:
marc_smith
Uploaded on:
May 15, 2021
Short Description:
#SQLHelp via NodeXL https://bit.ly/3uUU2nw
@glennalanberry
@garrettgeier
@sql_handle
@pshore73
@skreebydba
@sqlha
@pareshmotiwala
@dbargenis
@iambt16
@sqlperftips

Top hashtags:
#sqlhelp
#sql
#datascience
#mysql
#postgresql
#python
#sqlserver
#sqlfamily
#index

Description:
Description
The graph represents a network of 58 Twitter users whose recent tweets contained "#SQLHelp", 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 Saturday, 15 May 2021 at 21:35 UTC.

The tweets in the network were tweeted over the 7-day, 5-hour, 6-minute period from Saturday, 08 May 2021 at 13:49 UTC to Saturday, 15 May 2021 at 18:55 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 : 58
Unique Edges : 64
Edges With Duplicates : 20
Total Edges : 84
Number of Edge Types : 5
Retweet : 9
Tweet : 35
Replies to : 24
Mentions : 15
MentionsInRetweet : 1
Self-Loops : 36
Reciprocated Vertex Pair Ratio : 0.0526315789473684
Reciprocated Edge Ratio : 0.1
Connected Components : 26
Single-Vertex Connected Components : 16
Maximum Vertices in a Connected Component : 10
Maximum Edges in a Connected Component : 17
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 1.621212
Graph Density : 0.0120992135511192
Modularity : 0.575432
NodeXL Version : 1.0.1.445
Data Import : The graph represents a network of 58 Twitter users whose recent tweets contained "#SQLHelp", 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 Saturday, 15 May 2021 at 21:35 UTC.

The tweets in the network were tweeted over the 7-day, 5-hour, 6-minute period from Saturday, 08 May 2021 at 13:49 UTC to Saturday, 15 May 2021 at 18:55 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 : TwitterSearch
Graph Term : #SQLHelp
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 : In-Degree

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[2] https://twitter.com/mikeware_tena/status/1392296504447029249
[2] https://www.toptal.com/database/sql-indexes-explained-pt-3
[1] https://www.askorhelp.com/question/how-to-give-acceptable-values-while-creating-a-table-in-mysql/
[1] https://www.askorhelp.com/question/mysql-losing-connection-again-and-again-when-trying-to-make-a-query/
[1] https://docs.microsoft.com/en-us/sql/ssms/solution/solution-explorer?view=sql-server-ver15
[1] https://www.itprotoday.com/sql-server/extract-report-rdl-powershell
[1] https://www.saeeddeveloper.com/2021/05/A-Guide-to-SQL-Data-Analysis-for-Beginners.html
[1] https://support.microsoft.com/en-us/topic/kb3026083-fix-sos-cachestore-spinlock-contention-on-ad-hoc-sql-server-plan-cache-causes-high-cpu-usage-in-sql-server-798ca4a5-3813-a3d2-f9c4-89eb1128fe68
[1] https://www.mssqlplanner.com/monitor-sql-server-and-analyze-ms-sql-server-health-from-any-device/
[1] https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers?view=sql-server-2016

Top URLs in Tweet in G1:
[1] https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers?view=sql-server-2016
[1] https://docs.microsoft.com/en-us/sql/ssms/solution/solution-explorer?view=sql-server-ver15
[1] https://www.askorhelp.com/question/how-to-give-acceptable-values-while-creating-a-table-in-mysql/
[1] https://www.askorhelp.com/question/mysql-losing-connection-again-and-again-when-trying-to-make-a-query/

Top URLs in Tweet in G2:
[2] https://www.toptal.com/database/sql-indexes-explained-pt-3
[1] https://www.saeeddeveloper.com/2021/05/A-Guide-to-SQL-Data-Analysis-for-Beginners.html
[1] https://support.microsoft.com/en-us/topic/kb3026083-fix-sos-cachestore-spinlock-contention-on-ad-hoc-sql-server-plan-cache-causes-high-cpu-usage-in-sql-server-798ca4a5-3813-a3d2-f9c4-89eb1128fe68
[1] https://www.mssqlplanner.com/monitor-sql-server-and-analyze-ms-sql-server-health-from-any-device/

Top URLs in Tweet in G9:
[2] https://twitter.com/mikeware_tena/status/1392296504447029249

Top URLs in Tweet in G10:
[1] https://www.itprotoday.com/sql-server/extract-report-rdl-powershell

Top Domains
Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[72] sqlhelp
[16] sql
[7] datascience
[6] mysql
[4] postgresql
[4] python
[4] sqlserver
[3] sqlfamily
[3] index
[3] database



Top Hashtags in Tweet in G1:
[19] sqlhelp
[3] sql
[2] mysql
[1] dba
[1] database
[1] thanksinadvance
[1] gastronomía
[1] homwwork
[1] programinglovers
[1] codes

Top Hashtags in Tweet in G2:
[10] sqlhelp
[4] sql
[3] index
[2] sqlserver
[2] database
[2] performance
[2] tutorial
[1] sqldataanalysis
[1] programminghumor
[1] programmers

Top Hashtags in Tweet in G3:
[7] sqlhelp

Top Hashtags in Tweet in G4:
[10] sqlhelp
[1] sqlserver
[1] sqlfamily

Top Hashtags in Tweet in G5:
[6] sqlhelp

Top Hashtags in Tweet in G6:
[4] mysql
[4] postgresql
[4] python
[4] sql
[4] sqlhelp
[4] datascience

Top Hashtags in Tweet in G7:
[4] sqlhelp
[2] sql
[1] sqlserver
[1] microsoft
[1] pdw

Top Hashtags in Tweet in G8:
[3] sql
[3] datascience
[3] machinelearning
[3] sqlhelp

Top Hashtags in Tweet in G9:
[2] sqlhelp
[2] sqlfamily

Top Hashtags in Tweet in G10:
[4] sqlhelp

Top Words
Top Words in Tweet in Entire Graph:
[72] #sqlhelp
[24] sql
[16] #sql
[10] data
[10] backup
[9] times
[9] server
[8] functions
[8] table
[7] #datascience

Top Words in Tweet in G1:
[19] #sqlhelp
[4] server
[3] good
[3] #sql
[3] table
[3] field
[3] data
[2] push
[2] database
[2] engine

Top Words in Tweet in G2:
[10] #sqlhelp
[4] #sql
[3] keep
[3] hashtag
[3] community
[3] driven
[3] marketing
[3] promotion
[3] advertising
[3] advice

Top Words in Tweet in G3:
[7] sqlgoddess
[7] #sqlhelp
[5] gbissio
[3] sql
[2] memory
[2] available
[2] azure
[2] database
[2] eta
[2] skreebydba

Top Words in Tweet in G4:
[10] #sqlhelp
[9] backup
[6] compression
[5] sql
[4] times
[3] shaunraustin
[3] page
[3] row
[3] help
[3] reduce

Top Words in Tweet in G5:
[6] #sqlhelp
[3] value
[3] ce
[3] null
[2] garrettgeier
[2] plan
[2] optimize
[2] range
[2] query
[2] job

Top Words in Tweet in G6:
[8] sql
[8] functions
[4] strong
[4] manipulate
[4] characters
[4] words
[4] times
[4] lot
[4] data
[4] prep

Top Words in Tweet in G7:
[4] #sqlhelp
[3] community
[3] generic
[2] keep
[2] hashtag
[2] driven
[2] advertising
[2] promotion
[2] marketing
[2] advices

Top Words in Tweet in G8:
[6] million
[6] dollar
[6] question
[3] sql
[3] query
[3] retriving
[3] cgpa
[3] students
[3] greater
[3] department

Top Words in Tweet in G9:
[2] meant
[2] reply
[2] #sqlhelp
[2] hashtag
[2] awesome
[2] responses
[2] lots
[2] #sqlfamily
[2] follow
[2] respond

Top Words in Tweet in G10:
[4] #sqlhelp
[4] server
[3] ssrs
[2] azure
[2] managed
[2] instance
[2] sql
[2] multiple
[2] servers
[2] database

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[7] #sql,#sqlhelp
[7] #sqlhelp,hashtag
[6] million,dollar
[6] dollar,question
[5] keep,#sqlhelp
[5] hashtag,community
[5] community,driven
[4] sql,strong
[4] strong,functions
[4] functions,manipulate

Top Word Pairs in Tweet in G1:
[2] audit_xe_session_mgr,waits
[2] waits,server
[2] server,audits
[2] audits,#sqlhelp
[2] #sql,#sqlhelp
[2] values,creating
[2] live,data
[2] data,viewer

Top Word Pairs in Tweet in G2:
[3] keep,#sqlhelp
[3] #sqlhelp,hashtag
[3] hashtag,community
[3] community,driven
[2] driven,marketing
[2] marketing,promotion
[2] promotion,advertising
[2] advertising,unsolicited
[2] unsolicited,advice
[2] advice,jokes

Top Word Pairs in Tweet in G3:
[3] gbissio,sqlgoddess
[2] azure,sql
[2] sql,database
[2] gbissio,eta
[2] skreebydba,gbissio

Top Word Pairs in Tweet in G4:
[3] backup,compression
[3] page,row
[3] row,compression
[3] help,reduce
[2] db,mirroring
[2] compression,tables
[2] tables,indexes
[2] restore,times
[2] 2019,avg
[2] sql,2016

Top Word Pairs in Tweet in G5:
[2] key,index
[2] legacy,ce

Top Word Pairs in Tweet in G6:
[4] sql,strong
[4] strong,functions
[4] functions,manipulate
[4] manipulate,characters
[4] characters,words
[4] words,times
[4] times,lot
[4] lot,data
[4] data,prep
[4] prep,#mysql

Top Word Pairs in Tweet in G7:
[2] keep,#sqlhelp
[2] #sqlhelp,hashtag
[2] hashtag,community
[2] community,driven
[2] driven,advertising
[2] advertising,promotion
[2] promotion,marketing
[2] marketing,generic
[2] generic,advices

Top Word Pairs in Tweet in G8:
[6] million,dollar
[6] dollar,question
[3] question,sql
[3] sql,query
[3] query,retriving
[3] retriving,cgpa
[3] cgpa,students
[3] students,greater
[3] greater,department
[3] department,believe

Top Word Pairs in Tweet in G9:
[2] meant,reply
[2] reply,#sqlhelp
[2] #sqlhelp,hashtag
[2] hashtag,awesome
[2] awesome,responses
[2] responses,lots
[2] lots,#sqlfamily
[2] #sqlfamily,follow
[2] follow,respond
[2] respond,tweets

Top Word Pairs in Tweet in G10:
[2] managed,instance

Top Replied-To
Top Replied-To in Entire Graph:
@shaunraustin
@garrettgeier
@skreebydba
@gbissio
@code_is_
@ami_levin
@gbargsley
@pareshmotiwala
@gcufsaeed
@a_bansal

Top Replied-To in G2:
@gcufsaeed
@chandansql
@toptaldevs
@a_bansal
@pshore73

Top Replied-To in G3:
@gbissio
@skreebydba
@retracement
@sqlgoddess

Top Replied-To in G4:
@shaunraustin
@sql_skippy
@garrettgeier
@glennalanberry
@nedotter

Top Replied-To in G5:
@garrettgeier
@pareshmotiwala

Top Replied-To in G7:
@code_is_
@ami_levin

Top Replied-To in G10:
@gbargsley

Top Mentioned
Top Tweeters
Top Tweeters in Entire Graph:
@code_convention
@ipythonistabot
@godfrey_g_
@calefybtech
@sql_handle
@geo_walters
@sqlstudent144
@dbargenis
@sqlha
@retracement

Top Tweeters in G1:
@sqlstudent144
@tjaybelt
@dbabulldog
@nocentino
@sqlworldwide
@stegosource
@millernatii
@steveclementjax
@myvideeoh
@sqlfunkateer

Top Tweeters in G2:
@pshore73
@a_bansal
@sqlperftips
@codingthat
@toptaldevs
@gcufsaeed
@chandansql

Top Tweeters in G3:
@dbargenis
@retracement
@sqlmct
@skreebydba
@gbissio
@sqlgoddess
@dpless

Top Tweeters in G4:
@sqlha
@glennalanberry
@nedotter
@shaunraustin
@sql_skippy

Top Tweeters in G5:
@sql_handle
@pareshmotiwala
@andrewsayer_
@garrettgeier
@indexes

Top Tweeters in G6:
@ipythonistabot
@calefybtech
@raisepostgresql
@iambt16

Top Tweeters in G7:
@hugo_kornelis
@code_is_
@ami_levin

Top Tweeters in G8:
@code_convention
@godfrey_g_
@nelson94008731

Top Tweeters in G9:
@geo_walters
@sqlsocialite

Top Tweeters in G10:
@sqlrunr
@gbargsley


Tags:

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.