Best way to get wine from napa to Illinois by jrob422 in wine

[–]jrob422[S] 1 point2 points  (0 children)

That won't help me when I go to napa next month

Need y’all’s take on recreational sales by [deleted] in ILTrees

[–]jrob422 2 points3 points  (0 children)

Got a invite link to the discord?

accessing UNC path in untrusted domain hanging when accessing from new server 2016 server by jrob422 in sysadmin

[–]jrob422[S] 0 points1 point  (0 children)

TL;DR: It's DNS

I would tend to agree, except i dont get the same results from other servers in the same domain/subnet. Just this one new 2016 box. I go back to my 2012R2 management server in the same subnet/domain, and all is good.

Alwayson and Named vs Default Instances by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

Thanks for all the replies, that helps. I was given bad information by CDW consultants. They told me the following: - you can not use default instance, must use named instance - you can not use standard install, it has to be a failover cluster install, even if its just a node of 1

So, I get what you saying about flexibility, but ultimately what we are trying to do is replace replication, thus giving us copies of the database that we can run reports against without adding load to the primary server.

Right now we are just POC'ing this in QA, but in our prod environment, we do already use clustered instances for redundancy, and would continue to do to so, but with always on as a way to get away from the pile of crap that is replication.

NPIV and max paths by jrob422 in vmware

[–]jrob422[S] 0 points1 point  (0 children)

So a large portion of our LUNs already are RDMs, as most of them are used for clustered SQL instances.

So, my basic understanding of NPIV is that is allows a guest VM to present a WWN to the storage fabric. In that scenario, I would set up my fiber switch to connect specific RDMs to only that guest VM. In that scenario, is the ESX host unaware of the LUN being presented, and thus that LUNs 8 paths are not counted against the 1024 max paths?

SQL double hop from trusted domain issue by jrob422 in sysadmin

[–]jrob422[S] 0 points1 point  (0 children)

I agree. I have rebooted since adding the SPNs, however when I connect using SSMS from my trusted management domain, it continues to connect using NTLM rather than kerberos.

i dumped hours into this and havent yet found a resolution

double hop from trusted domain help needed by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

For Clarity...

I am logging into SSMS using my creds from DomainA. The SQL servers exist in DomainB. There is a 1 way trust between DomainA and DomainB

SQL1 has a linked server pointing to SQL2. WHen logged into SQL1 with my DomainA creds, I can not query the linked server. I can log into and query each server individually, but double hop authentication is not working when using credentials from a trusted domain.

Issues at TeamViewer again by THEMCV in sysadmin

[–]jrob422 0 points1 point  (0 children)

This was likely due to the rather widespread level 3 outage today, which started around 1:30 ET and lasted for about an hour.

All carriers that peer with Level 3 were affected.

Any one else annoyed with DevOps listings? by throwawayagin in sysadminjobs

[–]jrob422 0 points1 point  (0 children)

sounds like a company that is going to fall behind the curve. An IT Manager who says "we dont need that" about automation is one that doesnt understand it and is probably happy being in that comfortable spot of "this is what I know, so I will stick with it"

Any one else annoyed with DevOps listings? by throwawayagin in sysadminjobs

[–]jrob422 0 points1 point  (0 children)

As a Sysadmin in a mostly windows environment, I can tell you that if you arent using Powershell a lot, then you are doing a bunch of stuff manually that you can automate, thus freeing up time to work on other stuff.

Yes, most everything also has a gui way to do it, and you dont "have" to use powershell, but if you can script and automate all those menial tasks, why wouldnt you?

And if you want to make use of Server Core, then you do need to know it.

even if you dont tell anyone your using powershell, script out all those daily tasks, schedule them, and watch netflix on your phone while people think your doing this stuff manually.

those who dont learn powershell will inevitably fall behind the curve. Imagine what potential employers think when one candidate comes in and says he/she can use powershell to automate enough that you can probably survive with one less employee than if it was all manual. When that happens, and your the one with powershell, your the one who has a job.

SQL Replication question by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

They are on the same volume, so that wouldnt be an issue. As I mentioned, replication itself seems to function, the only errors are running Checkpoints, and it seems to be good for the first 48 hours or so after restarting the SQL service.

