ms #sql server #transactsql docs

ms sql server transact sql docs

• CONTENTS https://msdn.microsoft.com/en-us/library/bb510741.aspx
• DDL https://msdn.microsoft.com/en-US/library/ff848799.aspx
• DML https://msdn.microsoft.com/en-US/library/ff848766.aspx
• EXECUTE https://msdn.microsoft.com/en-US/library/ms188332.aspx
• FUNCTIONS https://msdn.microsoft.com/en-US/library/ms174318.aspx
• JSON https://msdn.microsoft.com/en-US/library/dn921890.aspx

#webdev with ms #vscode on #mac and #pc

http://generatedcontent.org/post/139138022310/why-i-love-visual-studio-code-for-css-html

VS Code is based on the Monaco editor that is also part of the F12 dev tools found in MS Edge and IE. It was also part of Visual Studio Online that was part of Azure Websites. It does use Electron (which started life as part of Atom) for the frame of the app, which allows it to be hosted as a cross platform app.

PHP Authentication and Encryption the right way

PHP Authentication and Encryption the right way (hint dont use mcrypt)

• https://tonyarcieri.com/all-the-crypto-code-youve-ever-written-is-probably-broken

Paragonie

• https://paragonie.com/blog/2015/05/using-encryption-and-authentication-correctly#
• https://paragonie.com/blog/2015/05/if-you-re-typing-word-mcrypt-into-your-code-you-re-doing-it-wrong
• https://paragonie.com/blog/2015/08/you-wouldnt-base64-a-password-cryptography-decoded
• https://paragonie.com/blog/2015/11/choosing-right-cryptography-library-for-your-php-project-guide
• https://paragonie.com/blog/2016/02/how-safely-store-password-in-2016

PHP libraries

• https://download.libsodium.org/doc/
• https://github.com/paragonie/halite

sysadmin server monitoring with cacti,ganglia and xymona

sysadmin server monitoring with cacti,ganglia and xymona

• http://www.cacti.net
• http://ganglia.sourceforge.net
• http://xymon.sourceforge.net

MS #mobdev and #webdev IDEs for Windows, Linux and OSX

MS Linux, OSX and Windows IDEs for developing mobile and web apps:

https://myprodscussu1.app.vssubscriptions.visualstudio.com/Dashboard?wt.mc_id=T3E_VSCOM_LoginMyBenefits

Visual Studio for Windows

• https://www.visualstudio.com/post-download-vs

Visual Code for Linux and OSX

• https://code.visualstudio.com/start
• https://code.visualstudio.com/Docs/?dv=linux64
• https://marketplace.visualstudio.com/#VSCode

Raspberry Pi Windows 10 IOT Core OS

Raspberry Pi Windows 10 IOT Core OS

• http://ms-iot.github.io/content/en-US/win10/RPI.htm

php use dangers

php use dangers

example from https://github.com/cakephp/chronos

use Cake\Chronos\Date;
$today = new Date();
echo $today;

imagine line 2 was actually line 200 how am i supposed to remember that a Date is no longer a PHP Date

 

the apple ibooks itunes istore has some free #python books

the apple ibooks itunes istore has some free #python books

• https://itunes.apple.com/gb/book/python-3-tutorial/id952220899?mt=13
• https://itunes.apple.com/gb/book/essential-python/id1063668429?mt=11

ubuntu aptitude doesnt install #php php5-mcrypt correctly but its a known bug

ubuntu aptitude doesnt install php5-mcrypt correctly and breaks php cli and nginx php fpm but its a known bug

bug

• https://bugs.launchpad.net/ubuntu/+source/php-mcrypt/+bug/1243568

workaround

• https://davekz.com/mcrypt-php-fpm-ubuntu/

or

# cd cli/conf.d/
# ln -s ../../mods-available/mcrypt.ini 20-mcrypt.ini

# cd fpm/conf.d/
# ln -s ../../mods-available/mcrypt.ini 20-mcrypt.ini

#percona #mongo #opensource #nosql db

percona mongo opensource nosql db

• https://www.percona.com/software/mongo-database/percona-server-for-mongodb
• https://www.percona.com/downloads/percona-server-mongodb/LATEST/