Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
Partycat
Oct 25, 2004

Ha, slammed.

It looked like for residential you can put whatever you want in your house, fume it up. It would have also been somewhat annoying to deal with if you're dealing with closed wall cavities. Nothing wrong with RG6 install though, it still can be used for satellite receivers, cable, antenna, MoCA, bringing video/media between rooms, cameras, etc. Way easier to not use it while it is in the wall than it is to install it once the wall is there any you need it.

Cable jacket rating is important in commercial for sure. It seems like a lot of the one-man-crew IT guys like to just wing cable into the ceiling, zip tie it to pipeworks, etc which is just bad practice for the trade. CMP+ goes anywhere, CMR doesn't, and the CM or unrated is the cheap poo poo but not really a good idea. While my methodology sucks, I like to think I'm trying to encourage people to do better but I realize I'm not going about that the right way.

Adbot
ADBOT LOVES YOU

Thanks Ants
May 21, 2004

#essereFerrari


Avaya have an automatic deployment system for their new SIP-based handsets that works similar to the rest of the industry (Snom, Yealink, Polycom, whatever) - essentially the phone will contact a provisioning server on first boot, and if the MAC is registered by a partner to connect to a specific server, the phone will go off and connect to that. The idea is that you can ship 200 phones out and as long as you've got a record of the details off the labels, you don't need to do any configuration work on the devices themselves.

So far so good. Avaya also have a 'new' :yaybutt:-based SMB telephone service which is a spectacular bodge of their legacy IP Office code chopped up into separate services and deployed as containers on GCP. The deployment service doesn't work with this cloud product, and the cloud product team didn't even know that the deployment service existed when they were asked about it.

This company deserves to fail.

guppy
Sep 21, 2004

sting like a byob
Codes vary by jurisdiction, but generally you can use general-rate (CM/CMG) cable for residential applications. But in residential multi-tenant situations like apartment buildings, riser-rate (CMR) is required. Plenum-rate (CMP) is required in plenum spaces, which is usually not a concern in residential buildings. This is what I was taught, but as always, defer to whatever authority has jurisdiction in your area. IIRC plenum-rate cable actually produces fumes that are worse for you, but burns slower, reducing the spread of flames and allowing you more time to get out of the building.

Partycat
Oct 25, 2004

You know I don’t know if it has ever come up in one of these threads, about a building being on fire and the IT guy trying to put it out or save backups or something.

All of these fire and code ratings, extinguishers, etc are meant to give you a bit more time to get out of the building not hang out or be a hero

Coworker did this, saw smoke coming from the UPS room, and went in for some reason before calling the alarm. Needed treatment for inhaling smoking battery vape.

Partycat fucked around with this message at 12:58 on Nov 18, 2019

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.
But think of my file server, Hobbes, and my domain controller, Calvin!

What about all the VMs running on Kirk, Spock and Bones!

These are my children!

freeasinbeer
Mar 26, 2015

by Fluffdaddy

Agrikk posted:

But think of my file server, Hobbes, and my domain controller, Calvin!

What about all the VMs running on Kirk, Spock and Bones!

These are my children!

I don’t know how exactly my mind got there but now I want to start a service that sledgehammer or shotguns your gear at random to torture people who name their servers.

Super-NintendoUser
Jan 16, 2004

COWABUNGERDER COMPADRES
Soiled Meat

Agrikk posted:

But think of my file server, Hobbes, and my domain controller, Calvin!

What about all the VMs running on Kirk, Spock and Bones!

These are my children!

One of the hardest parts about moving to the cloud is getting clients to understand that servers no longer matter. This metal block in a rack that you've loved and nourished is now just a mouse click and a line of code. It's a really interesting concept.

Raerlynn
Oct 28, 2007

