Improvement to backup plan

So I intended to use Amazon Glacier but since I now have a need for external drive, I found out that when I buy Seagate Backup Plus Slim Portable 500 GB it comes with 200 GB of free storage space in OneDrive, for two years.

And two years of 200GB in AWS Glacier would cost $56, and the drive costs 65€, but also of course comes with 500GB of normal hard drive space, so it’s quite a nice solution.

I would of course not store 200GB in Glacier, but if I did, the price I would pay for that over two years, would almost mitigate the price of that 500GB drive. So essentially by buying 500GB of disk space, and using OneDrive, I get it for free. Almost.

I don’t know if it has Linux support, but nothing prevents me from running virtualized Windows 7 and sharing the local backup location over NFS and then making the client on Windows sync that folder. Or something like that.

I don’t know how good OneDrive is, but if (since) it is marketed for Business use, it ought to be quite nice.

Windows architecture flaw

There is one serious architectural flaw in Windows.

I begun installing SQL Server 2014 and it told me all dependencies were satisfied and it let me choose all the features available.

But then at the end it shows me this:

snap1212

And in the log file it says

An error occurred for a dependency of the feature causing the setup process for the feature to fail.

So a) it could not tell me that it cannot meet some of the dependencies and b) it gives me no indication what that dependency might be.

Contrast this to any Linux package management system where dependencies are checked before any installation ever begins. And if dependencies are not met then those package management frameworks can add those missing dependencies and install them too, and then install the final product with all dependencies met.

So Windows/Microsoft does not keep any proper track of their dependencies it seems. The system is pretty solid with its next-next-finish principle, but then it cannot deliver it end-to-end and fails for something as trivial as dependencies.

They have the Microsoft Update system so why cannot they use that to satisfy all the dependencies? I have already checked one place to allow Windows to contact that system but apparently SQL Server a) won’t do it or b) those dependencies are not available, in which case, or in either and every case, it should give me bit more information that just say that dependencies were not met.

Because now what it makes me to do, is that I need to seek myself what those dependencies are. In Linux world the package managemtn software and every existing software tells you exactly what dependencies you are missing.

SQL Server even gives me something called System Configuration Check Report and everything is marked either Passed or Not applicable so why did it still fail? It makes no sense.

It couldn’t even install Database Engine Services which sounds pretty damn important. So what was the point of initial dependency check if it did practically nothing.

Update

https://stackoverflow.com/questions/27489182/sql-server-2014-installation-fails-an-error-occurred-for-a-dependency-of-the-fe

There seem to be something called Detail.txt there, and it is 2.44MB file so perhaps that will tell me what failed. But it surely is well hidden and the installation program says nothing about this file.

Another interesting thing is this:

snap1213

And only because it took so long. Did it seek the hard drive for updates? Instead of looking from some index? Or did it verify the integrity of all those updates, and that’s why took so long? It shouldn’t take long to fetch the list of installed updates.

Windows Server 2012 isn’t that bad after all (IIS and PHP)

Everything so far has gone simply by clicking buttons and choosing what to install. This is completely 360° difference to Linux.

IIS was installed by choosing features and PHP can be installed similarly easy by Microsoft produced installer. The only downside is that at least for this version of IIS they offer 5.3.24 which is old.

This is certainly easier than setting up Linux, at least at this level it is. But I am sceptical in a sense that I am certain it isn’t like that. But these are apples and oranges so it really makes no difference.

snap1204

And I sort of like this that this gives one the ability to do nothing but actually what’s needed to be done. I mean, in Linux you can fiddle the rest of your life and it changes little. So Linux by this impression is 1000 times more versatile but it comes with downsides.

And then when this happens in Windows I don’t like it because it never gives you any explanation and the help it offers has no real use:

snap1205

Found information that this requires NET 3.5 and oddly it wasn’t installed along with this. So currently installing that.

snap1206

And the odd problems with Windows Update are apparently solved with this: https://support.microsoft.com/en-us/kb/2734782

Or so they say:

snap1207

I am seriously starting to dislike Windows.

http://blogs.technet.com/b/askcore/archive/2012/05/14/windows-8-and-net-framework-3-5.aspx

This is beginning to seem like absolutely retarded thing. Why haven’t they fixed this? Their system isn’t working!

Finally after surrendering and attaching the installation media, NET 3.5 finally was installed.

And after I uninstalled the Web Platform Installer because it failed, it no longer lets me install it again. What a poor system this is.

One good thing came about:

snap1208

And there is everything from CakePHP to Drupal and Joomla. Presumably you can drop these in for configured domains and hosts.

MySQL 5.5 didn’t install but after 8 hours was still stuck on Installing. So there is something wrong with something definitely. Either in Windows or my setup.

And second attempt fails like this:

