« first day (2124 days earlier)      last day (97 days later) » 

12:01 AM
RELOAD!
[banane-io/PDB] 3 commits. 28 additions. 5 deletions.
[banane-io/pdb-frontend] 1 commit. 32 additions. 19 deletions.
[Minesweeper] Games Played: 177, Bombs Used: 95, Moves Performed: 19046, New Users: 55
RELOAD!
[rubberduck-vba/Rubberduck] 5 commits. 18 additions. 26 deletions. 1 issues closed. 1 issues opened. 20 issue comments
[Zomis/Server2] 10 commits. 1016 additions. 345 deletions
 
 
4 hours later…
4:00 AM
@MathieuGuindon let coercion +
Sub LetSet(ByRef var As Variant, ByVal val As Variant)
don't judge :)
 
 
6 hours later…
11:04 AM
@Duga Unfortunately, this is very unintuitive and not well documented. The wiki reads, "When synchronizing attributes, this will add or update the module's VB_Description hidden attribute:" Granted, that does say "syncing", but that one word doesn't adequately describe the process of adding the annotation, parsing the project, looking at the inspections and applying the proper fix (is there a "fix all in project" quick fix for this one?).
 
11:30 AM
> Okay thinking about this more, wouldn't there be at least a bit of generalization, like wouldn't you want the inspection to examine userforms too, for example?
 
11:52 AM
monking @all!
Interesting, I'm not getting this when I connect to our Azure data warehouse. I don't recall having received this warning before, but I may have and may have suppressed the message on my other machine.
Since I'm not certain what these settings do, I'm pretty sure I don't use them, and that, therefore, it is reasonably safe to ignore this warning?
 
12:11 PM
week 3 has commenced; hope all are well
 
All good here. Y'all surviving without homicidal thoughts toward spouse or offspring?
;)
@FreeMan "I'm not getting..." Then why the heck you posting the message, you nimnod?
If only I could blame that on autocorrect or something... There's no autocorrect on the desktop machine, just incoherent typist
out of the blue, I'm getting this error from my Access application that was working just fine earlier last week, late the week before:
Source: Microsoft OLE DB Driver for SQL Server
Error Num: -2147467259
Description: SQL Server Network Interfaces: Error reading adalsql.dll path from registry. Verify that Active Directory Authentication Library for SQL Server is properly installed. For details, please refer to go.microsoft.com/fwlink/?LinkID=513072 [2].
some searching for the description string led me to this site where he indicated that the adalsql.dll file was present on the machine in question, but wasn't registered.
I've searched my machine, but I don't have that file at all.
Do I need to install the Active Directory Authentication Library for SQL Server locally on my desktop machine?
If so, why would I suddenly need it now when I didn't need it last week?
 
12:34 PM
That is a bit strange because AIUI, that is no longer needed since 18.3 something
> Embedded Active Directory Authentication Library (ADAL). A separate installation of ADAL is no longer required to use certain authentication methods.
if you somehow downgraded to pre-18.3, then yeah, that'd be why.
 
Also found this indicating it breaks with every update to SSMS.
 
Interesting. Hasn't happened to me. Yet.
 
hrm... I wonder if I did do an SSMS update last week. Yeah... I'm pretty sure I uninstalled and reinstalled everything SSMS, VS, and ADO/DAO related last week to get my laptop working.
 
Yeah, I can see it if SSMS shipped pre-18.3, then ka-boom.
 
and... I'm pretty sure I haven't used my Access app to access the Azure database since I left the office...
 
12:40 PM
Stage right enter: Nelson walking up and kicking in the nuts and ha-ha'ing.
 
@FreeMan my wife may want to go jack torrence on me, but on my end we're all good and things are fine. kids still have some day care so we get a little time to work, then unwind after
 
Yeah, pretty much ^
 
I only be crawling on the walls here. That's not a big deal, right?
 
@this indicates that was released Oct '19. Since I just installed the "latest" download from MS last week, surely I'd have picked up v 18.3 or newer, right?
right?
@this you're fine. Just don't lick the toilet. That's gross.
 
Yes, the recent-ish download ought to be 18.3
@FreeMan Hmmm.....
 
