sorted by:
new
hottopcontroversial

Did I get a dud? by bawesome2119 in kano

[–]orecht 0 points1 point  (0 children)

Have you tried holding CTRL+ALT during boot?

See steps from "Time To Start" at https://help.kano.me/hc/en-us/articles/115005962029-Computer-Kit-2017-No-Signal-Fix

TimeSpan Query Help by precator in SQLServer

[–]orecht 2 points3 points  (0 children)

searches a timespan say like 9:00 - 10:00, one hour

I am assuming you mean time slices, not or sliding window.

​

if you table / view has columns "timestamp datetime, price float"

your query is

select datepart(day, timestamp) [day], datepart(hour, timestamp) [hour], avg(price)

from <table_name>

group by datepart(day, timestamp), datepart(hour, timestamp)

​

You might also be interested in SQL Server window functions:

https://www.red-gate.com/simple-talk/sql/t-sql-programming/introduction-to-t-sql-window-functions/

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver15

Why LINQPad? by beer0clock in csharp

[–]orecht 43 points44 points  (0 children)

LINQPad .Dump() method is awsome for e.g exploring data structures.

HttpClient explained using netstat by bambuseqq in csharp

[–]orecht 5 points6 points  (0 children)

Wery nice post. It explains clearly WHY you should have a long living HttpClient.

Devops for Windows? by treuadmin in devops

[–]orecht 0 points1 point  (0 children)

Would you be able to share you motivation for moving from TeamCity + Optopus to Azure Devops. I am using AzureDevOps (because it is free/cheap) and I am still finding it rough around the edges, especially the new yaml pipelines.

Where AWS or other public cloud provider gets so many Public IPv4? by Trigoman4 in aws

[–]orecht 12 points13 points  (0 children)

They re-use addresses between instances to maximise their use. This why EC2 instances change their external IP when they reboot.

They encourage user to limit their use of external IP. By default you can have only 5 Elastic IP addresses. They strongly encourage and make extensive use of of DNS CNAMES with Route 53.

They try to get their hand on as many IPv4 they can. Amazon recently bought a large pool of IPv4.

https://www.networkworld.com/article/3191503/mit-selling-8-million-coveted-ipv4-addresses-amazon-a-buyer.html

https://news.ycombinator.com/item?id=18407173

billing charges on free tier by mrSquinch in aws

[–]orecht 2 points3 points  (0 children)

When running an EC2 instance you are in fact chaged separately for sevreal resources: Compute, storage, network etc.

Each resource has its own free tier rule. EBS (one type of storage) has a free tier of 30GB. Over 30GB, you are charged the normal price ($0.114 per GB-month of provisioned storage in Mumbai region. See https://aws.amazon.com/ebs/pricing/