The Official Status Thread
-
@Tsaukpaetra said in The Official Status Thread:
Status: Cortana, you're fucking useless!
These results proudly sponsored by Bing !
On an
unrelated story, I just tried Bing and Yes ! it can find itself
-
This post is deleted!
-
@fbmac said in The Official Status Thread:
Status: Testing something
Status: Preserving testing notifications for posterity.
-
GodDAMMIT, SSIS.
Apparently if you take a DECIMAL(9,4) value and insert it into a DECIMAL(9,2) column with a T-SQL statement on SQL Server (e.g. via SSMS or similar), the value will be mathematically rounded as it loses precision -- 7.213 becomes 7.21 and 7.219 becomes 7.22.
If you have SSIS do the same effective thing... insert a DT_NUMERIC(9,4) value into a DECIMAL(9,2) column... it truncates.
-
@izzion That's what you get for using crappy open source inconsistent product.
Oh, wait ...
-
@izzion said in The Official Status Thread:
GodDAMMIT, SSIS.
Apparently if you take a DECIMAL(9,4) value and insert it into a DECIMAL(9,2) column with a T-SQL statement on SQL Server (e.g. via SSMS or similar), the value will be mathematically rounded as it loses precision -- 7.213 becomes 7.21 and 7.219 becomes 7.22.
If you have SSIS do the same effective thing... insert a DT_NUMERIC(9,4) value into a DECIMAL(9,2) column... it truncates.
SSIS does a lot of "helpful" things. Which are without fail NOT HELPING.
See: WtfCorp thread.
-
@izzion
Oh, but this is a Bob Ross behavior (BUT WAIT, THERE'S MORE!)Another field brings back DECIMAL(8,3) data to a DT_NUMERIC(8,3) SSIS field and then inserts to an INT column... and SSIS is rounding even (39.5 -> 40) while SQL rounds the way you learn in grade school (39.5 -> 39)
FUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU
-
@izzion said in The Official Status Thread:
@izzion
Oh, but this is a Bob Ross behavior (BUT WAIT, THERE'S MORE!)Another field brings back DECIMAL(8,3) data to a DT_NUMERIC(8,3) SSIS field and then inserts to an INT column... and SSIS is rounding even (39.5 -> 40) while SQL rounds the way you learn in grade school (39.5 -> 39)
FUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU
Uh. The way I learned in grade school rounded .5 and higher up.
That said, SQL is behaving as you expect programming tools to behave. SSIS was ostensibly designed for businesslizards, who by nature round instead of truncating.
Also, I think you can change the behavior in SSIS.
-
@Weng
Yeah, I obviously didn't identify which task is doing what thing correctly. Meh. Either way. >99% of the "different" rows between the two methods I'm comparing are different due to rounding errors in these two columns.
-
Btw, I've come to the conclusion that SSIS is hot garbage.
-
Status: I have discovered a problem with trying to use caffeine pills to help me wake up. By the time I'm awake, I can't recall whether I took one of the caffeine pills, or simply dreamed/imagined that I did.
-
@fbmac said in The Official Status Thread:
"service bus"
board it with some trolls and see how far you can get
-
Status: Because Apple, I've discovered that the Microsoft default top-level domain name of
local
is no longer allowed, and now that I'm attempting to integrate non-microsoft things into the network, things are breaking...
-
@anotherusername
Welcome to old age! Your AARP card is in the mail, and the pill reminder boxes can be picked up down at the pharmacy!
-
@izzion Just be glad it doesn't use bankers' rounding.
-
@Tsaukpaetra I think Microsoft changed that default in later versions of Winserver. Obviously it can't rename your domains for ya, though
-
@Tsaukpaetra
Though if you search TechNet, there isn't any current documentation that recommends .local or .loc - the docs recommend using an actual domain that you have registered with a provider somewhere (e.g. mydomain.com)I don't know whether they retconned their documentation to remove that previous recommendation, or if it's just one of those things that everyone did and is assumed a recommended best practice despite Microsoft never actually recommending it.
-
@izzion said in The Official Status Thread:
@anotherusername
Welcome to old age! Your AARP card is in the mail, and the pill reminder boxes can be picked up down at the pharmacy!Hey now... it's not that I can't remember it. I can remember it just fine... I just can't tell whether I'm remembering actually taking it, or whether I'm remembering falling back asleep and dreaming that I took it!
-
@anotherusername said in The Official Status Thread:
I have discovered a problem with trying to use caffeine pills to help me wake up. By the time I'm awake, I can't recall whether I took one of the caffeine pills, or simply dreamed/imagined that I did.
There are products designed to deal with that exact issue.
@Magus said in The Official Status Thread:
Just be glad it doesn't use bankers' rounding.
Round-half-to-nearest-even is bankers' rounding.
-
@Weng said in The Official Status Thread:
@Tsaukpaetra I think Microsoft changed that default in later versions of Winserver. Obviously it can't rename your domains for ya, though
As far as Windows 2016 it still does it automatically if you're in "easy" mode.
@izzion said in The Official Status Thread:
I don't know whether they retconned their documentation to remove that previous recommendation, or if it's just one of those things that everyone did and is assumed a recommended best practice despite Microsoft never actually recommending it.
Referring to Wikipedia, the jury is out on that one.
-
@Tsaukpaetra said in The Official Status Thread:
As far as Windows 2016 it still does it automatically if you're in "easy" mode
There's an easy mode?
-
Status: Logged into the domain controller. Discovered that the Windows Malicious Software Removal Tool has been running at 100% CPU for the last 66 hours.
Can't kill it.
GG Microsoft.
Status2: Looking for a tool to kill system processes at will...
-
@Weng said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
As far as Windows 2016 it still does it automatically if you're in "easy" mode
There's an easy mode?
Yeah, it's a cute little wizard thing in the Small Business editions that does all the basic setup stuff for you.
You'll also get a bunch of free stuff like a site called Default-Site-Name (or something like that).
-
@Tsaukpaetra said in The Official Status Thread:
Looking for a tool to kill system processes at will...
sudo kill -9
Oh, on Windows ?
nevermind.
-
@Tsaukpaetra said in The Official Status Thread:
Status2: Looking for a tool to kill system processes at will...
-
@TimeBandit I am sure there is a thread for quotes out of context.
-
My Amiga 1200 boots in like 2 seconds. My PC that has a 3.5ghz processor, SSD, 32gb of ram ... boots in 10.
Something not right here.
-
@boomzilla said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status2: Looking for a tool to kill system processes at will...
Yeah, that's what I ended up doing.
Upon powering back up, Windows Updates promptly froze the startup process.
In other news, renaming the domain turned out to be frickin easy, since there's only one domain controller (at present), and I'm only renaming the forest and not doing anything fancy like the docs suggest might cause problems (ya think?).
It's too bad the docs are literally 22 pages of cruft.
No, Microsoft TechNet author, I don't need to know all the background shit that's happening, I just need to know that there are 10 steps:
rendom /list
-> Gets a list of your domain things.- Edit the resulting
Domainlist.xml
to have the changes you want. - (optional)
rendom /showforest
to confirm your changes visually rendom /upload
to tell the domain controllers you intend to rename the domain and how.rendom /prepare
to tell the controllers to prepare to actually rename the domain.rendom /execute
to get all the domain controllers to do the thing. Windows will reboot if successful (apparently).- ???
rendom /end
once you've confirmed the changes happened to all the controllers.rendom /clean
to tell all the controllers the old domain has officially fucked off.- Profit!
Really, those steps could have been the H1 header level, with collapsible details if needed.
-
@lucas1 said in The Official Status Thread:
My Amiga 1200 boots in like 2 seconds. My PC that has a 3.5ghz processor, SSD, 32gb of ram ... boots in 10.
Something not right here.
Well, if you managed to boot the Amigo OS on your PC, you'd find it boots before the monitor can finish the first scanline.
Wouldn't that be something? Upload an image of the OS as a UEFI module...
Sounds like a fun hackerspace project...
-
@Tsaukpaetra said in The Official Status Thread:
Well, if you managed to boot the Amigo OS on your PC, you'd find it boots before the monitor can finish the first scanline.
It takes quite a while in WinUAE. Also Icaros isn't really Amiga OS.
-
Status: Ragequitting this forum
-
-
@fbmac said in The Official Status Thread:
Status: Ragequitting this forum
Are you going to delete the rest of your posts before quitting?
-
-
-
@Tsaukpaetra said in The Official Status Thread:
No, Microsoft TechNet author, I don't need to know all the background shit that's happening, I just need to know that there are 10 steps:
rendom /list
-> Gets a list of your domain things.- Edit the resulting
Domainlist.xml
to have the changes you want. - (optional)
rendom /showforest
to confirm your changes visually rendom /upload
to tell the domain controllers you intend to rename the domain and how.rendom /prepare
to tell the controllers to prepare to actually rename the domain.rendom /execute
to get all the domain controllers to do the thing. Windows will reboot if successful (apparently).- ???
rendom /end
once you've confirmed the changes happened to all the controllers.rendom /clean
to tell all the controllers the old domain has officially fucked off.- Profit!
Fuck OSS crap and using the CLI to do everything. We're not in 1970 anymore !
Oh, wait...
-
Use this power shell command ....
No fuckers. I have IIS in front of me and I just want to know where to click yes or no in the settings.
I understand that if it is on a *nix like platform some sh / bash / ksh + vi(m) experience is expected. That is fine.
On windows we have a GUI and XML files to config the server ... I rather use those thanks.
-
@dkf said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
rendom
That seems like an arbitrery name…
rename domain, I presume.
-
@Tsaukpaetra said in The Official Status Thread:
Windows will reboot if successful (apparently).
Apparently it's important for all the clients to reboot too. Or something. Probably twice even. Because raisins.
Also, the new Forward Lookup Zones stuff wasn't created automagically for some reason, luckily I have only a few manual DNS entries at present...
-
@Polygeekery said in The Official Status Thread:
If he wanted Win95 on it, I would be scouring torrent sites right now.
Pretty sure I've still got some old MSDN CDs...
-
Status: amused at my realtor's innumeracy. I was close to accepting paying twice what I'm currently paying in rent to own given that one of my friends just bought and got good deal. I'm preapproved for $X (which is what said friend ended up paying), but realtor wants me to be open to $X + 50k. "Oh, it'll only be a few more dollars per month." Yeah, no. At 4% APR, 30 years, that's $477 per month per 100k, plus property taxes.
I'm less frustrated at her than I am at the market (as the local market has decided that you don't own comfortably unless you have two healthy incomes), but I get the feeling she's not going to be too pleased when I tell her that I'm not going to sell my car and eat PB&J's for the next 30 years just to buy a place.
-
-
@dkf said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
rendom
That seems like an arbitrery name…
I keep seeing
femdom
. Pretty sure I'm ignoring that thread too.
-
@Tsaukpaetra said in The Official Status Thread:
@boomzilla said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status2: Looking for a tool to kill system processes at will...
Yeah, that's what I ended up doing.
Upon powering back up, Windows Updates promptly froze the startup process.
In other news, renaming the domain turned out to be frickin easy, since there's only one domain controller (at present), and I'm only renaming the forest and not doing anything fancy like the docs suggest might cause problems (ya think?).
It's too bad the docs are literally 22 pages of cruft.
No, Microsoft TechNet author, I don't need to know all the background shit that's happening, I just need to know that there are 10 steps:
rendom /list
-> Gets a list of your domain things.- Edit the resulting
Domainlist.xml
to have the changes you want. - (optional)
rendom /showforest
to confirm your changes visually rendom /upload
to tell the domain controllers you intend to rename the domain and how.rendom /prepare
to tell the controllers to prepare to actually rename the domain.rendom /execute
to get all the domain controllers to do the thing. Windows will reboot if successful (apparently).- ???
rendom /end
once you've confirmed the changes happened to all the controllers.rendom /clean
to tell all the controllers the old domain has officially fucked off.- Profit!
Really, those steps could have been the H1 header level, with collapsible details if needed.
Domain admins are notoriously concerned with the in depth details. It makes sense when you consider that most major domain operations are one way and LITERALLY affect the most basic functionality of every endpoint in the domain.
-
Status: New record, 44:00, and it doesn't even burn that bad.
That aching in my shins burns sooooo good, though :)
-
@Weng said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@boomzilla said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status2: Looking for a tool to kill system processes at will...
Yeah, that's what I ended up doing.
Upon powering back up, Windows Updates promptly froze the startup process.
In other news, renaming the domain turned out to be frickin easy, since there's only one domain controller (at present), and I'm only renaming the forest and not doing anything fancy like the docs suggest might cause problems (ya think?).
It's too bad the docs are literally 22 pages of cruft.
No, Microsoft TechNet author, I don't need to know all the background shit that's happening, I just need to know that there are 10 steps:
rendom /list
-> Gets a list of your domain things.- Edit the resulting
Domainlist.xml
to have the changes you want. - (optional)
rendom /showforest
to confirm your changes visually rendom /upload
to tell the domain controllers you intend to rename the domain and how.rendom /prepare
to tell the controllers to prepare to actually rename the domain.rendom /execute
to get all the domain controllers to do the thing. Windows will reboot if successful (apparently).- ???
rendom /end
once you've confirmed the changes happened to all the controllers.rendom /clean
to tell all the controllers the old domain has officially fucked off.- Profit!
Really, those steps could have been the H1 header level, with collapsible details if needed.
Domain admins are notoriously concerned with the in depth details. It makes sense when you consider that most major domain operations are one way and LITERALLY affect the most basic functionality of every endpoint in the domain.
Yeah.
Probably the one thing I'm upset about right now is that since the instructions only hinted once (instead of several times like most of the other instructions) that all client computers MUST be rebooted TWICE before finishing the rename operation, I ran the
/clean
command which essentially erased all the DNS entries for the old domain (as it should) and now none of the computers that happened to not get policy updates before the change are able to connect to the domain controller (which, is technically understandable) for their domain-name-changed update.So, I'm re-joining all the orphans with PSEXEC and powershell.
Wonderbar.
-
Status: Regularly scheduled performance statistics analytics job has noticed a warning: Unexpectedly low compute cycle count detected over the last four hours!
In other news, after five hours of work, I finally finished writing this MySQL stored procedure!
CREATE PROCEDURE `vote2017_AddVote` (IN `AttendeeID` int, IN `Last4Phone` smallint, IN `BaseCode` varchar(50), IN `CandidateID` int, OUT `Result` int) BEGIN DECLARE PhoneNo int default null; DECLARE BaseVoteSlotID int default null; SELECT PhoneNo = Right(REPLACE(Phone_number,' ',''),4) FROM `cm2017_attendees` where ID = AttendeeID; check_phone:BEGIN SET Result = -1; -- Attendee ID or phone is wrong IF PhoneNo != Last4Phone THEN LEAVE check_phone; END IF; -- Passed the first check, now lets find the base slot check_basecode:BEGIN SELECT BaseVoteSlotID = vs.ID FROM `vote2017_Bases` b JOIN `vote2017_BaseVoteSlots` vs on b.ID = vs.BaseID WHERE b.BaseCode like @BaseCode AND vs.ActiveStart < CURRENT_TIMESTAMP AND vs.ActiveEnd > CURRENT_TIMESTAMP; SET Result = -2; -- Base Code is wrong or no slot is available IF BaseVoteSlotID is null THEN LEAVE check_basecode; END IF; SET Result = -3; -- Something else is wrong -- Let's do the upsert! INSERT INTO `vote2017_Votes` (BaseVoteSlotID, CandidateID, AttendeeID, SubmittedDate) Values (BaseVoteSlotID, CandidateID, AttendeeID, CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE CandidateID = CandidateID, SubmittedDate = CURRENT_TIMESTAMP; SET Result = mysql_affected_rows(); END check_basecode; END check_phone; END;
I have no idea if it actually works, this was all typed without attempting to run whatsoever!
-
@Tsaukpaetra said in The Official Status Thread:
Status2: Looking for a tool to kill system processes at will.
Sounds like the sort of thing that will be removed by the next Windows Malicious Software Removal Tool
-
-
Status: For the first time since I joined this company, I've been granted local admin right, because I have to work on modification of a ClickOnce project.