12:42 PM
where can I go to determine the exact version
@this supposedly, there was some video of some idiot doing that to say "look COVID-19 isn't bad!". Maybe not, but licking the toilet bowl is gross!
under any circumstance!
 
@FreeMan someone got arrested for that and is being charged for domestic terrorism, since there have been 4 persons to "take the challenge"
 
wait, wut, it was a "challenge" thing?
is grateful he does not read news
 
i heard read about it on imgur and that was one of the top comments
 
@FreeMan boy they don't make it easy, do they?
I would presume you have to dig up the DLL itself and look at the version via Windows' file properties.
I just checked via the UDL & the opened connection string and indeed they don't deign to share it.
 
12:59 PM
@Cyril What's that old saying? "Make it fool-proof and the world will quickly make a better fool." How frickin' stupid are people these days?
 
Well, keep in the mind that turds float.
 
"Intelligence is the ability to acquire and apply knowledge, and the lack of knowledge is ignorance. It is a sad world where the ignorant can stifle the intelligent, and morose when it is encouraged."
 
1:23 PM
0
Q: Extract data from API using VBA & XML (Performance)

Peder CFirst post here. I sincerely hope that I am doing everything by the book. Also, I want to thank you in advance for any help and assistance that you may be able to provide me. I have been coding VBA for 2 weeks and I realise that my code may suck. Problem: What can I do to make my code faster? I ...

 
1:39 PM
sorry... got distracted by putting my contacts in (nothing quite like the fun of poking yourself in the eye several times waiting for the lens to stick when the lens has already slipped down your finger and is no longer anywhere near where the poking part), then by the id10t telling other people to "note the self-reported data by adding an "*" to the otherwise numeric field"
ARGH!!! if the cell is supposed to contain digits, only put digits in it. If you need to make a comment about the number, then use Excel's bloody comment feature!
 
ahh, regex, i'd missed you...
^(?:\d{1,4}|[0-5]\d{4}|6[0-4]\d{3}|65[0-4]\d{2}|655[0-2]\d|6553[0-4])(?:\.(?:\d{1,4}|[0-5]\d{4}|6[0-4]\d{3}|65[0-4]\d{2}|655[0-2]\d|6553[0-4])){0,3}$
 
Thinks @mansellan is a bit fevered...
 
lol
 
@this I don't think I need to go find the version info, I installed using msoledbsql_18.3.0.0_x64.msi. Unless, of course, they broke the installed and shipped an older driver with the new version in the filename...
doesn't trust MS to not screw it up, searches just to be safe...
ummmm.... the file versions reported are 18. 2 .0003.0. That's not right, is it?
 
