HN user

minkeymaniac

434 karma
Posts50
Comments47
View on HN
www.kevinrose.com 3mo ago

Kevin Rose Back at Digg

minkeymaniac
2pts1
twitter.com 3mo ago

New Anthropic model wrecking cybersecurity stocks

minkeymaniac
5pts0
finance.yahoo.com 3mo ago

Chip Selloff Deepens After Google Touts Memory Breakthrough

minkeymaniac
3pts0
finance.yahoo.com 5mo ago

Microsoft Launches Maia 200 AI Chip for Faster Model Inference

minkeymaniac
2pts1
www.youtube.com 8mo ago

RAM prices are out of control

minkeymaniac
4pts0
denisgobo.blogspot.com 1y ago

LinkedIn is more and more green these days and not in a good way

minkeymaniac
5pts0
www.youtube.com 2y ago

AWS Summit New York City 2023 Expo

minkeymaniac
1pts0
www.sec.gov 5y ago

SEC suspends trading in 15 securities due to questionable social media activity

minkeymaniac
324pts212
www.xprize.org 5y ago

$100M Gigaton Scale Carbon Removal

minkeymaniac
6pts2
www.stampio.org 5y ago

January 30th in Stamps Roosevelt, Mahatma Gandhi, Orville Wright, Porsche

minkeymaniac
1pts0
www.stampio.org 5y ago

January 4th in Stamps: Braille, Schrödinger, Finnish Declaration of Independence

minkeymaniac
1pts0
denisgobo.blogspot.com 5y ago

2020 in Numbers

minkeymaniac
1pts0
www.stampio.org 5y ago

December 28th in Stamps: Iowa Statehood, F. W. Murnau, Lumière Brothers, X-Rays

minkeymaniac
2pts0
www.stampio.org 5y ago

December 18th in Stamps: Stradivari, Franz Ferdinand, Stalin, Brandt,Mohorovicic

minkeymaniac
1pts0
www.reuters.com 5y ago

Boxed out: China's exports pinched by global run on shipping containers

minkeymaniac
2pts1
www.stampio.org 5y ago

November 28th in Stamps: Von Steuben, Friedrich Engels, Enrico Fermi, Wilhelmina

minkeymaniac
1pts0
www.bloomberg.com 5y ago

What Big Companies Say About the Harvard Affirmative Action Case

minkeymaniac
2pts1
www.zdnet.com 5y ago

Working from home?Then you should pay more tax for the privilege, say economists

minkeymaniac
4pts3
www.stampio.org 5y ago

Oct 31st in stamps: Martin Luther posts his 95 Theses, Nevada,Vermeer, Houdini

minkeymaniac
1pts0
www.wired.com 5y ago

179 Arrested in Global Dark Web Takedown

minkeymaniac
6pts0
www.stampio.org 5y ago

September 20th in Stamps Chulalongkorn, Jacob Grimm, Simon Wiesenthal

minkeymaniac
1pts0
www.gatesnotes.com 5y ago

How do we move around in a zero-carbon world?

minkeymaniac
1pts0
www.stampio.org 6y ago

July 3rd in Stamps: Pitcairn Island, Franz Kafka, Karl Benz, Mehmed V

minkeymaniac
1pts0
sqlservercode.blogspot.com 6y ago

PostgreSQL Adds Fetch First with Ties.. Just Like Top N with Ties in SQL Server

minkeymaniac
82pts0
www.stampio.org 6y ago

April First in Stamps: Karl I, Bismarck, George II, Max Ernst

minkeymaniac
1pts0
www.reuters.com 6y ago

Disney Chairman Bob Iger to forgo salary amid virus crisis

minkeymaniac
3pts1
www.reuters.com 6y ago

Norway’s sovereign wealth fund said it had lost $124B this year

minkeymaniac
14pts7
www.reuters.com 6y ago

When will virus-hit markets heal? 12 charts to monitor

minkeymaniac
1pts0
www.reuters.com 6y ago

Microsoft says Teams has reached 32M users as remote work surges

minkeymaniac
1pts0
www.reuters.com 6y ago

U.S. crude prices fall to 17-year low as coronavirus spreads

minkeymaniac
4pts0
Nullable but not null 12 months ago

in sql server, you can simply add a not null check constraint with nocheck (see my comment with full code)

ALTER TABLE foo WITH NOCHECK ADD CONSTRAINT CheckNotnull CHECK (id IS NOT NULL)

any new values coming in cannot be null but the values already in the table with null are fine... then you can update them to not null over time

Nullable but not null 12 months ago

If you don't care for old data having null , you could add a check contraint with nocheck (this is sql server fwiw)

for example

create table foo(id int) insert foo values (1), (2), (3)

insert foo values (null)

select * from foo

id

1

2

3

NULL

ALTER TABLE foo with nocheck ADD CONSTRAINT CheckNotnull check (id IS NOT NULL)

insert foo values (null)

Msg 547, Level 16, State 0, Line 13 The INSERT statement conflicted with the CHECK constraint "CheckNotnull". The conflict occurred in database tempdb", table "dbo.foo", column 'id'. The statement has been terminated.

However be aware that if you update an existing value to NULL, you will still get the error

update foo set id = null where id = 2

Msg 547, Level 16, State 0, Line 20 The UPDATE statement conflicted with the CHECK constraint "CheckNotnull". The conflict occurred in database "tempdb", table "dbo.foo", column 'id'.

I actually used one of these in a VB app back in the day as a joke.. it was the robot I used.. if you typed in something wrong in a a text box.. it would shake his arms and call you an idiot

fun times

Not any different than taking yearly rent, multiplying by 30 and see if it is 4 times yearly salary. At least with a house you will have something after 30 years. In ten years.. your mortgage will be the same (property taxes won't be) Rent will for sure be higher after 10 years in the same place. But there are benefits to both renting and owning

I was born in Croatia but grew up in Amsterdam and have been living for 20+ years in the US. In Holland swearing involves a lot of diseases.. for example klerelijer (cholera sufferer) kankerlijer or krijg de kanker (cancer sufferer, get cancer) In Croatia it's more like fuck your mother (jebem ti mater) God fucks your mother (jebo ti Bog mater)

In Istria we have a nicer version of telling someone to fuck God (jebi Boga) Marry God (idi Boga ženit)... you would say that to family members when you don't want to be vulgar but the message is still more or less the same :-)

In that case read the book "Range: Why Generalists Triumph in a Specialized World" from that list first. You will notice that the people that came up with solutions came from a total different discipline, while the people in that field were stuck