In AWS's direct postgres offering RDS Postgres, you can require SSL by setting the parameter group item rds.force_ssl to 1.
This is as per the RDS postgres documentation: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL
However Aurora ...
@PaulWhite I have total faith in your reasoning. I'm just not sure that you wouldn't sometimes like to smack people (including me), when they (I) post comment-answers instead of answer-answers.
I've now read my question and the answer four times each to make certain I'm actually answering the question. Monday mornings are not a thing that should exist.
I need to query the description of the Sales.SalesOrderHeader.Status column from the AdventureWorks OLTP, which looks like this:
| SalesOrderID | RevisionNumber | OrderDate | ShipDate | Status |
+--------------+----------------+------------+------------+--------+
| 43659 | 8 ...
@PaulWhite What @hot2use suggested ultimately turned out to be more of a pointer than an answer. It seems to qualify as relevant but minor information, using Help Center parlance.
> Add relevant but minor or transient information to a post (e.g. a link to a related question, or an alert to the author that the question has been updated).
@AndriyM Do you think so? It seems to me to be an answer to a misreading of the question.
Perhaps it was in a different form originally. I didn't look at the revisions.
@PaulWhite I believe you are right. Until Simon's answer, though, it did look as a pointer worth exploring, as it was suggested based on comparison with an equivalent product for a different platform.
It wasn't really a pointer, it was an attempt at an answer, I understand that. I meant that it still had the value of a pointer until Simon answered.
Hi I am not the same person but I am a team member of the same requirement (project). Actually I had posted some more clarification on that post but I see message that it is deleted so I posted same question as separate thread but with more details. I wanted to explain more details on that thread and that's the reason I replied but because of deletion of the same I posted new question. — Ani15 hours ago
Perhaps part of the blame should be on the editor. I sometimes (or often) edit questions before trying to understand what is being asked, like horse did this case. He made the question so much better that it encouraged two people to post answers.
@PaulWhite - what's the deal with deleting that old dupe question by user146892 ? I get that he posted more detail in the new version of the question, but just curious why not let him figure it out by getting the new question closed as a dupe of the old one? He could have edited the old question and had it re-opened.
The new question was much better and has a couple of answers already. Seems a more productive use of time than putting everyone through multiple review tasks (close as dupe, reopen review on old q).
Also the deleted -4 question serves as useful input to the auto-q-block algorithm.
@MaxVernon I did a quick investigation, it's not the number of events but how much space the fields and actions take. So there isn't a hard defined number of items, but there is only so much space allowed.
@MaxVernon Yes, but it's subject to change and I only looked at 2016 SP2 since the question was tagged 2016. I'm not sure it's something that should be published, and to be honest I probably wouldn't go around counting bytes in my XE. If you need that much data with a single XE you're probably doing it wrong.
@MaxVernon You can try, but it's going to most likely crash your system
<rant>
People always say "XE is a lightweight ..."
Here's the thing, it's as lightweight as you make it. If you add a whole bunch of actions and no filters it's going to completely cripple your system. Capturing every execution plan for everything everywhere with 1000 people all running queries is going to cause massive performance issues.
The framework is lightweight, decided to capture the ridiculousness that is "I don't know what I'm looking for so check all the boxes" is not lightweight.
@MaxVernon Are you writing an answer or would you like me to? Didn't know if you had something written and wanted confirmation or just wanted more eyes because of the featured status
@SeanGallardy-Microsoft I considered writing an answer, but "some amount of space" is not quantifiable, and likely not much help. It seems like perhaps it's a pet-peeve of yours, so go ahead and provide the answer if you like!
@MaxVernon It's not a pet-peeve, just something people hear and randomly take at face value without thinking. There is a scientific way of determining roughly how much - I'll try to make an answer today.
@EvanCarroll I don't think we should put the proles on the front line, either - we agree. Oh, you mean mechanical drones and not worker bee people enslaved in socialism... my bad
The insinuation is that SQL Server isn't stabile? Not sure where you're making that up from. How about security? Oh that's right, less security issues than you since... forever.
on a serious note though, just to reiterate -- I'm still working on @SeanGallardy-Microsoft's secrets.
Though, of course, I never took the knee like he did and I won't bow to pressure from Microsoft. It'll come when it comes. ;)
I spend at least 3 hours a day learning this stuff.
It's a lot of work and there is almost no guidance on it anywhere, online
When it comes @SeanGallardy-Microsoft is going to send me a signed honorary gold-plated "Microsoft Natural Keyboard Pro", the only decent thing Redmond has ever given humanity.
The Situation:
Our 2008 MSSQL server is old and rapidly running out of drive space. We have a new 2016 server ready, we just need to move a 40 TB database from the old server to the new one.
The DB, of course, has dozens of tables, but the EVENTS table is the one that is eating up all the space....
@Lamak The only way it "loses" them are the questions I asked about - I looked at the source and that's the only time (other than not getting a lock on the file, AKA filter driver/antivirus). If it needs further investigation (since it happens irregularly) then unfortunately you'll need to make a feedback item
bwahahah if I said yes, you'd order the Microsoft Natural Keyboard be revived and marketed as "Evan approved." It'd sell like hotcakes, and Microsoft would be one step further away from bankruptcy.
That's why I like the thinkpad alternative, and trackballs.
you can (a) use them with one hand, (b) don't have to have that one hand tied to a flat surface, (c) get reasonable accuracy without getting in your way.
I use the m570 at all my workstations though they have a better one now
I don't carry around mice and keyboards simply because I don't really use the mouse, and the lenovo keyboard doesn't really suck like most of others. Though the mechanical ones are substantially better, I just don't care enough.
In AWS's direct postgres offering RDS Postgres, you can require SSL by setting the parameter group item rds.force_ssl to 1.
This is as per the RDS postgres documentation: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL
However Aurora ...
I need to query the description of the Sales.SalesOrderHeader.Status column from the AdventureWorks OLTP, which looks like this:
| SalesOrderID | RevisionNumber | OrderDate | ShipDate | Status |
+--------------+----------------+------------+------------+--------+
| 43659 | 8 ...
