Heroku email server custom domain

I am hosting a webapp on heroku using the free plan. I have also bought a domain name from godaddy.com. My webapp and godaddy are linked through the cloudflare service in order to protect against DOS and so that I can provide a secure connection. I would like to be able to send emails from ____@mydomain.com but I don’t want to have to buy an expensive email plan on godaddy. Is there any way that I can host my own email server on heroku or something so that I can use my own domain to send emails?

How to import Azure blob file into Sql Server 2008

Is there a way to import Blob files into sql server 2008 other than using CLR ?

The file size is around 300MB so CLR isn’t efficient enough. Is there a possibility to use BULK INSERT or OPENROWSET in 2008 server?

Example in Sql Server 2017 we can do this

CREATE DATABASE SCOPED CREDENTIAL AzureDevBlobImportCred WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = 'st=2018-12-05T.....'  go  CREATE EXTERNAL DATA SOURCE AzureDevBlobImportExternalSrc WITH  (     TYPE = BLOB_STORAGE,     LOCATION = 'https://myStorageAccount.blob.core.windows.net', -- storage account URL     CREDENTIAL = AzureDevBlobImportCred -- External Data Source ); 

then we can use the external data source in bulk import

BULK INSERT #Mytemptable  FROM 'filename' WITH (DATA_SOURCE = 'AzureDevBlobImportExternalSrc' );  

So do we have something like above to import blob files in Sql Server 2008 ?

Why can not I get any row in a MySQL query from SQL Server?

The problem I have is that I can not visualize any row with the following query:

SELECT * FROM OPENQUERY ([LINK_MYSQL], 'SELECT * FROM mysql.vw_bd_date;') 

The query did not show any error except that it did not throw me any lines either. The consulted view found in MySQL is the following:

create vista vw_bd_date as SELECT `information_schema`.`TABLES`.`TABLE_SCHEMA` AS `base_de_datos`,MIN(`information_schema`.`TABLES`.`CREATE_TIME`) AS `FECHA_CREACION`  FROM `information_schema`.`TABLES`  WHERE ((`information_schema`.`TABLES`.`TABLE_SCHEMA` NOT IN ('information_schema','sys','mysql','performance_schema','test','test\_%'))  AND (`information_schema`.`TABLES`.`DATA_LENGTH` IS NOT NULL) AND (`information_schema`.`TABLES`.`INDEX_LENGTH` IS NOT NULL))  GROUP BY `information_schema`.`TABLES`.`TABLE_SCHEMA` 

This is the use in a much larger query where I do the join with other views to perform a database inventory, but also as commented, the fields in this particular view throw me NULL.

We tried to do all kinds of cast without success.

Any idea would be very helpful.

Thank you

How client movement prediction syncs with server position to avoid a clip around collision?

I have searched a lot on stackexchange and on google, yet I have not found a satisfactory answer to this seemingly simple question.

I am making an online multiplayer game where the players navigate a 2d map with basic square obstacles. In this case I am making collision checks both on the client and the server, where the server broadcast everyone’s position once per second as authority. However, when making a sharp turn around a square, often times either the client makes the turn while the server clips, or the client clips at the corner while the server makes the turn. That is understandable considering the possible discrepancy between the position on the server and the predictive position of the client. How do online multiplayer games usually work around this simple yet crucial problem?

I understand that it comes down to a pixel perfect sync which isn’t possible, but how do other games navigate around this issue, to give a flawless collision experience?

What I am considering of doing:

  1. Increase the position broadcasting rate from 1 time per second to however high needed to accurately sync the positions (20/sec). I believe this is the solution most games are doing. This however, will drastically increases the load on the server.
  2. In my case, the game’s main mechanism isn’t the navigation (think MMO), so I am leaning towards only checking collision on the client side, and have a simpler collision check on the server to ban walk-through-wall hackers. This would relax the server from heavy collision operations which is nice too.

Why almost all free HTTP Proxy server doesn’t change the User-Agent?

I’ve created a automated test suite for proxy server. From several websites in the internet like https://free-proxy-list.net/ I get many IPs of free proxy servers. I’ve also created a own Website with JSON API to get HTTP requests header.

All requests mostly differ in values like X-Forwarded-For, Via and X-Proxy-Id. But no proxy server changes the User-Agent. Its always the User-Agent from the origin, in my case python-requests/2.20.0.

After researching I know it’s technical no problem to do this with a proxy but anyone now why no free http proxy server do it?

DBCC CHECKDB – SQL Log Says Completed, SQL Server Agent Says Failed

I run a nightly Integrity Check (set up via Maintenance Plans) on all of my databases. For the last two nights, the final CHECKDBCC has failed… at least according to the SQL Server Agent Job.

Progress: 2019-01-25 03:51:01.15 Source: Check Database Integrity Executing query “USE [CellTestData_QC] “.: 50% complete End Progress
Error: 2019-01-25 05:14:43.79 Code: 0xC002F210 Source: Check Database Integrity Execute SQL Task Description: Executing the query “DBCC CHECKDB(N’CellTestData_QC’) WITH NO_INFOMSGS…” failed with the following error: “A severe error occurred on the current command. The results if any should be disca… The package execution fa… The step failed.

But if I check the SQL Server Logs, I get two conflicting messages.

First I get:

01/25/2019 05:00:39,spid105,Unknown,DBCC CHECKDB (CellTestData_QC) WITH no_infomsgs executed by sa terminated abnormally due to error state 6. Elapsed time: 1 hours 9 minutes 38 seconds.

But then I get:

01/25/2019 05:32:06,spid110,Unknown,CHECKDB for database ‘CellTestData_QC’ finished without errors on 2019-01-24 23:01:46.507 (local time). This is an informational message only; no user action is required.

So what exactly is going on here? Is my process completing? Or erroring out?

For a bit more context…

  • We restore [CellTestData_QC] every morning at 5AM (likely why I’m getting the SQL Server Log message of ‘terminated abnormally at 5AM).
  • Additionally, my backups of [CellTestData] and integrity checks of [CellTestData] and [CellTestData_QC] have been taking longer over the last few days – possibly because of issues with our SAN, which is why we’re getting the IntegrityCheck of [CellTestData_QC] beginning to run into the restore of [CellTestData_QC]
  • Integrity checks run every night at 11PM
  • DB backups (full and partial) run nightly
  • Transaction Log backups run every 15min
  • Currently working with 8 databases, that range in size from 4MB to 100GB, with a total of 330GB of databases
  • I’m running SQL Server Standard 2012 on a 64-bit Windows Server VM (using vSphere) with 64GB RAM, 1TB SAN storage, 175GB NAS storage, 4CPU, 4.9GHz

Any ideas what might be going on here?