« first day (1936 days earlier)      last day (1244 days later) » 

9:00 PM
but mostly useless in querying
 
until you write a history viewer, then they're now in the query?
 
and then it's obvious you're selecting a control field and not just some timestamp
 
@FreeMan I think you forgot the mid
 
VBa, why can't you be handy and simple...
 
(I'm not even sure how foo(1) would have worked)
 
9:01 PM
> Narrator: It wouldn't.
hey @SimonForsberg!
 
Hey!
Got a question for you, @MathieuGuindon. Where did you order the customized stickers for Rubberduck?
And approximately how much does it cost for a bunch?
 
got them from "Canada Stickers", some sticker company in Ontario. they cost a few cents each ($0.55 or $0.75 IIRC).... I could pull the spreadsheet when I'm home, but it was between $50 and $75, ...pretty sure shipping from Ontario to Sweden will cost more than the stickers though :)
cost would probably have been much less than that had I ordered more
(I think I ordered 100)
 
I haven't found anything quite appropriate to put mine on yet.
 
TBH these stickers suck
 
Laptops break, and then you are out the sticker (besides, I don't like stickered laptops).
 
9:07 PM
we need to make another round, and make a sticker out of our new logo - that'll rock!
2
 
Let's target it for after Avalon code panes :P
 
hm
Rubberduck is turning 5yo during this year's Hacktoberfest
5
 
♫Happy Birday dear Duckie♫
waves @SimonForsberg
 
@MathieuGuindon and unlike thousands of GH repos, it's active!
 
@MathieuGuindon I'm just to estimate how much it would cost to make some of my own.
@FreeMan waves back
 
9:13 PM
Duga Webhook disabled for releases
 
Don't you mean dereleases? ;-)
(or is it deleases?)
 
@Vogel612 @Duga is sad about this :(
 
@this if y'all'd followed my suggestion it would have been a simple drinking game...
 
Duga Webhook reenabled for releases
Prereleases around 2.3.0 and 2.3.1 are now removed from the github releases
 
Alter table dbo.CompilerInputs
	add constraint ID Foreign Key (ID)
		References dbo.InputWindRisk(ID);
> There is already an object named 'ID' in the database.
 
9:15 PM
@MathieuGuindon yes, but if your script is maybe 20-25 lines not including white space
do you really need to split it up?>
i also updated hte gist with updated code gist.github.com/KySoto/1cb1a2fe97244b40da4d2a7bac287806
it actually runs correctly now
xD
 
@IvenBach you don't want to name your constraint the same as your column
 
brb break time
 
Mat uses convention of FK_<table>_<other table>. I use FK_<table>_<column>
All constraints within SQL Server has to be uniquely named because.... #reasons. sigh
(TBH, SQL Server is braindead and obnoxious in that particular area)
 
(disappears silently)
 
^ doesn't look like disppearing silently.
 
9:18 PM
I'll use your convention and grant you the interweb point for this. I will more readily remember yours.
 
PSA: Don't forget to delete you local prerelease tags if you have any:
git tag --delete $(git tag -l Prerelease-v2.3*)
I will haunt you if you push prerelease tags ;)
3
 
if I fetch, it'll clean it up, right?
 
no
 
:(
such a hoarder git is!
 
Once again, I'm missing the obvious...
    Private Type TInfo
      requestHeaders As Scripting.Dictionary
      bodyParameters As Scripting.Dictionary
    End Type

    Private this As TInfo
    Implements IRestDriver

    Private Property Let IRestDriver_bodyParameter(ByVal key As String, ByVal Value As String)
      this.bodyParameters.Add key, Value
    End Property

    Private Property Let IRestDriver_RequestHeader(ByVal key As String, ByVal Value As String)
      this.requestHeaders.Add key, Value
    End Property

    '-----------------------------------------------------------
maybe I should pack it in and go home for the night.
OK. I'm home
 
9:22 PM
Ok I legit lol'd
Hmm just proves that @MathieuGuindon is human. Who woulda known? — K.Dᴀᴠɪs 4 mins ago
@this within schema IIRC
 
You awesomeness whelms people enough that it's easy to forget.
 
@IvenBach wonders why would IvenBach talk to an abstract concept such as awesomeness
 
I created a new table via query editor. Is it normal to have to disconnect/re-connect in order to see it? Refresh doesn't list it.
 
refresh should suffice.
 
@IvenBach verify you didn't just create the table in the master db...
(and put USE {DBNAME} at the top of your scripts from thereon ;-)
 
9:29 PM
This is all in my testing db. I cant bork anything up. That's what IT claims.
I'll probably prove them wrong somehow.
 
@MathieuGuindon Example breadcrumb? Sorry I'm just really unfamiliar with all this.
 
USE MyStonewalledSandboxDb
 
@MathieuGuindon lol. I usually am opposed to using USE {dbname}
 
GO
@this eh, I accidentally ran stuff against master too many times to skip it now =)
 
9:32 PM
yeah, I can see why.
but for me, I usually want to create the same object in few different databases
 
Use TestingDB
create table dbo.InputSectionSet
(
	ID bigint Not Null,
	HSSBeam nchar(10),
	HSSColumn nchar(10),
)
 
and having USE becomes an inconvenience.... esp if it's somewhere in middle of script
 
^^ Is it as simple as it seems?
 
@IvenBach yep.
 
(esp. when I'm copy-pastaing from the CREATE SCRIPT..... #BadHabit)
 
9:33 PM
Mkay.
Trying to cobble this together.
 
you'll want to first drop the table if it already exists, but before that you need to drop the FK constraints if they already exist - and then you should be able to hit F5 to run the script as many times as you want, and get the exact same outcome every time
 
It was already inserted into the correct TestingDB.
 
Getting the same outcome (no errors, no dangling objects) every time is where I put my bar for my scripts - YMMV
 
why are all the items prefaced with 'dbo'? I feel like I've already asked this.
 
that's the default schema
 
9:35 PM
schema
you can have more htan one schema
 
you can create others under the 'security' node
 
but SQL Server has some weird behavior when you don't include schema
e.g. CREATE TABLE foo could end up in user.foo instead of dbo.foo
 
always qualify everything with a schema
 
^
 
:bork: meeting. AFK.
Wow that felt so 90s.
2
 
9:36 PM
TTGH - later!
 
ive been fighting this emailing issue ive had all day
to hte point i rebuilt the **** thing in C#
it worked in C# but kept asking if i was sure i wanted to run the application
despite it being signed by a cert created by our CA
-__-
 
Ah, the good-ole Windows permissions...
 
yeah
so i went back to hte powershell script
messed with it a ton
then wondered...
does it have the same problem that the .net one does? if you dont put a half second wait after you try to send it, it just doesnt FREAKIN SEND?!?!
THE ANSWER IS YES.
so i put a 500ms sleep on it
and BLAMO
 
Wat...
That sounds so wrong, LOL.
 
suddenly im getting emails
as wrong as it sounds
 
9:39 PM
Oh wait.
Are you using a task?
 
thats what fixed it
 
If it's firing up a Task, you'll need to await it.
 
no, why would i be using a task?
 
@KySoto powershell is dot net
 
awhat?
 
9:40 PM
You can think of it roughly as another thread.
 
@Hosch250 NOOOOOOOOO!
 
yeah but even .net doesnt know what mail client it wants to use
 
LOL.
Yeah, it's more like a unit of work.
That might get a thread.
 
i looked up the system.net.mail.mailclient
and its like DONT USE ME
im like wut.
yeah. it wants me to go get some nuget package thing for some mailclient someone else made
 
@KySoto oh damn, I had the exact same problem a couple weeks ago - there is a nuget for that
 
9:41 PM
cept that mail package doesnt work on .net 3.5
xD
 
and it works super well
Oh
 
except on 3.5
 
@KySoto why not use .net standard
 
@this TBH, I don't think .NET Standard supports 3.5?
 
^
 
9:42 PM
I think it came around sometime around 4.5?
 
no no it's the same realization I came to earlier
if you use standard, you can ship it to any computer that doesn't have it installed
because it's self-contained
right?
 
No.
 
the thing is, i dont know how patched the machines are
 
It's just a "standard".
It's basically the intersect of Core and FX.
 
quite a few of them have just been working and not getting patched since no internets
 
9:43 PM
wait, what was all the talk about self-contained (no patch, no install, etc.) then?
 
It's not an actual runtime, it's more like an interface for a runtime.
I think that's part of Core?
 
then I must be conflating again. Why not just use core project?
 
Some upcoming feature or something (or just-released).
I would now :D
 
then you don't have to worry about whether a machine has X patched
 
either way, for my powershell script, i had to wait .5s to get my stupid send-mailmessage to work
 
9:44 PM
But Core also needs to be installed.
 
because your exe is now fully self-contained
 
It's not a machine patch, just a component.
 
BOOOOO
 
@KySoto wrap up your app in an installer, and make it download & install the framework? surely IT won't mind! .........
 
At the moment.
i don't know if this part of it actually shipped yet.
The self-contained part.
 
9:45 PM
@MathieuGuindon in my case, my project has to be xcopy deployment because corp crap
 
realistically i cant even get the .net app to run without asking if i REALLY WANNA RUN IT
 
so installer that requires installing any FX patch is non-starter
 
despite being signed
 
9:45 PM
There you go.
 
so, my boss is having me stay with the script since it works
no need to go figure out all this crap for the app we arent going to use, you know?
 
Yeah, SCD is what I'll be looking at for my other project
 
It looks like you can do a self-contained one now.
 
that said, it was a GREAT learning experience
so tell me
 
because I don't want to deal with "oh .NET 3.5 FX is disabled bla bla"
 
9:46 PM
how does one Await Send-MailMessage -to $SuperEmails -Subject $subject -SmtpServer $SMTPServer -From "Barcode Labor Ticket Macro<Reports@VoltageMultipliers.com>" -body $body -Credential $creds
 
or "oh your machine is a ancient POS that needs to be put in a museum bla bla"
 
@KySoto First, it has to return a Task.
Or a Task<T>.
 
in powershell?
 
The thing you are calling.
 
Powershell has access to all of .net
 
9:47 PM
send-mailmessage returns nothing
 
I don't know how in PS off-hand. In C#, you'd mark your method async and the call await.
@KySoto It's void?
 
tbh you don't really need to care for async/await in a script
 
@MathieuGuindon using a byzantine syntax, sure.
 
=)
PowerShell is Byzantine all by itself :shrug:
 
9:49 PM
kind of wish they just did a proper C# script
instead of inventing yet another language that's sort of like C# but not exactly
 
yeah... it's called C# console app ;-)
 
LOL, but that's not script
 
cept when windows wants to be a twat and not let you run it in the background
without ASKING you
its not a freakin optional thing
 
yes, yes it is if you stuff it all in void main!
 
it must run
 
9:50 PM
Anyway, TTQW.
 
^ same
 
Have fun, guys.
 
@MathieuGuindon /facepalm
 
@KySoto SECURITY!!
 
so uhh
 
9:50 PM
drive fun, guys!
 
on the little thing i threw together, what would i bother seperate out to its own function?
 
> 53 minutes to home
#fun
 
@KySoto why not put the script up on CR?
 
i redacted a couple of things, but otherwise its complete
because i wanna keep the smidge of happyness i have for converting the powershell script to c#?
 
9:52 PM
anyway, </mug>
@KySoto =)
 
its my first REAL c# application that had a real purpose
and wasnt me trying to figure out something to do
 
10:16 PM
@Vogel612 just thinking, can't those be filtered out with a hook? don't know enough about GH...
 
Yeah they could, but that would preclude us from ever pushing tags manually
 
ah ok
@this Yes, you're conflating. Net Standard could have been named "Net Specification", and it's for libararies / nugets. If you target, say, netstandard2, your lib can be referenced from (high enough versions of) net fx, net core, mono... Ultimately one of those runtimes needs to be available for it to run though.
The self-contained thing is net core specifically, allows you to package up a private (net core) CLR which only your app will use.
On top of this is single-file, which basically zips up your app (with or without CLR iiuc) and adds a bootstrapper so you can just ship a single exe.
 
which is exactly waht I need for my project since I want a xcopy deployment
 
As for "why not just use net core for everything", now that core 3 is out, reasons not to do so for greenfield are evaporating
 
well that's the point of core 5, isn't it?
to get rid of all those silly FX / Standard / Core
 
10:31 PM
yeah, net fx is going nowhere now. net standard they are thinking of dropping, and probably will with 5.
it was really a bridge for fx -> core, and very useful for that.
 
with my project, I'm targeting 3.5 but even so that is problematic
becuase I've already run into some corps who has 3.5 disabled
 
if you don't need to support vista or 8.0, core 3 self-contained could be the way to go
 
hmm.
do I care?
tries to care
fails
 
about the corps?
 
no about the vista & 8.0 support. :)
 