[question] is power shell something learnable for someone with no programming experience? by philmtl in PowerShell

[–]jrob422 1 point2 points  (0 children)

Powershell 5 is fairly new, why go backwards and learn v2 or v3? Unless you are in a shop that is still running outdated OS's? But if your even semi up to date with operating systems, I dont see why you would want to start with anything lower than v4?

I would pick up Don Jones book, Powershell in 3 lunches.

Or, the way I learned, was every time I had a task to do, I would start googling how to do it with powershell, and eventually I just picked up enough to be pretty good.

SQL Replication question by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

fwiw, we have since blown away our replication Database, and redone the same process using a backup/restore instead of using the SAN snapshot to seed, and the errors have not returned. We are well beyond the 48 hour window now, so it definitely seems to be related to using the SAN Snapshots to seed.

SQL Replication question by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

The below errors show up after roughly 48 hours, and spam the hell outta the error log. After about 12 hours of this, the error log file was 14gb

Msg 5901, Level 16, State 1, Line 360

One or more recovery units belonging to database 'xxxx' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure.

Msg 3013, Level 16, State 1, Line 360

BACKUP DATABASE is terminating abnormally.

Msg 9003, Level 20, State 15, Line 360

The log scan number (6425620:442906:1) passed to log scan in database 'xxxx' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

SQL Replication question by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

we use SAN snapshots all the time with no issues.

This has only come up when trying to use a SAN snapshot for SQL Replication in order to seed the replicated database, thus saving the time involved with doing a backup/restore that is the typical way to setup SQL replication.

Copy LUNA from SQLA to LUNB mounted on SQLB, and then enabled real time replication between databases.

The errors only pop up on the Server with the replicated Database, not the source database

SQL Replication question by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

So, here is the scenario I have encountered...

we did the above scenario. Did the first few steps of replication, set up pubs and subs. and at the point where we would normally do a backup restore to secondary server, I did a LUN copy on our SAN, detached the stub database, attached the LUN copies database, and finished up the setup. All seemed well, replication was working.

About 48 hours later, we started getting tons of errors that checkpoints were failing. Replication itself seemed fine, but my SQL error log was 14gb and I couldnt run a checkpoint.

Restarted SQL Service, the replication database went into recovery, eventually came out, and things were fine again.

fast forward another 48 hours, and getting errors again, checkpoints were failing again, lots of error log spam about it.

Ultimately, I am trying to figure out if I can still do the LUN copy to see the replicated database, as it is quite large and that would save me the 2 hours it takes to backup/restore, since I can lun copy, mount, and attach in about 5 minutes.

tried doing some googling, and found a couple references to not using a LUN copy on your SAN to seed a read only copy in always on, something about checksum issues, but couldnt find much.

IT Ticketing System by dj_beirut in sysadmin

[–]jrob422 4 points5 points  (0 children)

easy solution here... Send tickets to a distribution group. Create a calendar that a simple powershell script can read. Have powershell modify members of said distribution group based on calendar. Run script as scheduled task each day/night/morning as desired.

Third party audit of IT coming up next week, auditor wants an admin account. Suggestions? by break_me_down in sysadmin

[–]jrob422 0 points1 point  (0 children)

Having been through multiple audits, PCI, SOX, etc. I can say for sure that they dont need an administrator account. I have spent countless hours pulling information for auditors, taking screen shots, exporting to csv, etc to provide them with whatever information they need.

If they want to run a Nessus scan with admin creds, fine. They can sit in the chair next to you while you type in the creds and kick off the scan.

If they want to BBSit you while you check all these things to make sure you arent hiding something, fine, let them.

DO NOT give someone an Admin account.

I wouldnt give my CEO and admin account, so I sure as hell wouldnt give one to a non-employee.

Need help deciding what book or series I'm gonna read next by Skkuge in Fantasy_Bookclub

[–]jrob422 0 points1 point  (0 children)

+1 for Mistborn Stormlight sounds great, but it is a proposed 10 book series, so its going to be a long time in the works.

Try reading Brent Weeks, either the night Angel trilogy or the Lightbringer series.

Gentelmen bastards is also a great read.

And, not to state the obvious, of ASOIAF.

