Advanced Google Search Operators

Found this on a search engine site – handy – full article here: https://www.searchenginejournal.com/google-search-operators-commands/215331/ Advanced Google Search Operators Cache Using the cache operator, you can find out what the most recent cache of a specified webpage is. This is useful for identifying when a page was last crawled. Example use: cache:websitename.com Allintext This operator will…

Read More

SQL Date Conversion Formats

20180824-00:00:00:000 — SELECT CONVERT(VARCHAR,@date,112) + ‘-‘ + CONVERT(VARCHAR,@date,114) 20180824-203947843 — SELECT CONVERT(VARCHAR,@date,112) + ‘-‘ + REPLACE(CONVERT(VARCHAR,@date,114),’:’,”) 08/24/2018 101 SELECT CONVERT(VARCHAR,@date,101) 2018.08.24 102 SELECT CONVERT(VARCHAR,@date,102) 24/08/2018 103 SELECT CONVERT(VARCHAR,@date,103) 24.08.2018 104 SELECT CONVERT(VARCHAR,@date,104) 24-08-2018 105 SELECT CONVERT(VARCHAR,@date,105) 24 Aug 2018 106 SELECT CONVERT(VARCHAR,@date,106) Aug 24, 2018 107 SELECT CONVERT(VARCHAR,@date,107) 10:00:00 108 SELECT CONVERT(VARCHAR,@date,108) Aug 24 2018…

Read More

Server Rename SQL Instance Rename

Subject: Server Rename SQL Instance Rename –For Default Instance sp_dropserver <old_name>; GO sp_addserver <new_name>, local; GO –Restart the instance of SQL Server. –/*For a renamed computer that hosts a named instance of SQL Server, run the following procedures:*/ sp_dropserver <old_name\instancename>; GO sp_addserver <new_name\instancename>, local; GO –Restart the instance of SQL Server

Read More