10:33 PM
ah lol
 
corps, I'm kind of obliged to care. :(
 
< 0.5%
:-)
 
Vista is EOL so no worries.
8.... checks
 
is it WPF?
I think 8.0 is EOL
 
Waste of time meeting...
 
10:34 PM
sorta. Just one little progress form
 
8.1 is still alive, but supported for core 3
ah ok should be fine. wpf in general seems very stable, but its new, so... I wouldn't push that envelope too far just yet
and they're still working on WinForms (no designer support yet)
 
yeah, very very very basic
the bulk of work is in the well, code.
 
I'd say its viable then
 
the project has some nuget packages, though... IDK if I can migrate them
esp the command line parser nuget
 
check the dependencies - if they have net standard targets you should be fine
 
10:37 PM
hmm, can't find the windows 8's EOL date.
it does list 8.1 which isn't helpful
found it. 2016, apparently
 
care level descend into negative numbers
 
ah yep same
 
yeah that's where I found it. The original query in the Microsoft LifeCycle didn't list Windows 8 for whatever reasons. #GoMicrosoft
so yeah I'm fine with not supporting EOL'd OS. I don't think I really want to support them anyway
 
You'd be on the cutting (not bleeding) edge, you OK with that?
 
10:41 PM
 
@IvenBach Motivation enough to learn how to properly set up a DB.
 