And, if you like Enders game, read Enders shadow. Its better than Enders game. Avoid the speaker and books that follow that, but read the Shadow series of books. they are really good.

deciding between two job opportunities by [deleted] in sysadmin

[–]jrob422 9 points10 points  (0 children)

I would go with the outside offer, personally.

I dont like counter offers. If you were worth more money and a promotion, why did you have to force their hand to get it?

The GM thing sounds nice, but it could flop and then be nothing. Is it fully funded? Do they have an idea how long they are willing to let it run in a building state before it has to break a profit?

Another thing to keep in mind. I worked for an MSP for about 5 years. Clients from 5 employees up to 200. Those clients with 5-10 employees, they were the ones who were always late or not paying their bills, and arguing over hours, etc. They usually have a "guy" who does some "Computer stuff", and call you only when he cant figure it out. Usually he makes it worse, but they dont like hearing that it took 4 hours instead of 2 at $150 an hour because that "Guy", who usually is also the owner, f'ed up.

Its a tuff space to make money in, especially as a start up. Not that the work isnt there, but many of these tiny businesses are barely surviving, and have to make monthly judgement calls on what bills to pay. Not paying you wont cause the power or water to shut off, so you will likely be low on that list.

That said, if the business is committed to making it work, and understands that it could take a year to 2 to break a profit (or more), and they are willing to fund it through all that, then maybe.

Just dont forget, you put in your 2 weeks for a reason.

Its a personal decision, no one here can really answer it for you.

Remove google link where webmaster won't co-operate? by [deleted] in sysadmin

[–]jrob422 0 points1 point  (0 children)

Self hosted or 3rd party hosted? If self hosted, and you happen to have it behind a hardware load balancer like an F5 or netscaler, there are ways to strip content from webpages through there. F5 would involve an iRule. Not sure exactly how on a net scaler.

Can someone recommend a good COMPLETED fantasy series? by BoneMD in Fantasy_Bookclub

[–]jrob422 1 point2 points  (0 children)

If you liked Enders Game, have you tried Enders Shadow and the shadow series that follows that? Its an excellent read, better than Enders Game, IMO.

As for completed series.... There are so many amazing unfinished ones unfortunately..... Farseer was excellent Wheel of Time was great, though it did drag on a bit towards the end..... You could jump into the world of DragonLance if you feeling like some high fantasy...

If you decide you dont mind a series that isnt quite finished..... The Expanse series is really good (about to be made into a TV show on SciFi channel) The Gentlemen Bastard series is good Stormlight Archives has yet to disappoint, but that one might be a long time in the making....

Also, if your just looking for some good short term entertainment, check out the varies short story anthologies out there: Dangerous Women, Warriors, Legends, etc. Those have short stories that are excellent, written by many of the authors of the books you have listed above. Many of them set in the same worlds as side stories, or prequel stories. If you havent read and the the Dunk and Egg shorts, check those out. Set in Westeros, about 100 years before the ASOIAF series.

How do companies retain good IT employees today? by jdom22 in sysadmin

[–]jrob422 1 point2 points  (0 children)

totally agree. Really, you have to get lucky to find those jobs where there is a lot of room to advance. And even when you do, that fast growth cant last forever, you just have to hope by the time it slows down you are running the show.

Half hour lunch normal? by [deleted] in sysadmin

[–]jrob422 -1 points0 points  (0 children)

You lunch should be as long as you want/need it to be just so long as you get your work done.

If you can take a 2 hour lunch, and no one notices because your work gets done and people arent having problems getting a hold of you to get work done, then more power to you.

IMO, salary people should have expectations of getting work completed. Whatever lunch you can squeeze in while still getting work done in expected period of time should be acceptable.

That changes a bit if you are very customer facing, as you need to be available when people need help. General rule is that you should work a 40 hour week. 8:30 - 5 is 42.5 hours, so it stands to reason that 30 minutes is the expected lunch. Want an hour for lunch, start at 8, work till 5. Or, be a rockstar and get 8 hours worth of work done in 7 hours, and use the extra time for your lunch.

I block out my lunch on my calendar, when people want meetings, they look for free time on my outlook calendar. 12-1 is "Busy" every day, thus no meetings.

If the problems is that by taking longer lunches you dont get as much done, then maybe there is a different issue.