## On This Day... ```dataview LIST FROM "DevLog/log" WHERE dateformat(file.day, "MM-dd") = dateformat(this.file.day, "MM-dd") ``` --- ## Notes Created Today ```dataview TABLE created, updated as modified, tags, type, status FROM "DevLog" AND !"DevLog/log" WHERE contains(dateformat(file.ctime, "YYYY-MM-dd"), dateformat(this.file.day, "YYYY-MM-dd")) ``` --- [[DevLog/log/2021-08-16|2021-08-16]] <== <button class="date_button_today">Today</button> ==> [[DevLog/log/2021-08-18|2021-08-18]] - [[Microsoft Orchestrator]] - [[tsql]] make a database single user and also cut off other sessions so you can drop it ```sql ALTER DATABASE <DB NANME HERE> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ``` - [SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.][1] - [Set a Database to Single-user Mode][2] - [SQL Server's Auto Update Statistics Async option][3] [1]: https://blog.sqlauthority.com/2007/12/07/sql-server-fix-error-3702-cannot-drop-database-because-it-is-currently-in-use/ [2]: https://docs.microsoft.com/en-us/sql/relational-databases/databases/set-a-database-to-single-user-mode?view=sql-server-ver15 [3]: https://www.mssqltips.com/sqlservertip/2904/sql-servers-auto-update-statistics-async-option/