@mansellan TBH, I'd have preferred to use 4.x stuff but because corp install, I couldn't assume that everyone has a certain version of FX patched.
 
most popular nugets should have net standard by now
 
Core let me sidestep that whole business of patching.
So yeah, that's an improvement in my book.
 
10:42 PM
If it makes you feel any better, they have an insane number of tests iiuc :-)
 
I don't want a dweeb calling me "halp, your thing don't work on my computer!" "oh, you don't have FX 3.5 enabled"
At one point I was tempted to just rewrite it in C++ so I would be dependency-free but I couldn't justify the effort required.
I know I'd probably crash OS if I was trusted to write C++ port. :)
 
lol
just an fyi, with single-file (if you go that route) you have to list target arch (RIDs) - I suspect that's just be win32 and win64 for you (guessing you don't need mac, linux...)
 
yeah, that's fine. I can ship 32 & 64 and pick one as apropos.
 
it needs to know so it can package the right bootstrapper
 
i do hope, however that single file won't bloat it into 200 MB just because of all .NET dependency
 
10:49 PM
shouldn't do, it has assembly trimming now so it can minify to just what you're using
they've got it down to a few MB for WebAssembly i think
 
Good.
even though internet is much faster than back in 90s, it's still un-fun to ship 20 MB utility thing
 
