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.
 
  • Locked thread
stubblyhead
Sep 13, 2007

That is treason, Johnny!

Fun Shoe

larchesdanrew posted:

Yep, same job, I should have taken that as a serious omen at the time.

I live in Columbus, MS. I dare someone to find an IT related job, much less one offering more than minimum wage :jerkbag:

Yuuuup probably time to start seriously thinking about relocating. Tupelo doesn't look all that far away, or does your wife's health kind of preclude that much of a commute?

Adbot
ADBOT LOVES YOU

bitterandtwisted
Sep 4, 2006




re: backup chat.
All our client's backups are the responsibility of the greenest and dumbest whose time is the least valuable - i.e., me. My predecessor would let backups fail for weeks and sometimes months on end.
After the two cryptowall attacks, I feel valued for my heroic competence.

Sheep
Jul 24, 2003
"Let's entrust the most valuable operations to the least valuable person" sounds like a solid business strategy. Do you handle invoicing and payroll as well?

chemosh6969
Jul 3, 2004

code:
cat /dev/null > /etc/professionalism

I am in fact a massive asswagon.
Do not let me touch computer.

bitterandtwisted posted:

re: backup chat.
All our client's backups are the responsibility of the greenest and dumbest whose time is the least valuable - i.e., me. My predecessor would let backups fail for weeks and sometimes months on end.
After the two cryptowall attacks, I feel valued for my heroic competence.

Many years ago at the school I work at, the system crashed and nobody tested backups before, so none of them worked. For months, people had to reenter in all the transactions that were recorded on paper.

A few year ago, the financial aid server crashed, losing about a days worth of data, and the main IT dept was freaking out because they hadn't been backing up that virtual server. We had been because even though they'd been saying they were doing it, better to be safe than sorry, so we got the data back, other than a few hours between the backup and the crash.

Then they started looking at how we were doing our backups and they said it wasn't secure because we weren't compressing the data. There solution was to write a script that included that part but they also included the root password account for the db so it would work.

When I brought up the fact that wasn't making anything more secure, I got an answer that didn't make sense and in retaliation, one of them took down a web server in the middle of the afternoon to update it. I found out about that when people started calling in saying they were on the site and now it wasn't available anymore.

Off topic, has anyone else run across a place that assigns emails by job title, so when a new person comes in, the email address doesn't need to change? If so, is there one that doesn't ever reorganize responsibilities?

stevewm
May 10, 2005
Anyone have any recommendations for a proper and safe way to backup MS SQL databases off-site/to the cloud?

We have 3 Server 2008 R2 SQL databases, about 67GB in size total. Each database sees 2-5GB of changes per day. Right now we take log backups every hour, and a full backup every night that are stored on removable disks (RDX-like disk cartridges). The full .BAK files as generated by SQL Server are 56GB currently.

My problem is that the sending site has a 10Mbit upload, and only a 6 hour window in which it could be fully utilized. So uploading the .BAK files nightly definitely out of the question.

Does anything exist out there that can perform a safe, off-site backup while only transferring changes/deltas? From what I can find, the general consensus is that the only safe SQL backup is the one generated natively by SQL Server. But .BAK files seem to have so many changes from day to day that it renders delta based solutions (like rsync for example) useless; they end up transferring nearly the entire file again.

Trastion
Jul 24, 2003
The one and only.
A call came in... at 4:30pm, We leave at 5pm.

:btroll: My mouse stopped working. I need a new one.

:) Ok I will be right over.

I swap out the mouse and the new one doesn't work either. So I check and the whole computer is locked up. No biggie. Reboot. Doesn't start up.

:) Seems the computer is broke. I have one I can swap in so you can finish the day but you will have to use Citrix to get to your stuff.

They use Citrix already from home so it is no big deal and I already had this machine in a cube nearby for another user (who lasted barely 2 weeks) that was going to work from home via Citrix to train on.

So I setup that computer and today I get in and get to setting up a new machine for :btroll: because she was on the list for an upgrade anyways.

I get everything setup and ready. I go to her desk to ask when she will ahve time for me to swap out the machines.

:) When is a good time to swap things out? There may be a couple things that need to be setup but it shouldn't take long.

:btroll: I leave today at 3pm can you do it then.

