## 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-08|2021-08-08]] <== <button class="date_button_today">Today</button> ==> [[DevLog/log/2021-08-10|2021-08-10]] - [[tsql]] [Renaming SQL Server database objects and changing object owners][1] - Rename a database with `sp_renamedb` or `sp_rename` ## Example: rename database from Test1 to Test2 ```sql ALTER DATABASE [Test1] MODIFY NAME = [Test2] --or sp_renamedb 'Test1' , 'Test2 --or sp_rename 'Test1', 'Test2', 'DATABASE'; ``` - This could be any object that exists with SQL Server table, stored procedure, trigger, etc. ## Example: rename object Test1 to Test2. ```sql sp_rename 'dbo.Test1', 'Test2', 'OBJECT'; ``` - [[Python]] [[mito]] [[lux]] [3 Python Packages that make Data Science Simple][2] [1]: https://www.mssqltips.com/sqlservertip/1396/renaming-sql-server-database-objects-and-changing-object-owners/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MSSQLTips-LatestSqlServerTips+%28MSSQLTips+-+Latest+SQL+Server+Tips%29 [2]: https://medium.com/analytics-vidhya/3-python-packages-that-make-data-science-simple-40744de22592