|
I have worked with SQL Server, Oracle, Sybase, MySQL, and Firebird.
After SQL Server I probably liked working with Sybase the best.
Why don't you like SQL Server?
Steve Naidamast
Sr. Software Engineer
Black Falcon Software, Inc.
blackfalconsoftware@outlook.com
|
|
|
|
|
When it works it's fine. When it does something stupid or insecure, Microsoft doesn't care enough about it to patch it until the damage is already done.
Maybe they've changed that in recent years, but usually I avoid anything with both the words Microsoft and Server in it because I prefer my data stays where I put it, and not in the hands of strangers.
Real programmers use butterflies
|
|
|
|
|
There must have been some severe deterioration with SQL Server over the years. I stopped working with it after SQL Server 2008. But up until then, it was a very reliable and easy to use database engine.
Admittedly, now that I am retired, I prefer to work with Firebird and MySQL even though I have various versions of SQL Server lying about on my workstation and backups.
Steve Naidamast
Sr. Software Engineer
Black Falcon Software, Inc.
blackfalconsoftware@outlook.com
|
|
|
|
|
I had problems with it before that. We got hit with an attack on SQL 2000 servers (it was an attack that affected many) - it's been 20 years so I don't remember the nature of it, but I do remember Microsoft basically screwing everyone and taking their own sweet time.
Since then, I've seen problems with 2005, and 2008. Probably patched now, but you can't afford to run their latest bits for years.
It's ridiculous. We wound up going back to 4 and implementing an OLE DB compliant SQLXML compatible layer on top of that.
Real programmers use butterflies
|
|
|
|
|
Very interesting. When I worked at Credit Suisse from 2001 to 2007, we used SQL Server and Sybase. However, our DBA groups handled all of the issues so we were not affected by them. Nonetheless, we never ran into problems when using either.
I have used SQL Server at quite a few companies, where basically I had to do DBA work as well and still found no issues working with this database engine.
As I mentioned previously, I cannot say for any version after 2008.
Up until 2008, I had worked with SQL Server since 6.5.
Steve Naidamast
Sr. Software Engineer
Black Falcon Software, Inc.
blackfalconsoftware@outlook.com
|
|
|
|
|
You firewall anything enough it's "secure" - at least until it isn't.
probably were running strictly DMZ'd servers. We made the mistake of proxying into the DB behind our cisco firewall, because microsoft advertised that the DB could serve pages. We had some management pages coming off of SQL server, and that's how they got in. If I remember right, there were buffer overrun exploits in the sqlxml processing back then, but like I said it has been 20 years now.
We weren't the only ones affected, like i said.
Real programmers use butterflies
|
|
|
|
|
I seem to remember something about SQL Server possibly serving up web pages. I think that is what you are referring to.
I never knew anyone who tried that...
Steve Naidamast
Sr. Software Engineer
Black Falcon Software, Inc.
blackfalconsoftware@outlook.com
|
|
|
|
|
We had it so we could log in, tune certain site settings, and do some maintenance stuff. it wasn't anything that would break the site, even if they broke our login somehow. they didn't get it that way. they got it deeper in the stack through some kind of malformed SQLXML request
Edit: and yes, that's what I'm talking about.
Real programmers use butterflies
|
|
|
|
|
|
Cool! Thanks. It wouldn't have solved my problem in this particular scenario (it was a client that triggered the update on their machine 3,000 miles away  which basically ended our session for the day) but it will certainly help me down the road. 
Real programmers use butterflies
|
|
|
|
|
Stress testing my "military map maneuvering" game. Had all 585 infantry and cavalry regiments and gun batteries (user controls) all moving at the same time (20 fps), and no sweat. CPU steady at 7%. And gun batteries usually don't move.
I'd think you would get similar results with WPF.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
…aaaaaaand it’s going away[^]. 
(Sounds like a cool game though)
TTFN - Kent
|
|
|
|
|
I think I'm on Win 2.7, and it sounds like there's still a 2.8 in prerelase. So, what do I get for .2? 
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Did you write your app in WinUI3?
|
|
|
|
|
I wouldn't class it as WinUI3; except I'm not really sure what WinUI3 looks like. I have the sample app for Win3UI controls but all the controls looks the same as mine. The app runs on PC's, my 1st gen Surface Go (side loading), Xbox, should run on ARM, and can be distributed through the Store. So, haven't felt any urgency to pursue Win3UI (yet).
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
|
For my "file system", I've been compressing and creating resource files (tables, dictionaries, etc).
I serialize and deserialize run time data to local and roaming storage.
I think using local storage file system requires user acceptance, which I haven't needed for my apps.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
modified 21-Oct-21 12:30pm.
|
|
|
|
|
I mean access to the whole file system.. like any normal desktop games...
It's not much of a problem, you can store private file in the area authorized to UWP app... but I am working (home project) on a sort of document editor, need to access normal files without hassle...
|
|
|
|
|
I have .Net Framework 2.x ddls that I call from UWP during development that pull in any "whole system files" used by the app (versus any content / resources).
Those few statements tying it in / excluding it are handled with compiler directives (development versus final distribution).
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
|
Again? I don't know if you are the same one, but...
Short answer in case you are not the same guy:
Expugned and not convicted, there probably is not even a record. There shouldn't be any problem. If you are good programming, you'll get a job.
Short answer in case you are the same guy:
Go troll somewhere else.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
no trolling. just looking for the truth.
|
|
|
|
|
Looking at his message history, he posted a similar thread back in February.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
That's why I said "again"... I remembered something
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
So you think you are going to get a better discussion than The Lounge[^] this - sounds like trolling to me as you did not want to listen to any of the advice given last time you posted this message.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
