ContentsSummaryWhat is performance tuning in SQL?Follow these simple steps to optimize your database and its functions:1. Clean up your SQL 2. Find the garbage collection sweet spot3. Expect success when modeling your database4. Ongoing maintenance5. Check your hardware6. ColdFusion Server Monitor: Monitor your logs and metrics7. Load test as often as you can Summary Learn about […]
SQL
SQL vs NoSQL (Top 4 Key Differences Explained)
When developing a new application, you’ll face one key decision: what kind of database will your company’s app use? There are two main flavors: SQL and NoSQL. You must choose wisely! I’ve seen enough botched database decisions as a ColdFusion consultant to know the long-term ramifications of choosing incorrectly between SQL or NoSQL. Your choice […]
Preventing SQL Injection Attacks
SQL Injection can damage your website’s data and spread to other sites in your organization. This article explains how it works and how you can prevent it. Exploited vulnerabilities: A SQL Injection attack relies on the someone sending an HTTP request (web site visitor) being able to add SQL commands to a URL or […]
SQL Reserved word or not, that is the question
Here is a problem that we had on a recent project that we were doing maintenance on. The code had some queries with a table called as “user”. The code works fine on the production server but gave an error on our development server. The fix? Put brackets around the table name in all the […]
SQL tricks – creative JOINs with legacy data
Have you ever needed to extract data from old tables and use it in a way the table designer never planned on? This seems to be an all-too-common experience. Recently, I learned that I could parse a number out of a string field, cast it as an integer, and actually use that result in a […]