would be painfully hilarious if they shipped a `msoledbsql_18.3.0.0 ....
didn't even have to finish the sentence
 
1:53 PM
 
lemme see
 
strange timing... that regex is validating version numbers.
 
Misses the joke... that's the exact name of the file I downloaded...
 
why would my windows not have the Details tab?
 
@mansellan that just looks... painful... no matter what it's doing.
 
1:56 PM
yeh... thank god for online testers and cheat sheets!
 
Bizarre. Re-opened the file properties and I now see Details....
anyway it's saying the same thing as yours is.
sooo.... #BlameMicrosoft
 
@this I was trying to, but I haven't yet found my official #BlameMicrosoft inception post...
s'what'r the odds that if I uninstall, DL a fresh copy and reinstall, Imma get the exact same thing?
And why in the world is this suddenly a problem? It worked fine on my desktop machine a couple of weeks ago.
 
didn't we blame SSMS for that?
 
:derp: because this isn't my desktop machine and I must have that other driver on the desktop from somewhere for some reason
you're thinking SSMS installed an older version?
 
Yes, as per your linked SO post, no?
 
2:01 PM
reinstall from my already DLd installer should give me 18.3 instead of 18.2
@this yeah, guess that makes sense...
 
should being the operative word....
 
thought I would have installed the driver after SSMS, but who knows.
I'll do an un/re-install
sigh
 
you need to do a nasty email to MSFT, too.
 
"fun" fact: .net 2.0 can run on Windows 98...
 
no way.
 
2:04 PM
Microsoft started development on the .NET Framework in the late 1990s originally under the name of Next Generation Windows Services (NGWS). By late 2001 the first beta versions of .NET 1.0 were released. The first version of .NET Framework was released on 13 February 2002, bringing managed code to Windows NT 4.0, 98, 2000, ME and XP. Since the first version, Microsoft has released nine more upgrades for .NET Framework, seven of which have been released along with a new version of Visual Studio. Two of these upgrades, .NET Framework 2.0 and 4.0, have upgraded Common Language Runtime (CLR). N...
 
not entirely sure... this looks like the stand-alone install gives me the wrong version:
will try anyway
 
hm.
yet, it's 3/24
 
which is right about the time I was attempting to beat the laptop installs into submission. I spent Monday installing everything and Tuesday reinstalling.
 
@mansellan hmm interesting, but I wouldn't be surprised if it just seized Win98 & Me up every minute or something, though.
 
reinstall can't hurt, I s'pose...
 
2:07 PM
@this yeh they dropped it pretty quick. I imagine it would've been a nightmare trying to get it stable on a 9x kernel.
 
good sign (I think). uninstall went fine, but the install complained that I had SSMS open.
 
bizarre - my windows can't find the OLEDB driver in programs & features in both places.
no, that's because it's "OLE DB"
hooray!
so apparently I've been running 18.2.1
I may have had it downgraded when SSMS updated and I didn't noticed yet
oh, this gets better and better:
let's play "guess the bitness" game!
Ok, updated and now it does show 18.3.0... in the details as expected
Well, that is very good that you shared your experience. Otherwise I'd never have realized that Microsoft sneakily downgraded my driver without ever telling me about it.
 
Yup. Same here. After the reinstall, I've got 18.3.0.0
now, the real test... does my code work...
 
If doesn't, send a double nasty email to MSFT
Maybe CC Bill, Steve and Satya. That'll get their attention!
 
like a boss.
will have to remember to reinstall the driver after every SSMS update...
 
2:23 PM
at least until MSFT unfubar itself.
 
decides not to hold breath
 
3:10 PM
anyone used bitbucket? I want a private repo, but I'm too cheap to pay for GH :-)
 
I've sent things to the great bit bucket in the sky, does that count?
 
@FreeMan That bytes.
 
haha
 
@mansellan only as an user. It did feel clunky compared to GH, tbh.
But if you want to be cheapo, you can just host your own git server, you know?
 
or even just put the repo on your local network
 
3:15 PM
yeah I guess. was looking for something off-prem though
 
cheapo godaddy server, install git, done!
 
lol true
 
ok, maybe not godaddy but any one of bajillion cheapo web hosting solution
you're basically want a off-prem storage, essentially
hmm could one git to a dropbox folder?
probably a bad idea™.
 
meh, i'll park it for now, and just hope my SSD doesn't explode
it'll be going MIT on GH soonish anyway, but wanna clean house in private and would be gutted to lose it near the end
 
well, some sort of backup is always recommended. Even if it's just 2 cheapo 1TB external drives that you make backups to daily, then once a week swap for an offsite at the folks or a trusted friend.
 
3:18 PM
wait, I can just plug a thumb drive in...
 
seriously, 1TB externals are a dime a dozen these days...
or that.
 
@mansellan Well, in which case, it'll be in the bit bucket!
 
:)
heck, 2 of these and an external dock is pretty cheap to not lose important stuff
and will give you acres (or hectares, your choice) of storage for years to come
 
well.. I've actually got two of these - one (currently?) broken. But I moved some stuff about in the house a while ago and never got around to setting them back up. I should probably address that...
Just waiting on those 20+TB HAMR/MAMR drives that have been "a couple of years away" for like 10 years now, then I'll be rocking some serious space.
Picked up a couple of 10TB WD Reds last Prime day, wish I bought more now. Maybe this year.
 
You may be interested in unRAID. Very low cost server software. Raid-like, but, as the name suggests, not RAID. I've been running a server for about a decade now, and it grows quite nicely as needed.
Fantastic support, loads of docker support (including a git server), and I think it'll even run on repurposed QNAP hardware.
Best part is that you can grow your storage by one drive at a time and they can be any size because it's not RAID
 
3:30 PM
@FreeMan Hmm, interested. The broken one has a dud backplane, which are impossible to source. I'm gonna get an electronics chap to see if it can be repaired, but if not i'll just pick up a cheap HBA and hack the enclosure/mobo to run something other than Qnap OS.
 
@FreeMan so it's a just a NAS?
 
@this NAS software
 
seems naming it "unRAID" is a poor name.
 
DL a trial copy of unRAID, follow the instructions to make a bootable USB and fire it up. It runs totally off the USB and a RAM drive created on boot
 
Since one RAIDs for redundancy
 
3:32 PM
Will do... Not sure if the QNAP BIOS (american megatrends) has been locked to prevent USB booting, usually the thing boots from a disk-on-module.
 
Yeah, NAS software. It does require a parity drive for data protection (1 parity drive can survive a single drive failure, dual parity can survive 2 simultaneous drive failures)
 
ahh, so that's where the "unRAID" bit comes in
 
take a look through the forums - I'm about 99.90% sure someone (or more than 1 someone) is running it on old QNAP hardware
OK, it doesn't require a parity drive, but it is recommended... ;)
 
yeah the DOM is just a custom USB header, I'm sure its doable.
 
Yeah it's just that calling it "unRAID" kind of implies there's some redundancy that's not using RAID approach somehow
so if it was a mere NAS software, I'd be gobsmacked.
 
3:34 PM
The working one was running raid-6 but I lost a drive
so its effectively 5 now
protip: don't buy seagates...
 
@mansellan Did they revoke your driving license for that?
 
The parity drive provides protection against data loss if a drive dies. However, I'd strongly recommend posting a question on the forums to get support on recovery.
It's shocking how many people seem to think formatting an apparently failed drive is the first step in data recovery
 
wait, wut?
 
@mansellan Remember death stars?
 
@mansellan hopes he didn't follow that link earlier
 
3:35 PM
@this never got bit by that, but remember the fuss.
 
Me neither but that was what made me try and avoid Seagates in my purchases.
 
apparantly they're better these days. idk...
WD all the way
 
@mansellan How so western of you. :-p
 
@this I'm a digital native :-)
 
pot calling kettle black
 
3:39 PM
Ugh, this clickonce thing seemed such a good idea at the time. now it just feels like a slog. Maybe I need a break.
 
lol
Frankly, I've had drives of many different brands. I'm a big proponent of "whatever's on sale when I desperately need one". I had one drive go bad back in the late 80s costing me data, but most of the data loss was my own fault, not the drive's fault. Bad attempts at recovering data were to blame.
with unRAID, there's a tremendous amount of disk health monitoring & notification (if you turn it on). The only data I've lost with it was, again, user error.
I deleted about 10TB of stuff by accidentally clicking the wrong thing then letting it run a while wondering why it took so long.
Fortunately, the critical stuff was backed up, so I restored. The rest involved re-ripping DVD/Bluray disks
so that just cost time.
I did lose quite a few ZIP disks to the dreaded click-of-death, though.
ahhh... the good ol' days when 100MB on a 3.5" disk media was massive storage
 
@FreeMan provided you actually had the drive to load the disk
 
Oh I had one. Two, actually, if I remember correctly! One of the best things about the ZIP drives, is that they actually did the daisy chaining of the LPT port that USB promised and never delivered.
 
That period was kind of painful when it came to trying to transfer data between two computer via sneakernet.
 
Because of the way my desk was setup, I had the 'puter on one side and the printer on the other. I used the ZIP drive in the middle with the longest LPT cables I could find/afford on either side. It was a powered LPT extension as well as storage!
 
3:49 PM
I can't remember but there were many times where I had a zip disk and no drive; it wasn't practical to bring around the drive ( probably because it wasn't mine, or because it was shared among the family and thus had to stay with the computer ).
The other option was burning a CD. Everyone had burners, right?
yeech
 
@FreeMan My current plan involves RAID-6 (or equivalent), plus also backing up rips to externals, the latter being whatever size/quality I can acquire for cheaps (within reason). Once I get enough Reds, the seagates are gonna be relegated to offline backups.
ripping takes way too long for me to trust any raid entirely
Especially UHD ripping...
 
I stick with 720p (since that's all the TV displays). Saves time & space!
 
heh, 4k is like 50GB+
 
yerp.
Don't know that my eyes could tell the difference. :(
 
4:04 PM
But I just rip raw, no transcoding.
Only tried a couple of UHDs so far, I don't really have a client device (or network) that's fast enough to keep up with the bitrate yet.
But usually its the native blu ray stream
 
Lazor disk all the way!
 
lol
Had a friend in college buy an LD player and some Disney disks. That was some pretty hot tech back then
 
Remember Dragon's Lair?
 
Sorry. I didn't get much sleep and my brain doesn't work normally in the morning anyways.
 
oh yeah! was never any good at it, though
 
4:10 PM
Never actaully played it but saw it in the arcarde
 
Had a Commodre64 port of it. Saw the youtube play of DL, and htat really made it look like a slug in comparison.
 
played the console version a few times back in the day. When they had an arcade in every mall in the country
 
Which console? Was it a good port?
 
sometimes there were 2!
sorry, stand up arcade console, not at home console. mah bad
 
oh yes
DL was one of those games that didn't port very well
 
4:29 PM
I don't think there was much to the game to begin with. I never played it so hold no attachment to it.
 
It's basically a computerized version of "choose your own adventure" books.
 
Did any of those games have much of a plot?
 
but even so, the books had more than one way to "win" but I think Dragon's Lair had only one way every time.
 
A 'But Thou Must!' railroading?
 
I don't know of any other LD games besides DL, TBH, so can't really answer.
Yes
 
4:33 PM
I was scarred by Princess Gwaelin when I could never say No.
I was like #NoMeansNo. But she just wouldn't listen.
 
You'll get the idea ifyou watch the playwithme youtube video fo the DL arcade console.
lot of button smashing required.
 
@this: any thoughts?
5 hours ago, by FreeMan
user image
I get that connecting to our Azure db. Don't remember seeing it initially, but I may have and just clicked "Yes always"
 
Keep in mind I've never worekd with Azure data warehouse, that might be expected
 
mkay. I just assumed you were the master wizard of all databases. #BubbleBurst
 
Suggests that for isolation level, READ UNCOMMITTED is the only option.
Strangely, no mention about data warehouse beside that it's apparently supported
 
4:41 PM
I'd presume that our DBAs have set what they think are the best options. I just didn't recall seeing that warning. Prolly not a lot I can do 'bout it. Guaranteed there's not a lot I understand about it
 
Not supported.
@FreeMan Not necessarily - that might be just SSMS' default setting, and not their doings.
 
I guess it's safe to ignore them for the future.
ah, true dat
 
I've seen lot of reports where they go "it was fast in SSMS but slow in my application WHY!"
Turns out because the settings aren't identical between the two. Yay!
 
well, Buford, if you're querying a local DB, it's gonna be faster than if you're querying one hosted on a server somewhere else
 
5:12 PM
well... that was fun...
The wife just asked, "what happened to my gmail?"
went to gmail.com and Firefox just showed an empty tab. https://www.gmail.com showed an empty tab.
calendar & photos worked just fine, gmail didn't exist.
 
that's so cool
 
restarted firefox. all is better now.
weird...
of course, that interrupted me while I was trying to figure out how I'm missing 2 records for one client, and I've got 2 other clients, 1 is reporting 1 more record than it should and the other is reporting 1 less than it should.
A simple query of the DB is showing the right numbers, I'm just not picking them up in my reporting query.
le sigh...
#BorkenStoredProcedure
 
 
2 hours later…
6:57 PM
AAAARRRGH!!! No wonder I was pulling the wrong numbers, the queries were looking at different date columns. :( Took a lot of looking to finally see that...
 
I hate stupid issues like that
 
I'm happy that at least I found it instead of posting it somewhere and asking why I was getting the wrong data. That's much more embarrassing.
 

« first day (2124 days earlier)      last day (97 days later) »