I'd imagine the optics of this have changed with the recent focus on ocean surface temps. I would also bet the negative PR of pumping waste heat directly into cold climates would offset any savings.
The heat we directly dump into the environment, except where it affects the local ecosystem directly (e.g. warm rivers killing local wildlife, algae blooms) is a quite laughable portion of the global warming problem - greenhouse gases are multiple orders of magnitude more effective (at being part of the problem).
Oceans are insanely large (citation needed) heat sinks.
> Oceans are insanely large (citation needed) heat sinks.
If my math is right (hopefully), and assuming there's no cooling (hopefully not), it would take 790 billion years for Microsoft's datacenter to raise the temperature of the ocean by 1 degree.
I think it is disingenuous to pretend that I am making an argument on logistical, thermodynamic, oceanographic, etc. grounds. I claimed one thing - bad optics, bad public relations.
Sea surface temps are in the environmentalist spotlight at the moment. Between when Microsoft started their pilot program in 2018 and now, surface temps have changed dramatically. Some experts believe this change has made storms more energetic and less predictable.
Salt-water cooled power plants along with desalination plants have been getting pushback from environmentalists for years because of the negative effects of their heated effluent. This will only intensify.
For Microsoft, public relations have a documented cost. My claim is that their PR team would say that right now the cost of a large phase II deployment would outweigh the savings.
If it was that big a deal, they would channel the waste heat to useful purposes such as heating nearby homes for free. The marketing benefits are obvious.
That'd be great. The Volts podcast just had an episode about district heating. Data centers were among the list of readily available heat sources. Also reduces the data center's cooling costs. Win/win.
-----------------------------------------
John Carmack's .plan for Jan 31, 1997
-----------------------------------------
I went down to the ferrari dealership today with Ann and American with the intention of buying a new f355 as a "sensible" car (in contrast to my other twin turbo monstrosities).
There was an F40 sitting out front.
Umm. Sensible car. F40. Sensible car. F40. Hmmmm.
American played the evil conscience and Ann played the good conscience. For a while. Then Ann got infected by the Dark Side. :-) I bought the F40.
Ok, I now have too many ferraris. I have a plan to fix that. This hasn't gone through all the legal crap necessary yet, but it is my intention to give away my first ferrari as the grand prize of a Quake tournement.
Yes, I am serious.
DO NOT SEND ME ANY MAIL ABOUT THIS! When we have more to say about it, we will make a formal announcement. This would be a good time to start a heated debate in the newsgroups about what the fairest tourney rules would be, though.
The specs:
1987 328 GTS with turbocharged engine.
Feature in the january, 1994 issue of Turbo magazine.
Made 360 HP at the rear wheels on a chassis dyno.
New engine (I melted the first one...), new paint.
The interior could use a little work.
I plan to also include enough cash to cover tax and insurance.
I had Windows NT 4.0 with SQL Server 7.0 running for 6 years... never restarted (or patched)... This was our dev/qa server. Uptime from 1999 till October 2005.... then some fool shutdown the power to the whole dev cage....
Still remember the credentials too... sa and password Nimda
In the Heart of the Sea: The Tragedy of the Whaleship Essex by Nathaniel Philbrick
Elon Musk: Tesla, SpaceX, and the Quest for a Fantastic Future by Ashlee Vance
To the Last Man: A Novel of the First World War by Jeff Shaara
Dead Wake: The Last Crossing of the Lusitania by Erik Larson
The Wright Brothers by David McCullough
A Dance with Dragons (A Song of Ice and Fire) by George R. R. Martin
A Feast for Crows: A Song of Ice and Fire (Game of Thrones) by George R.R. Martin
The Confident Speaker: Beat Your Nerves and Communicate at Your Best in Any Situation by Harrison Monarth
House of Leaves by Mark Z. Danielewsk
To the Last Man: A Novel of the First World War by Jeff Shaara
Dead Wake: The Last Crossing of the Lusitania by Erik Larson
Becoming Steve Jobs: The Evolution of a Reckless Upstart into a Visionary Leader by Brent Schlender
George Washington's Secret Six: The Spy Ring That Saved the American Revolution by Brian Kilmeade
Think Like a Freak: The Authors of Freakonomics Offer to Retrain Your Brain by Steven D. Levitt
Elon Musk: Tesla, SpaceX, and the Quest for a Fantastic Future by Ashlee Vance
Finders Keepers: A Novel by Stephen King
The Guns of August: The Pulitzer Prize-Winning Classic About the Outbreak of World War I by Barbara W. Tuchman
The Wright Brothers by David McCullough
Seveneves: A Novel by Neal Stephenson
The Devil in the White City: Murder, Magic, and Madness at the Fair That Changed America by Erik Larson
Hitler's Last Day: Minute by Minute by Emma Craigie
The Girl on the Train by Paula Hawkins
Robopocalypse: A Novel (Vintage Contemporaries) by Daniel H. Wilson
Robogenesis by Daniel H. Wilson
In the Heart of the Sea: The Tragedy of the Whaleship Essex by Nathaniel Philbrick
My 5 favorite ones from that list are
In the Heart of the Sea: The Tragedy of the Whaleship Essex by Nathaniel Philbrick
Elon Musk: Tesla, SpaceX, and the Quest for a Fantastic Future by Ashlee Vance
To the Last Man: A Novel of the First World War by Jeff Shaara
Dead Wake: The Last Crossing of the Lusitania by Erik Larson
The Wright Brothers by David McCullough
I liked it a lot, it is really good. I would definitely recommend it to anyone wanting to learn about WW I. Also highly recommended is Dan Carlin's 6 part podcast series Blueprint for Armageddon Here is the link to episode I http://www.dancarlin.com/product/hardcore-history-50-bluepri...
Updatable CTEs are great, for example if you want to set a column to 1 where the date is the latest day for each value in a different column, you would do something like this
;WITH cte AS(SELECT
ROW_NUMBER() OVER(PARTITION BY SomeVal
ORDER BY SomeDate DESC) AS row,
* FROM SomeTable)
UPDATE cte
SET id = CASE WHEN row = 1 THEN 1 ELSE 0 END
Here is the DDL and DML in case you want to play around with this
CREATE TABLE SomeTable(id int,SomeVal char(1),SomeDate date)
INSERT SomeTable
SELECT null,'A','20110101'
UNION ALL
SELECT null,'A','20100101'
UNION ALL
SELECT null,'A','20090101'
UNION ALL
SELECT null,'B','20110101'
UNION ALL
SELECT null,'B','20100101'
UNION ALL
SELECT null,'C','20110101'
UNION ALL
SELECT null,'C','20100101'
UNION ALL
SELECT null,'C','20090101'
No reason, I do use Row Value Constructor/Table Value Constructor, these were introduced in SQL Server 2008, while CTEs were introduced in SQL Server 2005, I think when I created this example initially SQL Server 2008 was just released so this would not have worked for a lot of people on 2005
You'll find INSERT SELECT UNION ALL interesting when you want to insert rows from multiple table sources. For example, when refactoring a two tables into a single table or loading data into a temporary table (BCP) before copying it into a target table.
SQL Server has a limitation of 1000 rows maximum allowed in a VALUES clause, so sometimes a SELECT ... UNION ALL is required instead (this limitation probably doesn't exist in Postgres, though).
One advantage of this syntax is that you can just run the select part, look at the data to make sure it is correct and then finally run the whole statement
