jinnantonnixx

A couple of gotchas which may have been overlooked. SQLExpress will only use one physical CPU socket. If you have configured your VM to use two physical sockets, only one will be used. However, it can use four cores, so you can configure your VM to use four cores of one physical socket for maximum performance from your system. If you have SQL Standard edition, it will use a maximum of four physical sockets or 24 cores, whichever is the lesser. Here's a chart: https://msdn.microsoft.com/en-us/library/ms143760.aspx?f=255&MSPPError=-2147217396 If you're OK with SQL queries, this will show the CPUs available to your SQL server. Everything should have a '1' in the 'is_online' column. If not, you've misconfigured your VM CPUs and you're not firing on all cylinders. *** If you're NOT OK with SQL queries, don't run it. *** select cpu_id,scheduler_id,is_online, current_tasks_count, status from sys.dm_os_schedulers where status IN ('VISIBLE OFFLINE', 'VISIBLE ONLINE') Assuming none of this applies, your next step should involve SQL Activity Monitor. This is useful to get an overview of your SQL system. Have a look at the 'Waiting Tasks' graph. In an ideal world, this should be 0. Real world values of 2-3 are OK, anything higher shows that your system has a bottleneck. A good place to start is here: Activity Monitor in SQL Server More in-depth: Monitor SQL Server queries ? find poor performers ? Activity Monitor and Data Collection - SQL solution center

That's right. If the Windows OS has little memory, it can reclaim what it needs by asking SQL server to relinquish memory, but this is a comparatively very slow operation. it's always best to ensure that the Windows OS has a comfortable amount of memory in the first place by setting the MaxMemory of SQL Server. Don't reduce the VM memory!

Try this. It's a bit more robust and the output is clean. Supresses StdIO output and tests the result of the ping in a CASE construct. Looks for 100% packet loss and 0% packet loss to determine the result. case `ping -qnc 1 www.crashplan.com 2>&1` in *'100% packet loss'*) echo "BACKUP CONNECTIVITY FAILURE - check network cable, lights on network card/s, router and all switching are on and working." exit 1 ;; *' 0% packet loss'*) echo "Current connectivity to CrashPlan: OK" exit 1 ;; *) echo "Problem with script" # should never see this. ;; esac

It leaves the the OS with enough memory to perform effectively. If all available memory is consumed by SQL server, it will choke the OS causing paging to disk. https://www.brentozar.com/blitz/max-memory/ P.S. Only make one change at a time. Otherwise, you won't know what worked.

I'm a big fan of Sqlite for small databases. It's the most widely used database in the world. This looks like a good way to manage it. SQLiteStudio Alternatively, and this is a bit of a curveball, have you thought about Google Forms? https://www.google.co.uk/forms/about/ Google Forms are quick and easy, and do all the heavy lifting of collecting data for you.

Xiaomi Pistons are excellent. Amazing value, too. Edit: Not sure if they'll suit your aversions!

Additives can definitely work. I had a very rough-running 1.9D Renault van. My mechanic friend suggested Diesel Magic, but poured in the fuel line and fuel filter rather than in the tank. In other words - neat. I gave it two doses of this and it cleared the roughness and ran quite smoothly until I sold it 3 years later. It must have cleared a clogged injector. But as a routine treatment? I don't know. We now have a Berlingo diesel, and it was juddering occasionally. The dealer suggested driving it a bit more 'enthusiastically', which worked. Up until then, we both drove it gently and changed gear early and at low revs. After talking to the garage, we change gear later (not accelerating any faster, but leaving the revs climb to at least 2,500). Driving a modern diesel at low revs chokes it up.

Ha ha. If I typeset that advert, the Herts would hit the fan.

I ditched the Facebook app a long time ago. Like you, I use the web browser version on my phone. As an added plus, if you choose 'Request desktop site', the messenger function works! The only downsides are the rough integration with photo uploads and sharing. But it's worth it for keeping a lid on Facebook.

Yes. Hopefully they'll resurrect Clippy to suggest LinkedIn partners that might be useful to your project as you type your report. Sounds brilliant.* http://www.nytimes.com/2016/06/17/opinion/why-linkedin-will-make-you-hate-microsoft-word.html *No, not really.

The appalling Philip Green is just part of the system. That?s the real scandal | Owen Jones | Opinion | The Guardian

The Onion has a good satirical piece. It?s An Honor To Continue Being Valued Over Countless Human Lives - The Onion - America's Finest News Source

If you have physical access (which you have) then you can easily reset the root password by booting the machine into single-user mode and resetting the root (and any other) passwords. Most systems use GRUB, so find the heading Booting into single user mode from GRUB How to Reset forgotten Root passwords LG #107

Hillary Clinton is calling for a ban on assault-style weapons. This will put pressure on Trump who is very pro-gun and will have to reconcile his position with these events.

I wonder how the NRA are going to spin this.

They look like DB25 sockets, probably for RS232 serial terminals.

Draw numbers on them and place them in a line and get people to bubble-sort them. It'll be great fun, everybody will want to have a go and you'll be invited to every party from this point on. All your dreams will come true* * Your dreams may vary from those illustrated.

means 'warmer'

I remember reading some wacky stuff about Noel Edmonds a few years ago. I looked it up and it turns out he has two orbs on his shoulders which he contends are his parents' souls, and that he also believes in something called 'Cosmic Ordering', which from what I gather is literally wishful thinking. https://en.wikipedia.org/wiki/Cosmic_ordering This from 2008: What's eating Noel Edmonds? | Features | Culture | The Independent

This is just a series of disasters. Former BHS owner Dominic Chappell denies threatening to kill CEO ? as it happened | Business | The Guardian

100%, but I'm fairly musical. This will drive you bananas.

This dancer defies physics while filling up.

Huh? I read about blue field entoptic phenomenon a while ago. I was at a loose end today so I took advantage of today's deep blue sky to see if I could see it. It's really quite remarkable, more so if you put your finger on your pulse and observe the motion of the 'sprites' in time with your pulse. You're actually watching your own white blood cells pulsing through your eye's capillaries. Next time you see a deep blue sky, try it. Blue field entoptic phenomenon (or sky sprites) are mentioned 2 minutes into the video.

I've found that it's possible to set the value of a custom attribute in Powershell. To change a user's favourite curry (assuming you have added a custom attribute to store such a critical item), you can do this: Set-ADUser john.smith –replace @{favouriteCurry=”Dhansak"} You call also use the -remove operator to remove a value, and the -add operator to set a value. I still can't figure out a way of reading the damned values in Powershell, but it's better than nothing I suppose.

[pedant] Divide. They baked in some wrong division tables into the chip. Most of the time it would sort itself out, but in certain circumstances it would give the wrong result. [/pedant] Old tech is often chosen, not because it's bug-free, but because the bugs are well known and can be accommodated.