Awesome sysadmin
Author: l | 2025-04-25
list awesome sysadmin awesome-list system-administration sysadmin-tasks sysadmin-tool sysadmin-scripts sysadmins system-admin sysadm sysadmin-tools. Updated list awesome sysadmin awesome-list system-administration sysadmin-tasks sysadmin-tool sysadmin-scripts sysadmins system-admin sysadm sysadmin-tools. Updated
awesome-stuff/sysadmin: A list of awesome sysadmin
Share via 0I am working on a task that requires creation of a scheduled SQL Job. I am following the documentation here: trying to access the SQL Server Agent by logging into the server via SSMS, I am unable to view the Agent. Searched about this issue on the web, I came across this: says that one of the possible reasons may be that the Login account connecting to SSMS is not a part of SysAdmin role in SQL Server and thus SQL Server Agent would not be visible.I thus ran the query - Select IS_SRVROLEMEMBER('Sysadmin')and got the output as 0 which meant that the login was not a Sysadmin. Read further and came across this link that talks about SQL Server Agent fixed database roles: doing the following two things:1.Creating a fresh login with sysadmin role - but unable to do so. Getting an error that I do not have permission. Altering role of current login to one of the three SQL Server Agent fixed database roles.ALTER ROLE SQLAgentUserRole ADD MEMBER Again, getting the above error. Can someone please help me on this? Am I doing the right thing? Is there something I am missing?
knowledge/awesome-sysadmin - awesome-sysadmin - Vast
Netwalk-The Sysadmin Nightmare on PCNetwalk-The Sysadmin Nightmare, coming from the developer KrashSoft, is running on Android systerm in the past.Now, You can play Netwalk-The Sysadmin Nightmare on PC with GameLoop smoothly.Download it in the GameLoop library or search results. No more eyeing the battery or frustrating calls at the wrong time any more.Just enjoy Netwalk-The Sysadmin Nightmare PC on the large screen for free!Netwalk-The Sysadmin Nightmare IntroductionIn the game of Netwalk, you are a network administrator, and someone has scrambled your network.Your job is to rotate all the pieces so that every terminal is connected to the server by wires and there are no loose ends in your network.Tap to rotate a tile clockwise, double tap to rotate counter-clockwise. When you are certain of a tile's position, make a long tap on it. The background will change and you won't be able to accidentally rotate it without long tapping the tile again.The less work you need to do to complete your network the better, so Netwalk is scored by the number of clicks it takes you to rotate everything into place. Simultaneous clicks on the same tile will not increase the click counter so you may rotate either way.Similarly, the faster you will complete your network the better, so Netwalk is also scored by the time it takes you to rotate everything into place.There are three levels, different by size: Easy (6x4), Normal (9x6) and Hard (12x8).Infinity levels add extra complexity by allowing wires to wrap from left to right and from top to bottom of the screen.Nightmare level is the most complicated - it is 15x10, infinity, and all tiles with three connections are hidden.GitCroque/awesome-sysadmin-tools: Inspired by Awesome Sysadmin
A user or domain policy changes permissions for the login, you'll see the error that the extension doesn't have correct permissions. The SQL IaaS Agent extension status is unhealthy due to this error.For SQL Server VMs that use the least privilege permissions model, check to make sure the NT Service\SQLIaaSExtensionQuery account has the proper permissions associated with each enabled feature. If no features are enabled, then you'll see the error if the NT Service\SQLIaaSExtensionQuery login doesn't exist within SQL Server or if Microsoft SQL Server IaaS Query Service is running under a different username than NT Service\SQLIaaSExtensionQuery.Some SQL Server VMs deployed before October 2022 may still use the older sysadmin permissions model. For these older VMs, you'll see the permissions error if the NT Service\SQLIaaSExtensionQuery doesn't exist, or doesn't have sysadmin rights within SQL Server, or if Microsoft SQL Server IaaS Query Service is running under a different username than NT Service\SQLIaaSExtensionQuery.To resolve this error condition, confirm the login exists in SQL Server, and that it has the correct permissions based on the features you've enabled. You may need to recreate the login, and/or assign correct permissions. Additionally, validate Microsoft SQL Server IaaS Query Service is running under the username NT Service\SQLIaaSExtensionQuery.Error "image is not supported"The SQL IaaS Agent extension registration is blocked on the following unsupported Azure Marketplace images:Power BI virtual machineSQL Server Analysis ServicesNot valid state for managementRepair the extension if you see the following error message:The SQL virtual machines resource is not in a valid state for. list awesome sysadmin awesome-list system-administration sysadmin-tasks sysadmin-tool sysadmin-scripts sysadmins system-admin sysadm sysadmin-tools. UpdatedGitHub - awesome-stuff/sysadmin: A list of awesome sysadmin
As cron jobs to do the tasks automatically at the proper time.Install and configure live monitoring tools like Nagios, HP, etc., to monitor your IT infrastructure and issue alerts about potential problems.ConclusionWhile these are the most important tasks a sysadmin is responsible for, there is much more to the role than the duties on this list.For example, the sysadmin must coordinate with multiple teams to resolve issues, communicate with and update customers, maintain 100% uptime, hold discussions with the audit team, prepare weekly/monthly/quarterly reports, do continuous monitoring of servers and services using appropriate tools, and maintain the hardware console and respond to any triggered alarms.The sysadmin is always a single point of content (SPOC) in the data center or network operations center for issues related to web hosting, application and server outages, and other critical IT operations problems.What other tasks or best practices do you think are essential for sysadmins? Please share your opinion in the comments. This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License.awesome-stuff/sysadmin: A list of awesome sysadmin resources.
Server, where and what kind?The SysAdmin helps ensure that the machine is there to run the app. Over the past several years, Infrastructure-as-a-Service (IaaS) has emerged as a mode for delivering those machines on-demand, automatically – whether through a public cloud or in a private cloud environment, and increasingly in a hybrid approach. (And despite all the debate it seems that nobody understands the cloud.)However, there’s a gap between the Developer’s application and the SysAdmin’s infrastructure. Enter PaaS, including containers, to provide all the application prerequisites beyond the base OS and server. Now that these container systems provide the layer between apps and infrastructure, VMs can stay skinny and we have a more modular architecture. Everything below the container doesn’t really matter to the developer so they might start to ask the question, “Why do I need IaaS?”This is confusing to the SysAdmin as everything needs infrastructure. But now they need to understand this new container layer: “What is OpenShift/AppFog/Docker? And why do the developers say that they don’t need a VM or a physical server or the network?”There is a great slide in one of the Docker intro decks that talks about separation of duties. Reading between the lines, it shows the divide that I’ve been writing about (see the slide below):In this example, Dan the Developer worries about code, libraries, dependencies, and so on. Oscar the Ops Guy (aka SysAdmin) cares about things outside the container. It’s the same as it’s always been in that everything matters, but the container helps clarify who is responsible for what.Network configuration is one example of something outside the container that demands true IT service delivery management. Stand up a container without proper network config and Oscar will quickly get a call from Dan complaining “the internets are down!” Imagine requesting aAwesome Sysadmin : r/sysadmin - Reddit
Hi,I just got a message (from McAfee firewall) warning that it has intercepted an attack. The following is the report from it. How do I know the attacker's ISP from his IP address (I mean who's his ISP)? On the whole, what should I do ?---------------------------McAfee Visual Trace Version 3.27 ResultsTarget: 203.16.198.14Date: 25-Jun-2004 (Friday), 7:26:33 PMNodes: 2Node DataNode Net Reg IP Address Location Node Name 2 1 1 203.16.198.14 Sydney as-syd-6-14.ozonline.com.auPacket DataNode High Low Avg Tot Lost 2 ---- ---- ---- 8 8Network DataNetwork id#: 1 [whois.apnic.net node-1] Whois data copyright terms 203.16.198.0 - 203.16.198.255netname: AOL6-AUdescr: Australia On Linedescr: Level 4/6 Riverside Quaydescr: Southbank, Victoria 3006country: AUadmin-c: MB84-APtech-c: MB84-APmnt-by: MAINT-AU-MB84-APchanged: [email protected] 20010831status: ALLOCATED PORTABLEsource: APNICperson: Michael Bethuneaddress: Australia On Lineaddress: Level 4address: 6 Riverside Quayaddress: Southbank, Victoria 3006phone: +61 3 9686 1051fax-no: +61 3 9686 1052e-mail: [email protected]: MB84-APmnt-by: MAINT-AU-MB84-APchanged: [email protected] 20010831Registrant DataRegistrant id#: 1Domain Name: ozonline.com.auLast Modified: 21-Sep-2003 23:57:58 UTCRegistrar ID: R00014-ARRegistrar Name: PlanetDomainStatus: OKRegistrant: Australia On-Line Pty LtdRegistrant ID: OTHER 064 289 925Registrant ROID: C0953806-ARRegistrant Contact Name: Ilona WeberRegistrant Email: [email protected] ID: C0953806-ARTech Name: Ilona WeberTech Email: [email protected] Server: dns2.ozonline.com.auName Server IP: 203.4.248.32Name Server: dns3.ozonline.com.auName Server IP: 203.23.155.5Name Server: dns1.ozonline.com.au---------------------------. list awesome sysadmin awesome-list system-administration sysadmin-tasks sysadmin-tool sysadmin-scripts sysadmins system-admin sysadm sysadmin-tools. Updated list awesome sysadmin awesome-list system-administration sysadmin-tasks sysadmin-tool sysadmin-scripts sysadmins system-admin sysadm sysadmin-tools. UpdatedComments
Share via 0I am working on a task that requires creation of a scheduled SQL Job. I am following the documentation here: trying to access the SQL Server Agent by logging into the server via SSMS, I am unable to view the Agent. Searched about this issue on the web, I came across this: says that one of the possible reasons may be that the Login account connecting to SSMS is not a part of SysAdmin role in SQL Server and thus SQL Server Agent would not be visible.I thus ran the query - Select IS_SRVROLEMEMBER('Sysadmin')and got the output as 0 which meant that the login was not a Sysadmin. Read further and came across this link that talks about SQL Server Agent fixed database roles: doing the following two things:1.Creating a fresh login with sysadmin role - but unable to do so. Getting an error that I do not have permission. Altering role of current login to one of the three SQL Server Agent fixed database roles.ALTER ROLE SQLAgentUserRole ADD MEMBER Again, getting the above error. Can someone please help me on this? Am I doing the right thing? Is there something I am missing?
2025-04-11Netwalk-The Sysadmin Nightmare on PCNetwalk-The Sysadmin Nightmare, coming from the developer KrashSoft, is running on Android systerm in the past.Now, You can play Netwalk-The Sysadmin Nightmare on PC with GameLoop smoothly.Download it in the GameLoop library or search results. No more eyeing the battery or frustrating calls at the wrong time any more.Just enjoy Netwalk-The Sysadmin Nightmare PC on the large screen for free!Netwalk-The Sysadmin Nightmare IntroductionIn the game of Netwalk, you are a network administrator, and someone has scrambled your network.Your job is to rotate all the pieces so that every terminal is connected to the server by wires and there are no loose ends in your network.Tap to rotate a tile clockwise, double tap to rotate counter-clockwise. When you are certain of a tile's position, make a long tap on it. The background will change and you won't be able to accidentally rotate it without long tapping the tile again.The less work you need to do to complete your network the better, so Netwalk is scored by the number of clicks it takes you to rotate everything into place. Simultaneous clicks on the same tile will not increase the click counter so you may rotate either way.Similarly, the faster you will complete your network the better, so Netwalk is also scored by the time it takes you to rotate everything into place.There are three levels, different by size: Easy (6x4), Normal (9x6) and Hard (12x8).Infinity levels add extra complexity by allowing wires to wrap from left to right and from top to bottom of the screen.Nightmare level is the most complicated - it is 15x10, infinity, and all tiles with three connections are hidden.
2025-04-13As cron jobs to do the tasks automatically at the proper time.Install and configure live monitoring tools like Nagios, HP, etc., to monitor your IT infrastructure and issue alerts about potential problems.ConclusionWhile these are the most important tasks a sysadmin is responsible for, there is much more to the role than the duties on this list.For example, the sysadmin must coordinate with multiple teams to resolve issues, communicate with and update customers, maintain 100% uptime, hold discussions with the audit team, prepare weekly/monthly/quarterly reports, do continuous monitoring of servers and services using appropriate tools, and maintain the hardware console and respond to any triggered alarms.The sysadmin is always a single point of content (SPOC) in the data center or network operations center for issues related to web hosting, application and server outages, and other critical IT operations problems.What other tasks or best practices do you think are essential for sysadmins? Please share your opinion in the comments. This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License.
2025-04-06