Restoring Access to Microsoft SQL Server

by Dmitry Kirsanov 26. August 2013 05:29

As a note to system administrator – what to do, when your one and only administrators account is locked on your SQL Server.

You need to perform 5 quick steps. More...

A short note about using Windows Updates

by Dmitry Kirsanov 15. August 2013 16:00

On second Tuesday of each month Microsoft releases batch of patches for Windows and everything. Some of these patches require restarts of machine. Sometimes during the process machine can shut down instead of restarting. Sometimes the machine can’t even shut down properly. Yet in many cases production servers have "Install updates automatically" setting turned on. This is a sort of Russian roulette.

Morale: do not enable automatic installation of updates on production servers or machines you can’t switch on immediately.

Creative Ideas for Pond Owners

by Dmitry Kirsanov 12. August 2013 05:09

So, you have a pond. Now, what to do if the fish is lazy to breed? Here is the answer from LinkedIn.

First, let’s see if Bob was looking for Alice in Wonderland. Let’s say, there were 20 different Alices, but not the one he was looking for. Let’s wait for about a month and send invitation from random Alice from the previously displayed list to Bob, and from Bob to Alice. They both will think that they initiated the invitation. But first we need to make sure, that they can’t ask questions before accepting the invitation, so let’s remove that feature.

Yeah, that’s how it works in LinkedIn now. Now let’s hope that Alice is not ex-wife of Bob, or his ex business partner, or even better – a partner of his ex wife.

What happens when you leave your Windows session unattended for days

by Dmitry Kirsanov 11. August 2013 00:33

IE_VM13

This is a CPU usage graph of a Windows Server 2008 R2 machine, with all latest patches applied, and Internet Explorer 10 left opened for a few days. It had only two pages opened, both are Microsoft’s own support pages with no active content.

Remote session (RDP) was opened for about 5 days, and every hour Internet Explorer process took more and more memory and CPU, until it took most resources from server.

More...

Month List