Posts

EF6 Cheatsheet

Image
When I was first learning EF I tried using model first however migrations and the setup to handle it was too buggy. I'm sure I could have gotten it in time but I've learned right way the importance of being a good dba.


Performance Considerations for EF 4, 5, and 6Entity Framework - Entity Framework 6: The Ninja EditionBest practices to improve Entity Framework performance | InfoWorldTips to improve Entity Framework PerformanceEntityFramework Performance and AutoDetectChangesMore coming soon

IIS Cheatsheet

Setting up a website in iis is pretty easy and its where I'm most comfortable doing my professionally work. However with newer frameworks I'm look outside of iis because of the non-window based servers. So this cheatsheet is even better because I'm sure it will be a long time before convince my peers to use linux.
Server Error: HTTP Error 500.19 - Internal Server ErrorASP.NET IIS Registration Tool (Aspnet_regiis.exe)How to Configure HTTP Access to SQL Server 2008 Analysis Services on IIS7Reverse Proxy with URL Rewrite v2 and Application Request RoutingSecurity & UsersWhat are all the user accounts for IIS/ASP.NET and how do they differ?Solutioniis 7 - IIS7 Permissions Overview - ApplicationPoolIdentity IIS with Node (side note)
Installing and Running node.js applications within IIS on Windows

More coming soon...

C++/C Cheatsheet

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 OverflowHOW TO: Return Errors and Warnings from a SQL Server Stored Procedure in ADO.NETRAISERROR (Transact-SQL)SQL server management studio local database connection error in windows 7Visual Studio Database Guide - HomeHow to: Use Source Control with SQL Server Management Studiomysql - Sending multiple data parameters with jQuery AJAXsql server - Inserting multiple rows in a single SQL query?LuaSQL: Database connectivity for the Lua programming language
More coming soon..

Certificate Providers & ISPs

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 orderlightbox for images, videos, YouTube, iframes, ajaxdeferred.always() | jQuery API Documentation.trigger() | jQuery API DocumentationjQuery advantages/differences in .trigger() vs .click() - Stack OverflowjQuery BlockUI PluginHow to detect pressing enter on keyboard using jquery? - Stack Overflowjquery - Last element in .each() set - Stack OverflowjQuery event.preventDefault() not working in Firefox (JSFiddle included)jquery - Checking to see if AJAX response is empty and other problemsjavascript - jQuery's $(form).submit() not firing for IE only (MVC3 app)javascript - How can I refresh a page with jQuery?
Plugins Awesome Bub…

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.ymlhttps://github.com/fassetar/jquery-maskmoney/blob/master/.travis.ymlhttps://docs.travis-ci.com/user/environment-variables/https://docs.travis-ci.com/user/encryption-keys/https://saucelabs.com/platformsMore coming soon...