5/24/22

Finally, just minutes away the CTP2 of Microsoft SQL Server 2022 launched, get it now and try it

It is with my greatest satisfaction I proudly can introduce Microsoft SQL Server 2022, CTP2. Read more about the new version here, What's new in SQL Server 2022 - SQL Server | Microsoft Docs.

And download the Public Preview here, SQL Server 2022 Preview Trial (microsoft.com)

If you're not registered for msbuild and watching the news now, jump over here, https://mybuild.microsoft.com/en-US/home.

I'm busy watching all the announcements at the moment, more will come.


2/1/22

Really, is the backup running?

Yes, and now you launched all those backup statements, and you wonder when they are done...
This simple Query might help you a bit.

SELECT
 session_id,
 request_id,
 command,
 d.name as database_name,
 start_time,
 DATEDIFF(SECOND, start_time, GETDATE()) AS elapsed_time_in_seconds,
 percent_complete AS estimated_percent_complete,
 DATEADD(SECOND, ROUND(DATEDIFF(SECOND, start_time, GETDATE()) / percent_complete * 100.0, 0), start_time) AS estimated_finish_time
FROM sys.dm_exec_requests r INNER JOIN sys.databases d ON r.database_id = d.database_id WHERE command LIKE '%BACKUP%' OR command LIKE '%RESTORE%'