u/Geno0wl

I am making a data bridge that will pull down a few hundred rows every hour from a rate limited server to our local sql server for reporting and other daily use stuff. I obviously have to have a good stable place to put this thing. Would putting it on the same server as the sql instance speed up everything because it doesn't have to traverse the network more, or would it potentially slow it down as it uses more CPU cycles?

Parking at field Museum

​

We have 9am arrival time for the Pokémon exhibit at field Museum tomorrow. They said we must show up at least 10 minutes early, but the east parking garage says it doesn't open up until 9. Both myself and a parent have issues walking long distance without breaks(have handicap placard). The other option listed is the north soldier field garage. It says I should reserve a spot by when I look it says tomorrow is sold out.

​

​

​

So I guess my questions are.

​

​

​

Does the eat garage really not open until 9?

​

​

​

Does the north soldier field garage really sell out like that? Or if we show up will there be open spots?

​

​

​

If neither of those options actually are available, where else near there is to park?

I have inhereted a DB that is straight SQL. Internally supports ~500 users(maybe 50 or so active at any time). It isn't the fastest thing, but it works.

Should I consider refactoring to use JSON/XML for speed?

On some level, I wish christianity was true. I mean do they think we wouldn't want to live forever in heaven? It mostly sounds great! Also, maybe those who deserve to "go to hell" will actually get their just desserts.

But that isn't how it works. And no amount of wishful thinking will change that.

I loved reading 8-bit Theater and later Saturday Morning Breakfast Cereal. And of course, Perry Bible Fellowship are all classics.

The Oatmeal

Penny Arcade

XKCD

Dinosaur Comics

Cyanide and Happiness

I mean I had a friend who loved Ctrl+Alt+Del for a bit.

Friday we took a quick trip to grab some food and the car gave an error message about a problem with the front passenger headlight and turn signal not working and needed service. It was too late to call, figured we would wait until today. Well today when I went to work the error message was gone in the car and the app.

Should I just shrug and move on?

Vendor decided for all newer versions of their software, which we need for compliance reasons, will no longer support MS SQL on-prem servers and everything is migrating to BigQuery.

So I need to update all my Custom Views, Stored Procs, reports, dashboards, etc to pull from the new source and handle PostgreSQL(which I have yet to use for a full project before)

Anybody have any tips or things to watch out for with BigQuery or PostgreSQL?