Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
MySQL to MSSQL Data Conversion
Ever have to take a MySQL database and put it in Microsoft SQL? This is a MySQL dump script that will assist you in this conversion. Only problem that I’ve had with it is that you need to review the exported SQL and make sure your version of Microsoft SQL…
WordPress Change URL – MySQL – Update String Within Column
Recently I changed a domain alias for a WordPress site and needed to change the domain in all the pages/posts and this little script came in handy. Typical disclaimer stands, do a full backup before running this and verify you have everything setup correctly. If you have a network site…
MSSQL Format U.S. Phone Number
If you have to sanitize your field first it gets ugly but is still possible Reference: http://www.sqlservercurry.com/2010/11/format-phone-numbers-in-sql-server.html
Uninstall Application
First step is to get the application information Either option will display information similar to this To uninstall this application can be done with either query but essentially is like this
Ektron – User Access List
Similar to Ektron SQL – List All Users If you simply need a list of all of your CMS users whether they are admin or otherwise this script will help If you want to show a break down of the groups that each user is in this script will help
Ektron – Remove Content/Folder Permissions
Use EXTREME caution on this query. I recommend you do a backup of your database before you run this script as this will remove all permissions that someone has setup on Ektron.