select GEOGRAPHY::Point(lat1, long1, 4326).STDistance(GEOGRAPHY::Point(lat2, long2 , 4326))
Blog
sql – how to get decimal for an inetger
multiple ways of doing this.
select distinct inputvalue,
, round(CAST( inputvalueAS DOUBLE PRECISION ) / 1000.0, 3) — doesn’t secure 3 decimals
, round(inputvalue/1000.0,3) — by default 6 decimals
, cast(inputvalue/1000.0 as float)
, convert(numeric (15,3), inputvalue/1000.0)
sql server space used by database
run below command on your database to get space of the database
EXEC sp_spaceused
Cognos Visualization error
error:
The web request failed.
Details:
404 – Not Found
URL: http://cognosserver/ibmcognos/bi/common/palettes.json
Solution:
On your webserver pallettes.json needs to be copied from install location analytics\webcontent\bi\common to the analytics\webcontent\bi\common folder
Key words for search:
Source:
Tableau how to get more then 16 columns
I tried following approach and it worked.
rename .twb file to .xml
(if your tableau file is twbx then rename this file to .zip . get .twb file from this zip file. )
Open in notepad
search for following text:
change ’16’ to your desired value.
Now rename the .xml back to .twb. Open in tableau.
Though you could add more columns in tableau by changing xml, UI doesn’t look good. As tableau doesn’t support scroll bar on “Rows”
outlook disable skype add-in
When skype is added as an add-in then opening outlook calendar invite takes longer time to open. Disabling skype at outlook would resolve this.
At outlook go to file –> options –> Add-ins –> Manage – COM Add-ins GO –> At add-ins available uncheck skype related items.
Tableau tabcmd *** Uncaught exception RuntimeException: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.securi ty.provider.certpath.SunCertPathBuilderException: unable to find valid certifica tion path to requested target
Tableau tabcmd error
tabcmd login -s https://tableauserver.com -t site1 -u username –p password
*** Uncaught exception RuntimeException: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path building failed: sun.securi
ty.provider.certpath.SunCertPathBuilderException: unable to find valid certifica
tion path to requested target
When you get this error there are 2 ways of solving:
Solution1: Add tableau weburl to your trusted url’s in IE.
Solution2:
add –no-certcheck
tabcmd login -s https://tableauserver.com -t site1 -u username –p password –no-certcheck
and append –no-certcheck to export commands as well.