snap1209

It is becoming clear there is something deep within Windows that I am not currently getting. Or then it just sucks, but I find that hard to believe.

But this doesn’t matter too much, because I will be using SQL Server anyway.

FTP was easy to enable. Resided within IIS.

Studying Microsoft SQL Server 2012 with some great books

New challenged and these require studying. Started with SQL Server 2012 T-SQL Recipes, 3rd Edition
but because it relies on deeper knowledge of the database itself, it was required to switch it to Microsoft SQL Server 2012 Internals which is deeper and more technical book about the internal operation of the database engine.

Untitled

The Recipes book is from Apress and the technical internals from Microsoft, which should be very in-depth read.

Untitled2

This book is intended to be read by anyone who wants a deeper understanding of what SQL Server does behind the scenes. The focus of this book is on the core SQL Server engine—in particular, the query processor and the storage engine.

The one problem for me, with Microsoft and Windows based products is, that it is “scary” to not know what happens behind the scenes. In Unix and Linux you can always be aware of what happens but in Microsoft world it isn’t as straight; you simply press buttons, and expect good things to happen.

What if when bad things happen? What are you supposed to do? Surely there are error logs but the mentality is different. Supposedly their systems are meant to be used they are, and when that is done they function properly.

And when things fail, they supposedly fail gracefully and fix themselves. But when they don’t — that’s where the problems begin.

Also some of my personal databases will move to Microsoft platform simply because there is a need to use and manage Microsoft systems so that is the best way to go.

Getting started with Microsoft SQL Server 2012

Free PDF book available for download from here.

Also directly from this link: http://download.microsoft.com/download/F/F/6/FF62CAE0-CE38-4228-9025-FBF729312698/Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012_PDF.pdf

Long 250 page book into everything essential.

Microsoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives organizations effective tools to protect, unlock, and scale the power of their data, and it works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds. Our purpose in Introducing Microsoft SQL Server 2012 is to point out both the new and the improved capabilities as they apply to achieving mission-critical confidence, breakthrough insight, and using a cloud on your terms.

As you read this book, we think you will find that there are a lot of exciting enhancements and new capabilities engineered into SQL Server 2012 that allow you to greatly enhance performance and availability at a low total cost of ownership, unlock new insights with pervasive data discovery across the organization and create business solutions fast—on your terms.

But seems to be specifically SQL Server 2012 book so doesn’t go into too many details on how SQL Server generally works.

Lots of data but not really helpful for beginner.

Windows 2012 R2 Datacenter Edition testing

Installing Windows 2012 R2 Datacenter to start testing and learning something with it.

Red Hat VirtIO SCSI controller was once again required to access hard drives through virtio but Red Hat has kindly had them signed and the installation of these drivers is no hassle.

And the reason for this is there are opportunities which require some Microsoft and Windows Server experience. Also I was once told that it is extremely difficult to find people whom know both Microsoft products and Linux so this will help me build my professional expertise.

If you are Linux person yourself you should probably consider doing the same. Have one Windows server running and do some things with Windows and other things with Linux. Set a local AD or something and make Linux rely on that for example.

It is extremely easy to follow the obvious Linux path and very difficult to take on the attitude required to use something completely different.

I am personally running Windows Server on top of Linux QEMU and using ZFS as storage so that is interesting stack in itself.

But one thing with Windows and Microsoft I do not understand, and that is the fact that they charge you more for more options. Or in other words if you don’t pay them enough they do not give you all they could. Which to me is very odd concept in software and Operating Systems.

In Linux world the method of making money is based on services and maintenance and support and that sort of things. But to charge from software and then pay more for support and services is completely against my sense of how it should be.

Also it does not seem to make much sense from user’s perspective because you are still required to buy (hire) your own people to manage the system. So why not go with Linux? You would only be paying the cost of employing people which you would do regardless of which Operating System, platform or vendor you chose.

Unless there is something that truly only exists on Microsoft platform, which I very much doubt. But if you were to build something universal from the scratch I feel it would make very little sense to choose Microsoft.

First impression

Looks good but is quite heavy on CPU. IE has extremely tight settings and it is practically impossible to do anything. And for some reason I am not able to change the settings for Internet zone. This is the Microsoft logic where the service provider knows better than the user. It probably can be changed from some registry setting or from somewhere else.

Got IPv6 as expected so nothing impressive there. Not having IPv6 enabled would have been suprise.

There is now problem with the underlying virtual host so this will have to wait.

YouTube: CodeGeek educational videos

Wonderful educational material available at CodeGeek channel. Long quality produced videos ranging wide number of topics.

For today I have personally chosen Microsoft SQL Server 2014:

And over the coming days I will also be learning Python in this 11 hour long study session:

Python because it is powerful language used everywhere.