:) Sure. Will you be in tomorrow morning? There may be a couple things that we will need to tweak.

:btroll: No I am going on vacation. I am off tomorrow and all of next week.

:) Wow, OK. Glad I made it a priority to get this machine setup for you this morning. I guess I can swap it in sometime next week then.



My users aren't usually bad but sometimes I just want to strangle someone.

Dr. Arbitrary
Mar 15, 2006

Bleak Gremlin

Methylethylaldehyde posted:

It was update drivers to a thing. I could do that on a loving AS/400 given a machine with google and 10 minutes of question time. Dude lied on his resume and booked it when he figured out he had no loving clue.

Wait, was the machine in question AS/400 or are you just using that as an example?

Did he claim to have AS/400 experience on his résumé?

GreenNight
Feb 19, 2006
Turning the light on the darkest places, you and I know we got to face this now. We got to face this now.

I hope it wasn't an AS400, cause we have one of them here and I'd walk if I had to do anything on it too.

spankmeister
Jun 15, 2008






i'd do it b/c it seems like fun

you know, if it's not mission critical or anything :shepicide:

GreenNight
Feb 19, 2006
Turning the light on the darkest places, you and I know we got to face this now. We got to face this now.

Ours is just our home brew ERP system that's been custom programmed since the early 80's.

blackswordca
Apr 25, 2010

Just 'cause you pour syrup on something doesn't make it pancakes!
So a gongshow has been happening over the last few months.

A printer was sent to one of the client sites. I was given a ticket to set it up. I am not supposed to do that, but the company figured I was on site anyways so I could do it and save them some money. So I unpackage and setup the printer, it was shipped in a single row of bubble wrap with a full ream of paper in the tray and all the toner installed. The toner of course had exploded everywhere during shipping. I hooked it up anyways, it started up but would just error out on print jobs. Sent an email out to have a printer tech out to fix it.

Turns out the printer was supposed to be for sales and some of the managers decided on their own that the printer was to be for shipping. After a bunch of back and fourths and the managers who told me to set it up for shipping claiming I lost the printer, 'found' it and the service tech eventually went out.

Very eventually

The printer was originally from a different client site but moved. I had provided the printer department with contact names and locations of the printer currently. So after a week the site contact received a call from the printer tech in the original city the printer was installed in a different province. It took almost two more weeks of back and fourth before the tech was dispatched to the right site. It was moved and 'fixed' ( we don't know if it is yet ) but the tech didnt plug it into the network jack. He told the sales guy I had to go onsite and do that, but didnt tell me.

Gucci Loafers
May 20, 2006

Ask yourself, do you really want to talk to pair of really nice gaudy shoes?


GreenNight posted:

I hope it wasn't an AS400, cause we have one of them here and I'd walk if I had to do anything on it too.

If there's maintenance on it just call IBM and they'll walk you through it all.

GreenNight
Feb 19, 2006
Turning the light on the darkest places, you and I know we got to face this now. We got to face this now.

Yes, but luckily I have absolutely nothing to do with it. We are getting a new AS400 this year though which is nice.

Gwaihir
Dec 8, 2009
Hair Elf

GreenNight posted:

Yes, but luckily I have absolutely nothing to do with it. We are getting a new AS400 this year though which is nice.

New ones are pretty nice hardware wise!

Meanwhile, a ticket came in:

"Hi, we'd like to get a report of all cases with closure dates in the future."

:psypop:

I was tempted to reply back with either just "lol?" or a list of every currently open case (Only 67,672 of them!!!), because after all, they're going to be closed at some point!

GreenNight
Feb 19, 2006
Turning the light on the darkest places, you and I know we got to face this now. We got to face this now.

AS400 licensing is the most bullshit poo poo I've ever seen. So the unit we're getting has 8 cores. You have to license the OS for each core. If you license all 8 cores, then you need to buy each software package for 8 cores. If you license 8 cores for OS, then you need 8 licenses for each software package too.

Our current AS400 is like pre-Pentium 3 power. So to move a lot of these software packages over is costs tens of thousands of dollars just in licensing.

Gwaihir
Dec 8, 2009
Hair Elf
License fees are loving heinous, but that's just "Welp, 'enterprise software'" and that's that.

The biggest issue I've run in to with 400 stuff is that a lot of the people that make tools for it are solo one guy shops that don't want to put up with the hassle that is going through what we need to buy stuff from them as a government entity.

Nerdrock
Jan 31, 2006



feels good, man.

m.hache
Dec 1, 2004


Fun Shoe

Nerdrock posted:



feels good, man.

Take off those filters :v:

Nerdrock
Jan 31, 2006

m.hache posted:

Take off those filters :v:

pshh. :)

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!

