[dba-VB] Visual Studio community edition

John W. Colby jwcolby at gmail.com
Sat Feb 28 09:32:46 CST 2015


 >>Yes, I remember your driven by a large MS SQL backend DB application 
development story. Is it up&running?

It is up and running.  I have been using it for years.

 >>No any plans to migrate it to Linux/noSQL - Map Reduce ( 
http://en.wikipedia.org/wiki/MapReduce ) / CouchDB ( 
http://en.wikipedia.org/wiki/CouchDB ) ?

I would love to migrate it to MariaDB, however the C# code was written 
to target SQL Server specifically.  The bigger problem is that the 
database is used to pull data sets for sale.  I have an entire template 
database that I copy for each client order, and that template database 
has defined tables, views and stored procedures that I use to fill the 
order.  Once the order is filled, the order database becomes a history 
of what was done to fill the order, as well as a history of records not 
to be sold again should the client order another data set.

In the end there is simply no compelling reason to make the move. Yet.

The compelling reason long term is that the SQL Server is hosted on 
Windows 2008, and SQL Server itself is 2008 as well.  As we know, MS 
likes to force us to upgrade by dropping support (including bug / 
security fixes).  I don't know if you have ever looked, but licenses for 
new versions are EXPENSIVE!!!  Particularly for tiny companies.

So someday, in the next few years, I will likely be forced to do something.

I am in fact trying to get MariaDB running on my Linux Mint server / 
workstation here at my office.  Sadly, doing anything in Linux is a 
serious exercise in frustration compared to doing the equivalent in 
Windows.  MariaDB is installed.  I can't log in.  Breaking in as the 
root user isn't working as the Google search says it should.

I have an old Areca RAID controller which has to be firmware updated to 
work with the modern drives larger than 2 tb size.  In Windows, that 
involves downloading the file and using a program from Areca to find a 
firmware file and upgrade.  Dead simple.  The same exact process is 
required for Linux except...

Since I am just bringing this card up for the first time (in Linux) I 
have to start from scratch installing drivers, installing the software 
etc.  That involves figuring out what version of Linux... downloading 
the right thing from Areca... Typing in loads of crap in the command 
window... dealing with the inevitable (and I do mean inevitable) error 
messages.

So a simple (in Windows) 15 minute install turns into an hours long 
exercise in frustration (all of last night), and this morning the Areca 
card and three spanking new 3 tb drives are still a useless paperweight 
hooked up to the Linux machine.

For some reason, the Linux crowd seems to think this is supposed to be 
fun???  I have PILES of work backed up behind "simple" (on Windows) 
things that just aren't progressing on Linux Mint. Something always goes 
wrong somewhere.  And figuring it out ALWAYS starts with "what version 
of Linux" and goes downhill from there.

Google (And SUDO, and the command window for GOD's sake) is my friend.  
Except the last two are only very uneasy allies.

In my opinion the core of the Linux problem is simply that with so many 
distros out there, no company selling into the Linux environment can do 
anything in a consistent manner because nothing works the same on every 
distro.  And so the poor guy (me) trying to get anything done is tasked 
with sorting it all out for the specific distro chosen.

Linux is supposed to be free.  The problem is that the Linux cost is in 
all the stunningly stupid crap that has to be figured out to get 
anything more than the simplest install done.  And all that comes 
BEFORE, and stands in the way of, actually getting any work done.

Boy did that end up off-topic or what?  My frustration is showing.

On a lighter note, I have come to the conclusion that approximately 50% 
of ALL the internet content is "how to" articles for getting stuff done 
in Linux.

;)

John W. Colby

On 2/28/2015 3:14 AM, Salakhetdinov Shamil wrote:
> Yes, I remember your driven by a large MS SQL backend DB application development story. Is it up&running? No any plans to migrate it to Linux/noSQL - Map Reduce (http://en.wikipedia.org/wiki/MapReduce  ) / CouchDB (http://en.wikipedia.org/wiki/CouchDB  ) ?



More information about the dba-VB mailing list