I finally got this to work if anyone is interested. The sql file is fine, but I had to change my batch file. The correct one looks like this:

"C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\sqlcmd" -I -S \.\pipe\MICROSOFT##WID\tsql\query -i C:\Scripts\WSUSDBMaintenance.sql

It must be run from an Administrator command prompt. This took me several days to figure out so I hope it can benefit someone else. Everything I found about reindexing the WSUS database was on Server 2008 or 2012. This works on Server 2016.

@bnrstnr yeah, the price premium for the form factor tends to be nuts. Double the cost sometimes, just to make it look nice in a rack! Maybe if it was customer facing in some way, but not for normal use. And often there are other things that need to be on a rack shelf, anyway. Put them all together on one.

Good stuff. Thanks for pointing this up and writing it up.

@jaredbusch said in Backup server - Software layout:

I use teams, even if there is only one NIC in the team most of the time, because I can add and remove NICs without impacting the higher layers.

Good idea. This server I just got has the onboard GB NICs, but also 2 dual port Intel GB NICs as well. I could create a BIG team if I wanted.

@obsolesce said in Windows 10 Always Says Up to Date, But Always Needs Updates:

or just stop ignoring my posts...

@obsolesce said in Windows 10 Always Says Up to Date, But Always Needs Updates:

If you want to do automatic Windows updates in a similar way to DNF-Automatic for example, I'd load this module:

https://gallery.technet.microsoft.com/2d191bcd-3308-4edd-9de2-88dff796b0bc

And then set up a scheduled task to run a script that loads the module and runs Get-WUInstall.

Too easy 😉

@pete-s said in Comparing 15k SAS and SSD:

@jaredbusch said in Comparing 15k SAS and SSD:

@pete-s said in Comparing 15k SAS and SSD:

@obsolesce said in Comparing 15k SAS and SSD:

@travisdh1 said in Comparing 15k SAS and SSD:

@obsolesce Nice to confirm what most of us have been saying already.

Yeah its nice to see the numbers.

There is also the reliability rate to consider. SSD drives have 3 to 4 times lower annualized failure rate.
And you're more likely to use more 15K drives and do RAID 10 instead of RAID 1 with SSD.

Regarding SAS/SATA SSD they will all disappear soon. NVME drives in the U.2 format have superior performance and a small price premium per GB compared to the same drive in SATA.

As far as I'm concerned SATA/SAS SSD should be bought for legacy use only.

That is totally not useful as the server manufacturers are not manufacturing servers to use those generally. Once that changes then I would recommend switching to those.

That might have been true in the past. But just looking at Dell Poweredge servers with one or two sockets, the following support hot-swap NVME drives : R6415, R7415, C4140, R440, R740xd, R640, R7425.

Yes, it is becoming standard, but it is not ubiquitous yet.

Bonus points for using reply as topic though.

@phlipelder said in Use Hyper-V to replicate Linux vm file share:

@scottalanmiller said in Use Hyper-V to replicate Linux vm file share:

@phlipelder said in Use Hyper-V to replicate Linux vm file share:

Hyper-V Replica would work in this situation with a few caveats.

There is a 15 second limit on replication cycles. If the VMs are running database/active services this could be a problem.

That would be handled earlier in the process by the backup job. If the backup is good, the replication won't cause an issue. If the backup is bad, the replication can't fix it, of course, but will replicate the bad backup. But the only place that this can be addressed is in the backup step, the replication is of backup files, so not at a point in the process where it matters.

"Garbage in garbage out" never seems to go away. It's been the bane of our existence since the switch to image/block based backups. :S

File backups suffered from this, too. Databases are just hard to back up.

@fateknollogee said in NFS Server...what to build??:

@scottalanmiller said in NFS Server...what to build??:

@fateknollogee said in NFS Server...what to build??:

@scottalanmiller said in NFS Server...what to build??:

@fateknollogee said in NFS Server...what to build??:

HW is simple:

2x SSD for o/s 4 - xx SSD for NFS shares

Why would you have drives for the OS? This both breaks standard storage practices AND assumes a physical install which is a 'no no'.

Why would you assume a physical install ?
I'm installing the hypervisor (in this case FC28) on a Raid1 array of 2x SSDs

Because you stated a dedicated array for the OS, not for the hypervisor. I'm only going by what you wrote. If you wanted dedicated for the OS, you'd need it whether you had a hypervisor or not.

Understood. Next time, will be more specific

Since that's a lot of money to spend just for a hypervisor that isn't used, it seems much more rational to use it for an OS than a hypervisor. It's not that there is truly zero value to a dedicated HV array, but it is nearly zero. SSDs, even cheap consumer ones, aren't free. But the value is so low, they'd basically have to be.

@ambarishrh nice!

@obsolesce I think that is what I had to do a couple years ago once. No idea why it started doing it and couldnt figure out any other way.

You can also use Dell Repository Manager to create a bootable ISO to update.

RAID > block device > VDO

@ambarishrh said in Centralized password manager:

Re: Centralized password manager

Revisiting this again, as I would like to setup something with our team. What's the latest choice of PM on ML now?

First few results that caught my attention:

https://www.passbolt.com/

https://www.syspass.org/index-en.html

Looking at a self-hosted possibly free version to use with a team of 4 members.

Nextcloud + passman

@pete-s said in Do I have a power supply problem?:

@dbeato said in Do I have a power supply problem?:

Seeing the dates, is there a pattern? Like does it keep on going up to this year, 2018?

No, these were the only dates.
But I will update the bios/ipmi just in case it is a software problem as @momurda suggested.

Come to think of it, I'm not even sure the -12V in the power supply is even used anymore.

It is more like CMOS battery or other component.

after restoring to my first point i've created before ... able to update sp1 succesfully .
solved now by me ...

@flaxking

paloalto fw

@travisdh1 said in Web app authenticate against customer AD?:

@dbeato said in Web app authenticate against customer AD?:

@travisdh1 said in Web app authenticate against customer AD?:

@dbeato said in Web app authenticate against customer AD?:

@travisdh1 said in Web app authenticate against customer AD?:

@dbeato said in Web app authenticate against customer AD?:

@travisdh1 said in Web app authenticate against customer AD?:

@dbeato said in Web app authenticate against customer AD?:

@pete-s said in Web app authenticate against customer AD?:

that an enterprise would expose ldap to the inter

Very unlikely, there must be a VPN or a LDAP open externally only allowed from certain IP addresses from said Cloud vendor.

LDAP can be secured the same way HTTP traffic can be. In fact, it's the default in Active Directory.

What do you mean LDAP secured? you mean LDAPS?

Yes.

LDAPS still not the default as far as I know in AD .

Really? That's just bad. I thought they had Kerberos by default.

https://support.microsoft.com/en-us/help/321051/how-to-enable-ldap-over-ssl-with-a-third-party-certification-authority

Wow, just, wow. Haven't they figured this out by now?
0_1533942863184_93df6151-c505-4067-a50a-06974023c370-image.png

It would be nice if it was on by default.

@gjacobse said in Help troubleshooting L2TP over IPSEC VPN connections.:

jeeze,.. that is a sad state to think that we have nbeen fighting this for that long,...

@JaredBusch @scottalanmiller
Can a cron be set to restart the ipsec every 24 hours?

Yes.

@momurda said in Getting A Dell T320 To Work As Dual Monitor Workstation:

5 dollar gt 710 is better than that thing. Likely the new drivers for quadro on amd site dont even work with it, so Win10 is probably unsupported.

I agree, just go to Best Buy and buy the cheapest video card. I've used one and it works fine for gaming so it should work fine for any office work obviously!