Dick Trauma
Nov 30, 2007

God damn it, you've got to be kind.
My Microsoft Project list is up to 13 major projects. And now there's the possibility I'll have to oversee construction of a 100k square foot datacenter. So... not going to have to worry about being bored for a couple of years.

Moey
Oct 22, 2010

I LIKE TO MOVE IT

Dick Trauma posted:

oversee construction of a 100k square foot datacenter.

This sounds like fun.

Cavepimp
Nov 10, 2006

stevewm posted:

Anyone have any recommendations for a proper and safe way to backup MS SQL databases off-site/to the cloud?

We have 3 Server 2008 R2 SQL databases, about 67GB in size total. Each database sees 2-5GB of changes per day. Right now we take log backups every hour, and a full backup every night that are stored on removable disks (RDX-like disk cartridges). The full .BAK files as generated by SQL Server are 56GB currently.

My problem is that the sending site has a 10Mbit upload, and only a 6 hour window in which it could be fully utilized. So uploading the .BAK files nightly definitely out of the question.

Does anything exist out there that can perform a safe, off-site backup while only transferring changes/deltas? From what I can find, the general consensus is that the only safe SQL backup is the one generated natively by SQL Server. But .BAK files seem to have so many changes from day to day that it renders delta based solutions (like rsync for example) useless; they end up transferring nearly the entire file again.

Take a look at Unitrends and their "incremental forever" style backups. I haven't used it heavily, but have used it for a few systems and it has worked well.

Nerdrock
Jan 31, 2006

Full disclosure : Long term projects aren't in our ticketing system. I'm drowning in those, but it's a "friday" afternoon here and I have a severe case of the fuckits.

MJP
Jun 17, 2007

Are you looking at me Senpai?

Grimey Drawer
In my performance review (square in the middle, because "knock off the top category, because that means absolute perfection") where my boss asks for my pain points and my big one is that I'm doing too much helpdesk (sysadmin, we have a helpdesk guy) the end of the meeting is my boss getting an IM from the CFO and asking me to troubleshoot it.

Despite being fairly happy here I think it's time to put the ol' resume back on Dice and Monster.

Knormal
Nov 11, 2001

Gwaihir posted:

"Hi, we'd like to get a report of all cases with closure dates in the future."

:psypop:

I was tempted to reply back with either just "lol?" or a list of every currently open case (Only 67,672 of them!!!), because after all, they're going to be closed at some point!
Maybe they meant that in the future, they'd like a report of all cases with closure dates? Just send them a list of all the closed cases in a few days.

Serious answer, any chance they're troubleshooting bad coding that lets people enter future dates for closures when it should be validating that against the current time/date? That could be a legitimate issue.

Moey
Oct 22, 2010

I LIKE TO MOVE IT

Nerdrock posted:

Full disclosure : Long term projects aren't in our ticketing system.

This is the way to do it. I am trying to convince the dummies here to remove projects that are multi year from our ticketing system.

We also have tickets open from 2009 as a "reminder" to not overwrite some tape backups for some litegation process. That should be a ticket you jerks.

Thanks Ants
May 21, 2004

#essereFerrari


Several automated alerts came in: http://www.bbc.co.uk/news/uk-england-london-32157618

Vast areas of central London have been without power since yesterday afternoon, and the cable ducts that are on fire contain an awful lot of fibre cabling. Fortunately our clients affected realise there is absolutely nothing that we can do to help them. The ones that previously weren't interested in a business continuity plan suddenly want to talk.

Alighieri
Dec 10, 2005


:dukedog:

Moey posted:

This sounds like fun.

You would slowly lose your mind over it as accounting slowly does away with everything you wanted due to cost cutting and you are left with a few box fans to cool everything.

Gwaihir
Dec 8, 2009
Hair Elf

