Check DB

How to find the last good known checkDB date?

Starting with SQL Server 2016 SP2, we have DATABASEPROPERTYEX (‘dbname’ , ‘LastGoodCheckDbTime’ )

In SQL Server 2017, CU14 ( I tested it) , this is also working.

Like so:

SELECT DATABASEPROPERTYEX (‘db_workspace’ , ‘LastGoodCheckDbTime’ )

or

SELECT DATABASEPROPERTYEX (d.name , ‘LastGoodCheckDbTime’ )

FROM sys.databases as d

 

Value of  `1900-01-01 00:00:00.000` means – no check db was  run.
Please, see here more info
S

AT TIME Zone

New in sql server, starting with version 2016, it’s AT TIME ZONE, used to convert some date values to a specific zone.

 

Here is a sample :

declare @dt2_myDate as datetime2(0) = ‘20190216 08:10:12’ ;

select CONVERT(datetime2(0) , @dt2_myDate , 126)
AT TIME ZONE ‘Central European Standard Time’
AT TIME ZONE ‘UTC’ as newDateTime

 

newDateTime
16/02/2019 07:10:12 +00:00

 

S