Mysql Database Queries

query-pull

A client working with a web application which is no longer supported needed to extract critical information from their database. The function to do this was not available within the software. I was given access to the server. Surveyed the database structure, then ran the queries to pull the data needed. All data exported to .cvs files.

Management Studio Missing From Microsoft SQL Server 2008 R2

sql-management-studio

You may this issue if Visual Studio was installed on your machine prior to SQL Server 2008 R2.

To manually add Management Studio, visit: http://www.microsoft.com/en-us/download/details.aspx?id=7593

If the link has changed, search download Management Studio for Express 2008 r2 on your favorite search engine.

Once downloaded, run and follow the instructions for new installation. Under the features option you will see Management Studio as an option. Check the box and continue the installation.

WP E-Commerce for Netbilling

netbilling-wp-e-commerce

Netbilling, a payment gateway company recently abandoned the free shopping cart provided to their customers. As a result webmasters scrambled to find a new solution to continue accepting credit cards with no downtime. A client reached out to me for a new payment gateway for use with Netbilling.

Netbilling provided detailed documentation on what variables that needed to be passed.

I created a new payment gateway for Netbilling using WP E-Commerce (WordPress Plugin)

Goodbye Web Design, Hello Information Technology

goodbye-hello

After years of solely working on the internet, I’ve decided to switch gears. I have always been impressed by the server admins that I work with (remotely). Any problem that came up, a solution was never far away. I learned quite a bit about server maintenance from them, but I lacked the formal training. Shortly, before the Christmas holidays I decided to going back to school, to major in Information Technology. I am especially interested in the Security side of I.T.

First day of class is Jan. 7th.

Forum Management

Forum Management Forums also referred to as message boards are a great way to increase return traffic to your website is by setting up a forum where users can interact with others on a given topic. Your  message board could also serve as a way to provide support on your products, answer frequently asked questions, increase user interactivity, run promotional contests, announce new products and more. These new links will also give your site added depth with more rich content for search engines to associate with your product / website.

Forum software package software include (but not limited to): Vbulletin, IP Board, MyBB, Simple Machines, phpBB and XenoForo.

Message Board Management Services include:

  • Software Installation
  • Forum skin customization
  • Plugin installations
  • SEO package installation
  • Software updates
  • Spam control
  • New user / message moderation

Packages start at: $100 per month