Knormal posted:

Maybe they meant that in the future, they'd like a report of all cases with closure dates? Just send them a list of all the closed cases in a few days.

Serious answer, any chance they're troubleshooting bad coding that lets people enter future dates for closures when it should be validating that against the current time/date? That could be a legitimate issue.

Yea, I was joking because as soon as they put it in I knew it was a bad code check (Tonssss of stuff we have is to check for lovely vendor code). The current date auto-populated in the closure date field when you go to close something.. but the user can actually change it.

18 Character Limit
Apr 6, 2007

Screw you, Abed;
I can fix this!
Nap Ghost

Alighieri posted:

You would slowly lose your mind over it as accounting slowly does away with everything you wanted due to cost cutting and you are left with a few box fans to cool everything.

A flashback came in where I got to expense a 42" barn fan during a multiday power outage. Because geniuses put only one of three chillers on UPS.

Volmarias
Dec 31, 2002

EMAIL... THE INTERNET... SEARCH ENGINES...

blackswordca posted:

So a gongshow has been happening over the last few months.

A printer was sent to one of the client sites. I was given a ticket to set it up. I am not supposed to do that, but the company figured I was on site anyways so I could do it and save them some money. So I unpackage and setup the printer, it was shipped in a single row of bubble wrap with a full ream of paper in the tray and all the toner installed. The toner of course had exploded everywhere during shipping. I hooked it up anyways, it started up but would just error out on print jobs. Sent an email out to have a printer tech out to fix it.

Turns out the printer was supposed to be for sales and some of the managers decided on their own that the printer was to be for shipping. After a bunch of back and fourths and the managers who told me to set it up for shipping claiming I lost the printer, 'found' it and the service tech eventually went out.

Very eventually

The printer was originally from a different client site but moved. I had provided the printer department with contact names and locations of the printer currently. So after a week the site contact received a call from the printer tech in the original city the printer was installed in a different province. It took almost two more weeks of back and fourth before the tech was dispatched to the right site. It was moved and 'fixed' ( we don't know if it is yet ) but the tech didnt plug it into the network jack. He told the sales guy I had to go onsite and do that, but didnt tell me.

Plugging it in would be entrapment.

So, on the subject of open tickets, I changed teams yesterday, which means I got to bulk reassign all of my old tickets to the person tasked with taking over my old role. The new team is to write a project from scratch (basically) so there's no outstanding issues to be assigned.

My bug count is zero.

:feelsgood:

nexxai
Jul 17, 2002

quack quack bjork
Fun Shoe

Trastion posted:

A call came in... at 4:30pm, We leave at 5pm.

...stuff...

:btroll: I leave today at 3pm can you do it then.

Did you travel back in time during this ticket?

Haquer
Nov 15, 2009

That windswept look...

nexxai posted:

Did you travel back in time during this ticket?

Reads to me like he did it the next day?

nothingtrend
Oct 26, 2004

Call came in yesterday for the mouse, tried to deploy the new system today from what I read

Volmarias
Dec 31, 2002

EMAIL... THE INTERNET... SEARCH ENGINES...

nexxai posted:

Did you travel back in time during this ticket?

... Did you, while reading the post?

Trastion
Jul 24, 2003
The one and only.

nexxai posted:

Did you travel back in time during this ticket?

Yes, Yes I did.

It was the next day that I was going to swap the computer out.

KillHour
Oct 28, 2007


Dr. Arbitrary posted:

Wait, was the machine in question AS/400 or are you just using that as an example?

Did he claim to have AS/400 experience on his résumé?

I do actually have AS/400 experience listed on my resume.... I hope to God I never have to actually use that experience.

Proud Christian Mom
Dec 20, 2006
READING COMPREHENSION IS HARD
    * Has successfully worked around an AS/400 system and not caused any sort of failure that would require the assistance of an AS/400 Specialist

Adbot
ADBOT LOVES YOU

ilkhan
Oct 7, 2004

You'll be sorry you made fun of me when Daddy Donald jails all my posting enemies!

go3 posted:

    * Has successfully worked around an AS/400 system and not caused any sort of failure that would require the assistance of an AS/400 Specialist
Your resume just got tossed for lying.

  • Locked thread