ASP Is Fun

ASP Is Fun

ASP Classic Code and Contracting

  • Home
  • ASP Course
  • Functions / Commands
  • Sample ASP Code
  • ASP Books
  • ASP Contract Programming
  • Blog

SQL Commands

MySQL Settings

MySQL Tuning – increasing max_connections to allow more simultaneous users

November 14, 2019 Lisa Shea 1

As your website gets more traffic, you’ll find that you run into problems where MySQL slows down. It has to wait for existing users to […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
WordPress Tips

WordPress Featured Image Permissions Problem on IIS

November 14, 2019 Lisa Shea 2

If you are using WordPress on a Microsoft Windows server, using IIS to manage your website, then you can easily run into permissions problems as […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

MySQL Workbench – Increasing Connection Time

November 13, 2019 Lisa Shea 0

If you do a lot of work with MySQL, you’re probably using MySQL Workbench to manage your databases and schemas. Once you start working with […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MySQL Schema Inspector Reporting Wrong Row Counts

November 10, 2019 Lisa Shea 0

When you use reports in MySQL, you expect them to be accurate. Let’s take, for example, the MySQL Schema Inspector. When you use the schema […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Comparing MySQL Data Across Schema

November 10, 2019 Lisa Shea 0

There are all sorts of reasons you might want to compare data between two tables in different schema. A common situation is that you’re moving […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MySQL Dump Not Exporting All Rows

November 10, 2019 Lisa Shea 2

This example is a lesson in double-checking what you think you’re seeing. I just invested a half hour in trying to solve a problem which […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Changing a MySQL Schema Name

November 10, 2019 Lisa Shea 0

You’ve got your MySQL database up and running. Everything is going smoothly. But then for some reason you need to change your MySQL schema name. […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MSSQL and Character Set Issues

July 2, 2018 Lisa Shea 0

One of the most troubling parts of ASP and SQL for new programmers can be how to handle apostrophes and other special characters. Here is […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Joining Tables in SQL

February 1, 2018 Lisa Shea 0

Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together! This isn’t even […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MySQL Optimizing Tips

December 1, 2017 Lisa Shea 0

If you are working with a MySQL database, it is important to optimize the database so it runs as quickly as possible. Here are some […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...

Posts pagination

« 1 2 3 »

Search

Recent Posts

  • Beeper SMS RCS Text Messaging App
  • Smart Messages SMS MMS Messaging App Review
  • SMS vs MMS vs RCS Texting
  • Textra SMS Messaging App Review
  • Google RCS SMS Texting App Review

Categories

  • ASP Course
  • Basics
  • Books
  • Contracting
  • Functions
  • Hosting
  • Musings
  • News
  • Sample Code
  • SQL Commands
  • Windows and IIS
  • WordPress

Ebooks

ASP intro

Newsletter

Subscribe to our mailing list

* indicates required

Advertising

Archives

All content on this site is written by ASP programmer Lisa Shea who is available for contract work. Content copyright (c) 2024. This site is part of the Minerva Webworks site suite.
Hosted By

Copyright © 2025 | WordPress Theme by MH Themes

%d