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…
Category: 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
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.
Unlock Ektron User Account(s)
Should you ever lock out your own account and you have SQL access try this Should you ever need to unlock all accounts, not sure why, but you can try this if you have SQL access
MSSQL DateTime Conversions
Sometimes a basic function like MSSQL Format Date Function can not work as you do not have permission to create a function or you simply need something quick. To get day of week from DateTime column and order it by the proper day of week order. This is rather easy…