I will Download this To my laptop later and give it a try with a File from the lab here and let you know.

@magicmarker Why dont they create one giant hazardous label to fit all the products, and make it generic as possible. Like this product contains hazardous chemicals. it is not like someone actual reads that small fine print. Another problem solved...

@StorageNinja said in MongoDB Major Change to Licensing: @scottalanmiller said in MongoDB Major Change to Licensing: if you are a SaaS vendor looking at building software that uses MongoDB somewhere, you'd better get a lawyer looking over this license and how it applies to you. This is becoming a bigger issue as the biggest SaaS vendors hide behind this clause more and more with incredibly proprietary forks. They offer very little to no actual core development or contribution and it goes against the previous method of GPL code getting funding. It annoys me, as the legal headaches of contributing internal only use code back will block some companies from using OSS, but I see it both ways. The startups who are doing a lot of the core housekeeping of NOSQL platforms are learning they can't find a business model. This is getting messier and messier. Partially because there are just too any vendors involved. What's amazing, though, is that a move like this took a customer who was very into MongoDB and using it in projects and was literally working with MongoDB's own hosted product and now looking to avoid it like the plague. So at least in this one case, they are likely losing hosted product from this. And gaining nothing. I imagine a lot of customers going through this same process.

If you want to exit the SQLite command line shell, the command is dot exit... .exit

@jaredbusch said in MongoDB Storage Engine Error Detected MMapV1 and wiredTiger: @scottalanmiller okay, they totally fucked this up. Yeah, this is some weird stuff.

I hope for you it must be enough effective next instrument that is called MDB Online Service (as I know it's free)

@jaredbusch said in MS SQL Server Best Practice Guide on Scale HC3: You actually get your SMB clients to plan ahead? /gasp! We try!

@oksana Still backups are needed

@hobbit666 said in Installing MS SQL Server 2017 Express on CentOS 7.4: This is cool, don't think management here would go for it. Too much of a M$ fanboy lol Just tell them that this is MS' big play for SQL Server. True fanbois would just on it

We have plans to add an in memory database to ML in the future when more performance is needed, as well.

Oh that's funny and interesting! Might I ask what sort of work so I can see a little bit about what is done?

If you were looking for a de facto direct replacement to MS SQL Server and just didn't want to have to "think" much about anything, the obvious choice is PostgreSQL.  It is one of the world's most powerful, mature and respected database platforms.  It is insanely fast, scales insanely big, is supported on the most enterprise style deployments, does relational the same way that MS SQL Server does and so forth.  It is the most direct competitor.  And you have loads of top end support options for it.  So if you want a safe "starting point", start there.  It's hard to go really wrong.  But best to do an evaluation of needs as there are just so many great options

@WLS-ITGuy said in MySQL to PostgreSQL conversion: Well, that was a thread that will fizzle out quickly Thanks for the assist all. LOL, sometimes that's exactly what you want. This would have been a large, horrible project. Now it's a simple "Oh good, we are all set"

@matteo-nunziati said in Pronunciations of SQL Derived Database Names and Terms: we have a company in my town: second quadrant. the provide professional postgresql support worldwide and they pronunce it "postgres". omitting the final "ql" That's the official pronunciation and it was originally spelled that way. The PostgreSQL spelling was added when it went open source.

You will often hear or see the term RDBMS or Relational Database Management System. This term refers to a subset of DBMS, not an alternative, and is specific to those DBMS that handle relational database formats. The term SQL is often incorrectly applied to these, but SQL is a language and relational databases are a mathematical model. While the two have a relationship (no pun intended) they are different things completely and are not directly tied together. Today, what is and is not an RDBMS is increasingly unclear as nearly all DBMS have some relational element and even the most traditional RDBMS stalwarts have begun to add non-relational engines or options.

@JaredBusch Sweet!

@JaredBusch said in Files in a LANLESS system: @scottalanmiller said in Files in a LANLESS system: @Dashrender said in Files in a LANLESS system: @scottalanmiller said in Files in a LANLESS system: @Dashrender said in Files in a LANLESS system: @scottalanmiller said in Files in a LANLESS system: @Dashrender said in Files in a LANLESS system: @scottalanmiller said in Files in a LANLESS system: @Dashrender said in Files in a LANLESS system: @scottalanmiller said in Files in a LANLESS system: @Dashrender said in Files in a LANLESS system: @scottalanmiller said in Files in a LANLESS system: @Dashrender said in Files in a LANLESS system: @scottalanmiller let's assume that we get direct application access from Word/Writer into SP or NC, how do you send a link to someone else so they know they have access? How do you register that 'link' in some way so that the correct application launches when trying to open the link? How do you do it today? Why would it need to change at all? Paying particular attention to Gene's wording, there would be no more files, only data in a DB. In that case, to send the information via email would mean extracting that data into some kind of usable format then emailing it. So the contents of the file are simply sent as a file.... that's all a file normally is, a database holding text directly on it with a label on it with the filename. So.... literally nothing changes here under the hood. There is no more or less extraction than before. You were weren't talking about getting rid of docx files and xlsx files, etc? Yup, and still am. No files, but that doesn't mean that you can't have a file "view". But OneDrive, etc still store those things as objects, I don't think you can edit the 'Word.doc' file directly inside the DB, you need to send that object of data to Word to edit it. As objects, not as files. I don't need to pull the files from OneDrive to edit them. I can talk to the database directly with MS Office 2013 or later, even the online version. Yeah Office is a bad example because of the massive integration. Or a good example because it shows how easily it can be done and how well people can't even tell. LOL - yeah, but you are limited to only MS based files, All other files are just stored as objects in the DB. Are they? I'm not sure of that. But that's always going to be the case. File systems are for ad hoc, unplanned files. The real question should be... why do such files exist in your environment? When do you actually want ad hoc file types that you didn't expect? Actually Sharepoint does not natively interface .doc files either. It only uses the new format .docx files in the manner you are saying. Don't I know it.. I was playing with SharePoint and damn if I didn't have all kinds of problems with DOC files.

@scottalanmiller said in Help with SQL query: @BRRABill said in Help with SQL query: @scottalanmiller said in Help with SQL query: If you expect this product to explode Possible poor choice of words. Or... intentional. Knowing you, intentional.