I would go for an hybrid of the two.

Do you know you can trig SSMA from command line? This way you can execute the SSMA migration as a part of...

I think "outlook.office365.com" cannot be used any more for SMTP because it has 2FA

If the last_access column is null then no reads or writes have occurred:

WITH cte AS (
SELECT database_id, dt, op 
FROM sys.dm_db_index_usage_stats
UNPIVOT (dt for op in (last_user_lookup, last_user_scan,...

Try this, if the last_access column is null then no reads or writes have occurred:

WITH cte AS (
SELECT database_id, dt, op 
FROM sys.dm_db_index_usage_stats
UNPIVOT (dt for op in...

Is the website http://dtucalculator.azurewebsites.net/ still a valid reference of Azure DTU calculation?

I mean the website was created in 2015 and we are now in 2021.

Also, I've created a query...

I have several servers on SQL Server 2019 but all the Compatibility Levels are on 110.

The sysadmin has been doing these "upgrades" since SQL Server 2012 I suppose.

And now we...

• This reply was modified 4 years, 6 months ago by  francesco.mantovani. Reason: editing a word

I'm in the same trouble on SQL Server 2019: FULL backup is taken daily but the query:

SELECT
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_finish_date,
CAST(msdb.dbo.backupset.backup_size AS NUMERIC(35,2))/1048576.0 AS backup_size_MB
FROM msdb.dbo.backupmediafamily
INNER JOIN msdb.dbo.backupset...

I'm facing different errors for both.

Overall I can say that the deployment process is not straightforward.

I will follow each error on your GitHub page. Thank you for your help

Hello,

I correctly registered the file but when I run the GET query I receive this error:

Msg 6522, Level 16, State 1, Line 2
A .NET Framework error occurred...

Yes, please, we need a contest. 
It runs fast and it give me back one table but I don't know much about this query. Thank you

What @Robert Sterbal-482516 is trying to say is that a...

Ahhhhhhh!!!
In fact there is no "IS" in T-SQL but only "IS NULL" or "IS NOT NULL"
It all makes sense now. 
Thank you guys.

Hello Matt and thank you for you interest in my question. 

This is what I have in Python:

Basically with "==" Python is comparing two variables but while...

This article explains it better than I do, read the reply by Peter Varshavsky: 

"[...] It turns out (in Python 2.7.9) that integers from -5 to 256...

Hello and thank you @SSCrazy Eights,
I would like to see if SQL has the same problem as Python.
In Python if you declare '@a' and '@b' as two...