How to Execute a Stored Procedure in Laravel 5.6
I've been stumped on this and tried everything I can think of but I can't get Laravel to execute a working mysql query to reorder an ordering column when deleting a row.
Here's a sample simplified query, which works directly in mysql:
ASP.NET MVC Model Generator
In making the switch to ASP.NET MVC, I've moved away from using my old Data Access Layer that I've used for years and have opted to use Dapper as my ORM of choice in the quest for optimal performance. My DAL was actually pretty optimized for WinForms and WebForms (using straight SQL Queries and SQL parameters) but mapping it to models wasn't something I had in mind when I created it. I'm finding Dapper takes some getting used too but it is still pretty fast. The downside is that writing the code for Models to wire it up is proving to be a little tedious. To that effect, I wrote a little application that has helped me generate the models from a database dynamically. It's in it's infancy stages and something I cobbled together in less than 8 hours but it works. I'll add more features too as time goes on if there's enough interest or to satisfy my own needs. In the meantime, I'm open sourcing the project as it may help others and I'd love to see it become something grander if others are willing to contribute to it. There's also some useful bits of code that others may find useful to reference like dynamically reading fields from a database, pluralization/singularization of words, amongst others. You can find the repository on Github: https://github.com/gregvarghese/MVCModelGenerator
How to Reset Sitecore 7.1 & Sitecore 7.5 Forgotten/Lost Admin Password
In working on implementing a Sitecore site into an existing code base inherited from another vendor, I discovered that the admin password had been modified and the vendor would not share it. Not being able to login to the admin section of Sitecore was not ideal to say the least. After scouring the web, most articles contained instructions on how to reset the password, but almost all of them applied to Sitecore 6 and below. For Sitecore 7 and above, most articles were not applicable as they introduced the PasswordSalt field into the database which Sitecore uses to hash the password. If you've run into a similar situation, or you've forgotten or lost your admin account password, getting access back to everything is pretty simple. Load SQL Management (or your favorite SQL editor) and execute this query against your Core database: