Posts

Sql Cheatsheet

After my first job I realized the importance of learning a bit about it all. None should be in the dark when it comes to their website. I might not be a master of relational databases but give me a mongodb or reddis and even a firebase database any day. Still some projects are dependent on mysql and etc so I have enough info to help me move forward. Nothing I had more than a dba or team who locks me out. Throw exception from SQL Server function to stored procedure - Stack Overflow HOW TO: Return Errors and Warnings from a SQL Server Stored Procedure in ADO.NET RAISERROR (Transact-SQL) SQL server management studio local database connection error in windows 7 Visual Studio Database Guide - Home How to: Use Source Control with SQL Server Management Studio mysql - Sending multiple data parameters with jQuery AJAX sql server - Inserting multiple rows in a single SQL query? LuaSQL: Database connectivity for the Lua programming language DECLARE @local_variable (Transact-SQL) Pa

Certificate Providers & ISPs

This was just a question I always wondered and a topic I'v been fascinated by. I think a lot of information out there is obscured and this done so purposefully. Its such a tough market but once your in your in. Certificates Becoming a X.509 Certificate Authority How can my organization become a Root CA? As a ISP company Start an ISP WiMAX leased-line-buyers-guide Satellite_phone Who provides the Internet service to Internet Service Providers (ISPs)? Similar Businesses http://www.level3.com/en/ https://arstechnica.com/business/2014/04/one-big-reason-we-lack-internet-competition-starting-an-isp-is-really-hard/2/ http://www.giglinx.com/index.html http://www.dslreports.com/forum/r18672709-is-it-possible-to-be-your-own-ISP http://en.wikipedia.org/wiki/Tier_1_network http://drpeering.net/FAQ/Who-are-the-Tier-1-ISPs.php

Jquery Cheatsheet

Time to time I still use jquery and honestly don't have too many complaints about using jquery over more modern frameworks. Either way keep coming back to this page for reminders or small bugs in my code that I forget to add. I think the best approach for anyone is to create plugins for their needs and just keep expending around that. Javascript - Event order lightbox for images, videos, YouTube, iframes, ajax deferred.always() | jQuery API Documentation .trigger() | jQuery API Documentation jQuery advantages/differences in .trigger() vs .click() - Stack Overflow jQuery BlockUI Plugin How to detect pressing enter on keyboard using jquery? - Stack Overflow jquery - Last element in .each() set - Stack Overflow jQuery event.preventDefault() not working in Firefox (JSFiddle included) jquery - Checking to see if AJAX response is empty and other problems javascript - jQuery's $(form).submit() not firing for IE only (MVC3 app) javascript - How can I refresh a page with

Travis-Ci & Saucelabs Environment Variables

Firebase's example on how to auto deploy with Travis shows us a more secure way rather than how I did.  fassetar/jquery-maskmoney  if I can create a similar approach with this project I would feel better about the security. https://github.com/fassetar/site/blob/master/.travis.yml https://github.com/fassetar/jquery-maskmoney/blob/master/.travis.yml https://docs.travis-ci.com/user/environment-variables/ https://docs.travis-ci.com/user/encryption-keys/ https://saucelabs.com/platforms More coming soon...

Presteps to Making My Own CMS Part II

Before I try to create my own cms I looked recreating  some middlware for blogger. To be clear I didn't create my own database layer simple used Oauth and the blogger api's with a re-skinned UI/UX using Material Angular. I also created some tools for myself awhile I'm using the app and started creating a backup on github process like I talked about a few years back. http://stackoverflow.com/questions/31915099/how-do-i-get-an-instance-of-iappbuilder-elsewhere-in-my-asp-net-mvc-5-2-3-applic  http://stackoverflow.com/questions/32501238/how-exactly-iappbuilder-createperowincontextt-should-be-used/36044219#36044219  http://stackoverflow.com/questions/19669125/send-receive-email-with-google-oauth-2-and-asp-net-mvc https://www.asp.net/downloads/starter-kits/blog-engine

Powershell Cheatsheet

   One of the things that I have been getting use to is powershell, I'm not a server administrator.  Or at least if I'm going to be one I prefer linux. Most of my server are and I'm going to have a update here once I get my lab setup. For now this is how I manage my job and correct the systems that have gone wild. http://www.anotherchris.net/misc/starting-and-stopping-all-iis-sites-in-powershell/ http://stackoverflow.com/a/21674873/1265036 https://social.technet.microsoft.com/Forums/windows/en-US/be3afe83-4a7e-48a0-b2e7-95fd081a7571/login-to-website-using-powershell?forum=winserverpowershell http://stackoverflow.com/a/25035181/1265036 http://stackoverflow.com/questions/15528492/display-all-sites-and-bindings-in-powershell https://stackoverflow.com/questions/12789516/powershell-download-files-from-url-that-does-not-include-file-name-in-the-ur https://stackoverflow.com/questions/6204003/kill-a-process-by-looking-up-the-port-being-used-by-it-from-a-bat https://sta

Git Cheatsheet

I'm always handling the code wherever I go so maybe its time I shared my notes. I'm really surprised but I should with my experience how many developers don't know git. msysgit - git: 'credential-cache' is not a git command How do I update the password for Git? How do you attach a new pull request to an existing issue on github Squash commits! I'm always forgetting this and its really simple to do if you remember both commands. git rebase -i xxxxxxxxxxxxxxxx git push --force origin master "where xxxxxxxxxx is the SHA of the commit upto which I've to squash" .  Get username git config user.name Change Email git config user.email Caching Password on Windows. git config --global credential.helper wincred More coming soon...

Popular posts from this blog

UI-Bootstrap Collapsible Sticky Footer

Installing Windows on Acer chromebook 15 cb3-532

Aspetcore: NLog with Postgresql