Just remember that you might not be the only person taking backups.
eg Your systems team might be taking VSS backups which could be differential as well as full.
You...

Hi Deepak,

Thank you for your timely article.

I have no experience of Azure but we have been asked to look at the possibility of moving some of...


DECLARE @t decimal(10,2) = 3.25;
SELECT CONVERT(char(8), DATEADD(second, @t%1 * 60, DATEADD(minute, @t, 0)), 114);


Try specifying the date in ISO format:
AND SLD.docenimerosisdate >='20180202'

https://blogs.sap.com/2017/11/28/upgrade-to-and-installation-of-sql-server-guides-moved-to-sap-help-portal/

A few things about the VSS solution are not clear.
It does not look as though it will do a point in time recovery to a Test or Dev DB.

Please ignore this.
Using the config file here seemed to solve the problem.
https://support.microsoft.com/en-gb/help/3186435/fix-sql-server-2016-database-mail-does-not-work-on-a-computer-that-doe

I am not sure why it worked initially and then failed when the box...


WHERE orderDateTime
    BETWEEN DATEADD(hour, 10, DATEADD(day, DATEDIFF(day, 2, CURRENT_TIMESTAMP), 0))
    AND DATEADD(hour, 17, DATEADD(day, DATEDIFF(day, 1, CURRENT_TIMESTAMP), 0))


The SQL2008 evaluation edition still seems to be available:

https://www.microsoft.com/en-us/download/details.aspx?id=1279

You had better check the licensing implications.

If you do use this, I would be inclined...

I would be inclined to disable them for at least a month first.

USE YourDB
GO
REVOKE CONNECT FROM "UserToDisable"
GO


Using Service broker, with triggers, would solve the 'connection tolerant' problem. Service broker will work with SQL Express as long as it is connecting to a non-Express edition:
https://msdn.microsoft.com/en-us/library/ms345154.aspx#sseover_topic10

You could also look at using triggers with Service Broker.
Again, conflict resolution might take some work to be robust.

I think the Sync Framework would be the normal way to approach this.
You could look at using a third party data compare tool that can be scripted. It might...

You should really provide DDL to get a good answer.
1. I strongly suspect your dates are acutally datetimes and a poor effort has been made to do comparisons.
Casting...