lol yep
trimming is opt-in in the csproj
ttgtb
 
11:14 PM
@this Am I #DoingItWrong by making the ID bigint NotNull for every table and creating a relation on them?
 
not strictly. It makes it for a convenient convention but you really should take care to enforce uniqueness on natural keys.
because while surrograte keys makes it convenient for writing SQL joins, it won't prevent you from adding 2 John Smiths to your customer table when there should be only one. So you will want unique constraint on the customer's name (as an example).
Be aware further that it also means you're taking a bit more space for tables that might otherwise be fine with just NK as a PK.
 
NK = ??
Normal Key?
 
Natural Key
suppose you have an employee table. The table contains EmployeeCode, FirstName, LastName, DateOfBirth, SocialSecurityNumber, DateOfHire, DateOfTermination.
If the business says that EmployeeCode is always unique for all employees, then that is a good natural key
because you don't have to generate an ID; the business creates it as part of its rule when hiring a new employee
FirstName, LastName is not a good key because you could have two John Smith who are born on different days and aren't the same. Ditto for DOB; two can share same date of birth.
An alternate key could be FirstName, LastName, DateOfBirth, SocialSecurityNumber but that's quite a mouthful to handle if you have to write it in all your SQL joins.
But it would make total sense to create an UNIQUE constraint over FirstName, LastName, DateOfBirth, SocialSecurityNumber and another over EmployeeCode, and have an EmployeeId (surrogate key that's auto-generated)
 
You lost me on the last bit.
Why have 2 constraints?
 
they enforce different things --- one enforces that you won't have duplicate records of a John Smith born on 1/1/1950 with 123-45-6789.
Such duplicate employee record would be nonsensical - surely you can't have 2 identical John Smiths!
 
11:28 PM
What does it matter if there are?
 
what does that mean?!?
Two John Smiths working at your company with same SSN and DOB?
but different employee code?
are you paying him double the wage?
is he working at same time in two departments?
 
Oh :derp: including SSN.
 
Surely that's a HR and payroll nightmare!
Right.
 
I was just thinking 2 persons with same name and birthdate.
 
You definitely don't want two identical John Smith
ah, gotcha. yes.
I'm talking about identical duplicate, not just very similar
 
11:29 PM
Is thinking about constraints just a mindset change?
 
you need to think of constraints as expression of the real world model
 
I don't know how the real world's modeled.
 
e.g. if your business say there can't be two John Smiths, well, golly, your database better reflect that fact
it's basically translating the actual policy and process in your business into database's rules
different example. Does your company hire illegal immigrants? No? Then, boy, all employees better have a SSN.
Therefore, SSN must be NOT NULL
This is oversimplifying because of green cards and alien residents, though.
 
Feels like a mindset bridge I haven't crossed yet.
 
So you need to think about the policies and protocols your business follows through
and make sure your database reflect those.
If you'd rather have a book, I would wholeheartedly recommend this book.....
I have this book myself (probably an older edition but still good)
 
11:34 PM
Confident you've already suggested that book.
 
Anyway, the key point is that your database must be an expression of the real world.... your business' processes
 
Just a shlub trying to take info out of spreadsheets. Who knew it'd be so tough?
 
well, because as I said, excel is quite brain-damaging.
it's much easier and "intuitive" to set up a spreadsheet with column1, column2, column3 and 2017, 2018, 2019, etc.
but that is all wrong, of course because you have a big mess when you have to add 2020 and column4
When you understand the relational data modeling, your data model will not need to change just because it's now 2020 or because you suddenly need 4th of something
So you do need to unlearn everything you knew about spreadsheet design and not do it with a database.
 
mkay.
 
11:51 PM
FWIW, if you'd rather see various examples, this might be of some help:
I make no guarantee whether they are good or not.
 
This is a task that will take a lot longer than I want to adequately understand.
 

« first day (1936 days earlier)      last day (1244 days later) »