Monthly Archives: August 2018

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 … Continue reading

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in Uncategorized | Leave a comment

Part Master – Error 4 Key Value Not Found

Part_Master Key Value not Found – CLR was disabled If you run into an error like this when you’ve just installed SQL Server and MAX is could be the CLR was not enabled. Verify CLR is enable by running the … Continue reading

Posted in Uncategorized | Leave a comment

Mathematical Symbols

Symbol What it is How it is read How it is used Sample expression + Addition sign … plus … Sum of a few values 3 + 5 = 8 Logical OR symbol … or … Logical disjunction ¬(A + … Continue reading

Posted in Uncategorized | Leave a comment

Set Compatibility Level on All DBs

Subject: Set Compatibility Level on All DBs /* Update All DBs Compatibility Level */ /* Reference 2017 = 140 Azure SQL Database = 130 2016 = 130 2014 = 120 2012 = 110 2008R2 = 100 2008 = 100 2005 … Continue reading

Posted in Uncategorized | Leave a comment

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>; … Continue reading

Posted in Uncategorized | Leave a comment

MAX PDF Documents have References in the Registry and in the ExaxctRMNET.ini

Subject: MAX PDF Documents have References in the Registry and in the ExaxctRMNET.ini Registry: [HKEY_CURRENT_USER\Software\ExactRM] ExactRMNet.ini is the windows folder

Posted in Uncategorized | Leave a comment

Move ODBC from one workstation to another

Subject: Move ODBC from one workstation to another Transfer DSN files from Computer A to Computer B: 1. On Computer A, open the Registry Editor by typing "regedit" in the Windows search box under the Start menu and selecting regedit.exe … Continue reading

Posted in Uncategorized | Leave a comment

SSRS and Chrome Links and Fixes

Subject: SSRS and Chrome Links and Fixes Chrome Chrome Extension for SSRS >> Solves Rendering Problems https://chrome.google.com/webstore/category/extensions?hl=en-US Solves CSS Issues https://chrome.google.com/webstore/detail/sql-reporting-viewer-fix/ealmmhekjbgnbfllfpbpplccpeoplidp?hl=en

Posted in How To Series | Tagged , , , , , , , | Leave a comment

Knowledge Sync Apps will not run

Subject: Knowledge Sync Apps will not run Likely it is these 2 files causing troubles. STOP THE KNOWLEDGESYNC WINDOWS SERVICE Move MSCOMCTL.OCX and COMDLG32.OCXC:\WINDOWS\syswow64 regsvr32 C:\WINDOWS\syswow64\ MSCOMCTL.OCX 6/6/2012 regsvr32 C:\WINDOWS\syswow64\ COMDLG32.OCX 5/7/1999 START THE KNOWLEDGSYNC WINDOWS SERVICE.

Posted in How To Series | Tagged , , , , , , , | Leave a comment