@SeanGallardy-Microsoft that is the gist, but only kinda sorta dead. They insist he lives but like Microsoft they also don't like comparative analysis and explaining how that whole process works internally.
@McNets @SeanGallardy-Microsoft I think simply @-referencing someone in a room won't work if that person never visited the room (or hasn't visited it in a while, not sure about how long). As for how to invite someone, I don't know of any way other than to notify them in a comment on the main.
the only exceptions to that are the things like lib_phonenumber (which are C++), and the GIS stuff which are C++, but all of that is still done in C against the hpp headers
@SeanGallardy-Microsoft the whole system is build around macros. there are good reasons to hate them, but the gods of PostgreSQL have made a pretty magical system with them.
@SeanGallardy-Microsoft Old school unix - early versions even used the fork and shared memory model, although it's had a tread pool for a decade or two now.
It seems as if the TF doesn't have the intended effect when inserting into a table and filtering on a computed column that's also the partition column using $PARTITION.function
Anyone heard any reports of service accounts losing logon as a service wrt SQL Server installs? Or know what would cause that in general across EVERY ONE OF MY DEVELOPERS MACHINES. Even gpolsec changes
Tomv thinks it could be some sort of endpoint protection agent or something
"We have made no GPO or AD changes at all ever in the entire history of the company. We do not monitor Windows or AD. We are strictly hands off of the entire business. We basically just come up here to stay out of the cold. We don't even have hands."
@EvanCarroll wait, there's a command for that? I would love to try it. Something went wrong in like March 2016 and I wanna reset to at least January 2015 to ensure it wasn't something in between
@SeanGallardy-Microsoft did you not know that trick? >.>
You can use the ~\ to mean home anywhere you would type C:\users\cbrand\blah
From a first look I guess it won't account for a new year but it shows that there is a modified date on the gpo so the resulting script you need could be straightforward
so can we create our own functions that execute symbols in C++ like that? that is to say, is this dynamically executed or compiled? Can I make my own calls to OpenRowset(TABLE DM_SERVER_REGISTRY)
Right, I'm wondering if I was to hack that name in mssqlsystemresource if it could execute arbitrary internal C++ code, or if it was a actually C++ sub that carried around meta information (like pseduo-SQL)
@SeanGallardy-Microsoft definitely helps, it's near complete; though I would like to know if you can you call arbitrary C++ symbols, how compilation works (are they compiled when the server starts like the Hekaton stuff), is the source merely symbolic or does it function in any capacity for a compiler or in runtime, how does the code prevent OpenRowSet from being used in user-space and can that be avoided if you wanted to dump these structures entirely.
So @SeanGallardy-Microsoft and @TomV and etc, I haven't gotten the damned reports to run because reasons. My machine. I'll get them. In the meanwhile, check this out
@EvanCarroll Try using openrowset arbitrarily to do something, you'll get a compilation error. you can use it to open files and whatnot but to execute code is another thing. Can you do it? Maybe, but it'd require detouring which isn't AT ALL supported.
@jcolebrand Normally when I see these, I hear "oh it was supposed to be in passive/learning mode - ooops"
@SeanGallardy-Microsoft Why are you worried about 2019 releases? The 2019 car models are already being sold (hyperbole?) so you should be focused on 2020 database structures!