|
|
From what I know, MSSQL exists for Linux also.
growing up with Multics, learning UNIX and then Linux for over 25 years, I abandoned that platform completely for Microsoft when I found that my peers had used Microsoft products and they were able to upgrade their solutions as time passed. I had to fight every time with Unix/Linux changes.
After 15 years on the Microsoft path I have never looked back and I am going on 40 years of developing software and I can maintain and upgrade applications from even 20 years ago.
Having software out there bringing you rent, the better off you are and the more time you have to develop.
That learning curve is bad enough with new technology alone, so I advise you to stick with your tools.
I wish you luck!
|
|
|
|
|
I have administered a system for 9 years based on PostgreSQL, another system for 17 years based on SQL Server, and maintain a private Linux system based on MySQL.
Of all the systems mentioned in this thread, PostgreSQL is my favorite for three main reasons:
1. It is free, unless you want to pay for support.
2. It is object oriented. Writing procedures that work together is very pleasant in PostgreSQL.
3. It is pure, not beset with encumbering licenses from corporations wanting to take over the world.
4. I can and have fairly easily written my own extension for it. In my case, it was my own version of SOUNDEX.
For SQL Server:
1. It is not free.
2. When I write a View2 that uses a View1, if View1 is ever updated, View2 does not see the update until I ALTER (with no changes needed) View2.
3. I use the Microsoft OPENQUERY a lot to do joins on remote databases before the data is received on my end. One problem with it is that it does not accept variables of any sort.
4. The interface is generally polished and familiar to me. My main irritation is the line numbering used on error messages that don't match my source without doing arithmetic.
For MySQL:
1. It is free up to a point.
2. It has ubiquitous documentation.
3. It is maintained poorly by Oracle, with whom I have had unpleasant communications with an arrogant salesman.
4. It has been patched to use multiple engines in an attempt to get wanted features. I.e., it is a bit of a mess.
5. I think I would rather use MariaDB, but haven't had the opportunity.
|
|
|
|
|
Quote: When I write a View2 that uses a View1, if View1 is ever updated, View2 does not see the update until I ALTER (with no changes needed) View2.
Do you mean if it is created without schemabinding?
Postgresql was different, there it was the default. Oh the joys of cascade dropping and recreating views and functions ... (Firebird 1.5 is the same) Oracle is wise .
Creating views on views therefore considered a bad practice.
|
|
|
|
|
I try to avoid views of a view, but it fit my desire for DRY (Don't Repeat Yourself) and laziness.
|
|
|
|
|
Bruce Patin wrote: When I write a View2 that uses a View1, if View1 is ever updated, View2 does not see the update until I ALTER (with no changes needed) View2.
Seek ye the sp_refreshview procedure. Use it as needed.
At my last job I implemented a procedure which ran it on all views in accordance with their dependencies. It was part of our standard prod deployment process.
|
|
|
|
|
|
Support them all and allow the user to choose what he wants.
|
|
|
|
|
Wordle 1,125 5/6
β¬β¬β¬π¨β¬
β¬β¬β¬π¨π¨
β¬π©β¬β¬π¨
β¬π©π¨π©π©
π©π©π©π©π©
|
|
|
|
|
Wordle 1,125 3/6*
β¬β¬β¬β¬π¨
π¨β¬π¨π¨π¨
π©π©π©π©π©
|
|
|
|
|
Wordle 1,125 3/6*
β¬π¨β¬β¬π¨
β¬β¬π¨π¨π¨
π©π©π©π©π©
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Wordle 1,125 3/6*
β¬β¬β¬β¬π¨
β¬β¬π©π¨β¬
π©π©π©π©π©
Happiness will never come to those who fail to appreciate what they already have. -Anon
And those who were seen dancing were thought to be insane by those who could not hear the music. -Frederick Nietzsche
|
|
|
|
|
β¬π¨β¬π¨π¨
β¬β¬π¨π¨π¨
β¬β¬π¨π¨π¨
π¨π¨π©β¬β¬
π©π©π©π©π©
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
Wordle 1,125 4/6
β¬π¨β¬β¬π¨
β¬β¬π¨π¨π¨
π©π©π©π©β¬
π©π©π©π©π©
Within you lies the power for good - Use it!
|
|
|
|
|
Quote: Wordle 1,125 4/6
β¬π¨β¬π¨π¨
π¨π©π¨β¬β¬
π¨π©π©β¬π©
π©π©π©π©π©
Ok, I have had my coffee, so you can all come out now!
|
|
|
|
|
Wordle 1.125 3/6
π¨β¬π©β¬π©
β¬β¬β¬π¨β¬
π©π©π©π©π©
Fitting
GCS/GE d--(d) s-/+ a C+++ U+++ P-- L+@ E-- W+++ N+ o+ K- w+++ O? M-- V? PS+ PE Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
The shortest horror story: On Error Resume Next
|
|
|
|
|
Wordle 1,125 6/6*
β¬β¬β¬π¨π¨
β¬β¬π¨β¬π¨
β¬β¬π¨π¨π¨
π¨π¨π©β¬β¬
π©π©π©β¬π©
π©π©π©π©π©
|
|
|
|
|
If you sleep outdoors this time of the year in Norway, you must be prepared for limited darkness trough the night. Visitors from further south may have problems getting a good nights sleep. Indoors it should be less of a problem, you'd think - just pull the curtain. It doesn't always work ...
Every summer, Oslo, Norway, arranges an international giant soccer tournament for kids 6-16 years, called Norway Cup. It has been held since 1972; this year 12,000 kids are participating. The kids sleep in sleeping bags in the classrooms of schools nearby. About a thousand of them will sleep with the lights turned on in the ceiling.
Why? The lights are controlled by IR sensors. With 30 kids sleeping in the classroom, the sensors are not it doubt: People are present; lights should be turned on.
But isn't there a main switch for turning the light off, regardless of what the sensor says? Yes, there is - but that will also turn off the lights in the emergency signs, the arrows pointing in the direction of the exit, in case the building has to be evacuated. For security reasons, those lights cannot be turned off. Therefore the ceiling lights cannot be turned off in the room where the kids are sleeping.
I laughed out hysterically when I read this in the newspaper. Whoever designed this light control should be dipped in tar and rolled in feathers.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
Once doing work in Hamburg Germany during the summer, I learned to get a hotel room with dark curtains if room had exterior view. It is about ~53 deg north, so sun rises very early and sets very late, more so in Norway.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Sunrise today: 03:54. Sunset: 22:52.
But don't think of it as 'dark' from sunset to sunrise! At 01:00 it is still enough light to read a newspaper outdoors, without the aid of artificial light.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
Wow, I knew it wasn't very dark outside @1:00am, but I was looking for sleep at that time.
Far north (and south) locations are truly the "midnight sun" experience.
Here in TX, one can't wait for the sun to go down to get relief from the heat.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Smart lighting is more than 20 years old, where a mobile app can control dimming of lights. They could have used such a technology isn't it?
Since I was working for Philips for some years, am aware of this technology.
|
|
|
|
|
I've been in Norway at this time of year, at a latitude similar to Oslo, and dimming the lights wouldn't have much of a noticeable effect between about 11pm and 2am. It's probably better for the kids to practice sleeping in full light.
|
|
|
|
|
Amarnath S wrote: Smart lighting is more than 20 years old In this country, we started building schools much more than 20 years ago, some of them with a build quality to make them stand even today!
I am sure that the manufacturers would be jumping of joy if every new technology announcement would make every school, and other public institution immediately throw out all their old stuff and replace it with the new technology. (Sometimes, I have a feeling that it is that way!) I am not sure that taxpayers are equally happy with it.
I have been pondering 'smart' technology for my home for 30 years. Except for being 'new' and something to show to my friends, I still haven't found a single area where it has any other value for me personally. I guess that the situation is the same in many schools. If all you get from smart technology is dimmable light: We had that in my childhood, decades before the term 'smart home' was conceived.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
I don't know about Norway, but I am pretty sure not having emergency lighting isolated to its own circuit from the main board is illegal here.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|