Sorry I'm late, I'm afraid I got lost on the path of life.
poo poo pissing me off: other teams trying to assign me work at 10p without checking with me first. (I'm 7a-3p).

I don't mind putting in a little overtime to flex if it needs doing, but ffs would it kill you to ASK instead of just assuming?

slartibartfast
Nov 13, 2002
:toot:

freeasinbeer posted:

I don’t know how exactly my mind got there but now I want to start a service that sledgehammer or shotguns your gear at random to torture people who name their servers.

Netflix beat ya to it.

cage-free egghead
Mar 8, 2004

freeasinbeer posted:

I don’t know how exactly my mind got there but now I want to start a service that sledgehammer or shotguns your gear at random to torture people who name their servers.

I don't mind people who name their servers, just don't make it named after gods. There's like a 95% chance on reddit that people name one of their homelab servers "zeus".

Nemo2342
Nov 26, 2007

Have A Day




Nap Ghost

cage-free egghead posted:

I don't mind people who name their servers, just don't make it named after gods. There's like a 95% chance on reddit that people name one of their homelab servers "zeus".

We definitely have servers here named Thor and Valhalla :eng99:

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.

Jerk McJerkface posted:

One of the hardest parts about moving to the cloud is getting clients to understand that servers no longer matter. This metal block in a rack that you've loved and nourished is now just a mouse click and a line of code. It's a really interesting concept.

I have a customer who has a senior DBA who is blocking all efforts to move to the cloud. The reason? He like to RDP into SQL servers and launch SQL Server Management Studio on the server as well as using Task Manager to check server health.

Won’t look at RDS SQL Server at all because “you can’t do as much.”


Yeah like worry about patching, uptime, disk space, backups, instance failures, etc. :rolleyes:

Antioch
Apr 18, 2003
Man we are slowly moving all the Line of Business applications over to RDS and Mail/Office to the cloud and it is going to be glorious when it happens.

My favorite part of the whole thing so far was moving a lovely estimating tool from on-prem to cloud and putting a link to the application on RDS. Then we start getting bitchy tickets about things being "unusable" and "slow" and "the server must be pinned". Nope, try again, the server is someone else's problem now, you can contact the vendor direct, gently caress off out my tickets.

freeasinbeer
Mar 26, 2015

by Fluffdaddy

Agrikk posted:

I have a customer who has a senior DBA who is blocking all efforts to move to the cloud. The reason? He like to RDP into SQL servers and launch SQL Server Management Studio on the server as well as using Task Manager to check server health.

Won’t look at RDS SQL Server at all because “you can’t do as much.”


Yeah like worry about patching, uptime, disk space, backups, instance failures, etc. :rolleyes:

RDS SQL Server is a pain in the rear end and has weird limitations. That being said his reasons were the same ones our DBA threw up.


We no longer have a DBA.

Inspector_666
Oct 7, 2003

benny with the good hair

Jerk McJerkface posted:

One of the hardest parts about moving to the cloud is getting clients to understand that servers no longer matter. This metal block in a rack that you've loved and nourished is now just a mouse click and a line of code. It's a really interesting concept.

My only real "server" experience is with AD so the idea of servers as cattle is completely foreign to me and it's absolutely holding my career back so that's cool.

PremiumSupport
Aug 17, 2015

Nemo2342 posted:

We definitely have servers here named Thor and Valhalla :eng99:

Odin and Loki here, and our ESXi server that hosts them is Asgard :eng99:

Super-NintendoUser
Jan 16, 2004

COWABUNGERDER COMPADRES
Soiled Meat

Agrikk posted:

I have a customer who has a senior DBA who is blocking all efforts to move to the cloud. The reason? He like to RDP into SQL servers and launch SQL Server Management Studio on the server as well as using Task Manager to check server health.

Won’t look at RDS SQL Server at all because “you can’t do as much.”


Yeah like worry about patching, uptime, disk space, backups, instance failures, etc. :rolleyes:

Last year a I had to install an application on a RHEL server, but weirdly enough it required xwindows to install it. It was an oracle package of some sort. It stopped a project short because there's no GUI on AWS servers, but I just setup X11 fowarding and took care of it. It was odd, I couldn't even imagine designing a linux app like that.

Hollow Talk
Feb 2, 2014

cage-free egghead posted:

I don't mind people who name their servers, just don't make it named after gods. There's like a 95% chance on reddit that people name one of their homelab servers "zeus".

Just lol if this isn't the base for all of your server naming needs: https://en.wikipedia.org/wiki/List_of_Greek_mythological_figures#Immortals

I use Ares, Erebos, and Hemera

I don't care about naming on my private servers. Work is config + dc + fqdn, e.g. centos-xl-fra1-1-db2.your.name.here

The Fool
Oct 16, 2003


My kingdom for a sane way to sync GAL's between O365 tenants.

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.

freeasinbeer posted:

RDS SQL Server is a pain in the rear end and has weird limitations. That being said his reasons were the same ones our DBA threw up.


We no longer have a DBA.

The essence of RDS SQL server is that it behaves as a mirrored cluster and anything requiring local admin or access to the OS has been obfuscated.

Instead, all the things you probably want to adjust are in your options group, cluster group or are available as stored procedures that manage all the nuances of operating in a mirrored environment for you.

But the only things you really need to do is get your disk size right (so that you aren’t starved for iops) and create an option group with S3 permissions so you can schedule nightly backups straight to S3.

And you aren’t using SQL Server Agent anymore anyways, right?


My favorite use case is from a customer of mine, who programmatically bumps up the database class on the first of the month for an inventory database to handle new inventory data ingest and processing, and related activities. Then on the fifth the database downshifts to a maintenance level for the rest of the month’s ad-how queries. They save thousands a month over their on-Prem setup simply from recognizing the cyclical nature of their workloads.

Agrikk fucked around with this message at 01:28 on Nov 19, 2019

mllaneza
Apr 28, 2007

Veteran, Bermuda Triangle Expeditionary Force, 1993-1952




Goddamnit Java !

I've got the installer and the .cfg file on a network share. I run a PowerShell script which runs the .exe with the path to the .cfg file. Sounds simple, right ?

Having the path to the .cfg file be a UNC path is not supported, you get an error popup. No matter that it's on the same goddamned share as the .exe.

Worse, it worked as recently as u202.

Worse, the bug is resolved, "Unable to reproduce". Which is bullshit.

Anyone with an openjdk.java.net account want to re-open this ?

https://bugs.openjdk.java.net/browse/JDK-8221968

freeasinbeer
Mar 26, 2015

by Fluffdaddy

Agrikk posted:

The essence of RDS SQL server is that it behaves as a mirrored cluster and anything requiring local admin or access to the OS has been obfuscated.

Instead, all the things you probably want to adjust are in your options group, cluster group or are available as stored procedures that manage all the nuances of operating in a mirrored environment for you.

But the only things you really need to do is get your disk size right (so that you aren’t starved for iops) and create an option group with S3 permissions so you can schedule nightly backups straight to S3.

And you aren’t using SQL Server Agent anymore anyways, right?


My favorite use case is from a customer of mine, who programmatically bumps up the database class on the first of the month for an inventory database to handle new inventory data ingest and processing, and related activities. Then on the fifth the database downshifts to a maintenance level for the rest of the month’s ad-how queries. They save thousands a month over their on-Prem setup simply from recognizing the cyclical nature of their workloads.

We want to replicate across regions for reasons. That’s kind of a pain rear end as it stands.

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.

freeasinbeer posted:

We want to replicate across regions for reasons. That’s kind of a pain rear end as it stands.

A huge pain in the rear end, I agree.

Have you looked into replicating using the always-on functionality of DMS?

I’m actually about to start a project using RDS SQL and DMS to set up a replication mesh in three regions. It might be horrible, might be great. Who knows, but where multi-region replication comes in I’m leaning towards horrible,

Especially with a couple of seven billion record tables...

joebuddah
Jan 30, 2005

bobmarleysghost posted:

This triggered me. Our MES frontend is Access and I have dreams of sometimes converting it into a python web app, and then I wake up in a cold sweat.

Have you thought about switching to Igniton?
Its great for MES, and you can dump the data into most SQL Dbs.

nielsm
Jun 1, 2009



Speaking of SQL Server, an instance using all available RAM (0 bytes free) and having sluggish performance in RDP are not at all indicators of trouble, right? Those just seem like indicators that the instance is using all available resources to serve requests, especially when regular query performance from remote applications is fast.

Humphreys
Jan 26, 2013

We conceived a way to use my mother as a porn mule


Min'es called Patrica. I blame it on poo poo going wrong.

bull3964
Nov 18, 2000

DO YOU HEAR THAT? THAT'S THE SOUND OF ME PATTING MYSELF ON THE BACK.


nielsm posted:

Speaking of SQL Server, an instance using all available RAM (0 bytes free) and having sluggish performance in RDP are not at all indicators of trouble, right? Those just seem like indicators that the instance is using all available resources to serve requests, especially when regular query performance from remote applications is fast.

Sounds like someone didn't set an upper memory bound in SQL and are possibly running it with locked pages.

Bob Morales
Aug 18, 2006


Just wear the fucking mask, Bob

I don't care how many people I probably infected with COVID-19 while refusing to wear a mask, my comfort is far more important than the health and safety of everyone around me!

http://fmsinc.com/MicrosoftAccess/Errors/query_is_corrupt/

ha
Ha
hahahahaha
Critical Alert: Query is Corrupt, Error 3340
Microsoft's ResponseA set of Microsoft Office security updates released on November 12, 2019 causes Access databases to fail when it runs Update Queries to modify data.
We are in touch with the Microsoft Access development team and do not have a clear answer on what went wrong and how something so serious was released to the world.

We share your concern that security updates like this cause a bigger problem than the viruses or malware they are attempting to block.

klosterdev
Oct 10, 2006

Na na na na na na na na Batman!
Coworker had to figure that out yesterday. Worst part is MS was just like "Here's a workaround for running affected queries, we'll release a fix next Patch Tuesday"

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.

nielsm posted:

Speaking of SQL Server, an instance using all available RAM (0 bytes free) and having sluggish performance in RDP are not at all indicators of trouble, right? Those just seem like indicators that the instance is using all available resources to serve requests, especially when regular query performance from remote applications is fast.

By default SQL Server will grab all the memory it can out of an instance for its operation. Normally it will leave a small percentage free for the OS but in certain situations it will take literally everything and starve the OS of memory. That’s what sounds like is happening here.

Like bull3964 said, You can prevent that from happening by setting an upper bound for what SQL Server will take to keep the OS healthy and the SQL Server happy. I think the rule of thumb was leave 2-3 GB free for the OS on a dedicated database server.

Just to be sure you probably want to check memory pressure of your database instance to see if your box could do with more ram.

freeasinbeer
Mar 26, 2015

by Fluffdaddy

Agrikk posted:

A huge pain in the rear end, I agree.

Have you looked into replicating using the always-on functionality of DMS?

I’m actually about to start a project using RDS SQL and DMS to set up a replication mesh in three regions. It might be horrible, might be great. Who knows, but where multi-region replication comes in I’m leaning towards horrible,

Especially with a couple of seven billion record tables...

I forget the exact reason, but we couldn’t use DMS for some reason, and the AWS recommended option was: https://aws.amazon.com/marketplace/seller-profile?id=9336c2be-e8bf-4d8e-869c-c11d1fd975ce

Which is a trash heap.

Raerlynn
Oct 28, 2007

Sorry I'm late, I'm afraid I got lost on the path of life.

Agrikk posted:

By default SQL Server will grab all the memory it can out of an instance for its operation. Normally it will leave a small percentage free for the OS but in certain situations it will take literally everything and starve the OS of memory. That’s what sounds like is happening here.

Like bull3964 said, You can prevent that from happening by setting an upper bound for what SQL Server will take to keep the OS healthy and the SQL Server happy. I think the rule of thumb was leave 2-3 GB free for the OS on a dedicated database server.

Just to be sure you probably want to check memory pressure of your database instance to see if your box could do with more ram.

Fun fact, out of the box the upper limit on SQL server is 2TB. This is why it grabs all the memory beyond what Windows has locked up.

Coincidentally this is also the maximum amount of memory SQL Server can handle.

stevewm
May 10, 2005

Agrikk posted:

By default SQL Server will grab all the memory it can out of an instance for its operation. Normally it will leave a small percentage free for the OS but in certain situations it will take literally everything and starve the OS of memory.


We had this happen.. Our EDI software company didn't bother to set a limit when they installed SQL Server. It happily gobbled up every single bit of the 48GB available causing other operations to fail.. Kinda dumb the default setting is to starve the OS.

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.
Seriously. How hard would it have been to put in a line like

Set sql_max_mem = server_mem - 4GB


as a starting place?

I know that you’d have to reset it if you ever added memory to the box, but if you added memory, wouldn’t you have memory on the brain and think about performance tuning your server anyway?

Sickening
Jul 16, 2007

Black summer was the best summer.

Agrikk posted:

Seriously. How hard would it have been to put in a line like

Set sql_max_mem = server_mem - 4GB


as a starting place?

I know that you’d have to reset it if you ever added memory to the box, but if you added memory, wouldn’t you have memory on the brain and think about performance tuning your server anyway?

I am 99% certain that microsoft has suggested this as a best practice for years.

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.

Sickening posted:

I am 99% certain that microsoft has suggested this as a best practice for years.

My point is why couldn’t Microsoft adopt this during the installation process? Why leave this in the hands of the installer as part of the post installation process?

I mean, we do this for RDS SQL Server for you (in addition to a bunch of other configuration tweaks and performance enhancements) so why can’t Microsoft?

Sickening
Jul 16, 2007

Black summer was the best summer.

Agrikk posted:

My point is why couldn’t Microsoft adopt this during the installation process? Why leave this in the hands of the installer as part of the post installation process?

I assume its something to do with making the software easy to install. Its like vmware not making NTP a required opt out part of the installation.

ConfusedUs
Feb 24, 2004

Bees?
You want fucking bees?
Here you go!
ROLL INITIATIVE!!





The company I'm working for is being acquired.

New CEO is doing a Q&A. When asked about remote workers, he said the company prefers everyone to be together, and only 10% of their workforce is remote.

That means I'm hosed, as I'm full-time remote and there's no office within 500 miles of me.

I guess this means I'm in the market for a new job. Anyone need a guy whose expertise is data analysis to find opportunities to improve products and process?

bull3964
Nov 18, 2000

DO YOU HEAR THAT? THAT'S THE SOUND OF ME PATTING MYSELF ON THE BACK.


There are also different ways to configure memory and that setting doesn't mean what people think it means. The setting is for the buffer pool, memory consumed by the engine for running queries and plan caches are outside that Max setting. Also, that means that SQL is not limited to only 2tb of RAM, only the buffer pool is. The sql engine can scale to the OS max.

Although it's not recommended, you probably won't notice much performance degradation (depending on workload) if you don't set the max as long as you don't have locked pages set. The OS will page out parts of the buffer pool if there are other memory demands and as long as you aren't utilizing the whole buffer pool, you probably won't get bitten.

If you lock pages in memory though and don't set a max (and a host reservation if you are virtual) you are in for a world of fun things breaking in interesting ways as memory pressure mounts.

Adbot
ADBOT LOVES YOU

Sickening
Jul 16, 2007

Black summer was the best summer.

ConfusedUs posted:

The company I'm working for is being acquired.

New CEO is doing a Q&A. When asked about remote workers, he said the company prefers everyone to be together, and only 10% of their workforce is remote.

That means I'm hosed, as I'm full-time remote and there's no office within 500 miles of me.

I guess this means I'm in the market for a new job. Anyone need a guy whose expertise is data analysis to find opportunities to improve products and process?

Goondolences.

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply