Monthly Archives: May 2016

SQL Server Database restore history

Usually you would like to know last time a database was restored. This is very handy script to show you the details. WITH LastRestores AS ( SELECT DatabaseName = [d].[name] , [d].[create_date] , [d].[compatibility_level] , [d].[collation_name] , r.*, RowNum = ROW_NUMBER() OVER (PARTITION BY d.Name ORDER BY r.[restore_date] DESC) FROM master.sys.databases d LEFT OUTER JOIN […]

Multi-factor Authentication (MFA) in Office 365

To setup the MFA for the first time follow the steps below. Your company should provide you with a login details to Office 365. The access is usually through the Office 365 portal or SharePoint Online. Once you have the link and credentials follow the steps below: 1.Go to the provided URL ( or 2. Type […]