Category Archives: SQL

Navicat Enables DBAs to Adopt Modern Platforms and Practices

Database administration is a tried and true IT discipline with well-defined best practices and procedures for ensuring effective, efficient database systems and applications. Of course, as with every discipline, best practices must constantly be honed and improved. This can take … Continue reading

Posted in cloud, database design, DBA, mobile, SQL | Leave a comment

SQL Performance and Optimization

Just a quick post today to refer my readers to a series of blog posts that I recently made to the IDERA database community blog. This four-part blog series took a look into SQL performance and optimization from a generic … Continue reading

Posted in optimization, performance, SQL | 4 Comments

SQL Basics

It is hard to imagine a time when SQL was unknown and not the lingua franca it is today for accessing databases. That said, there are still folks out there who don’t know what SQL is… so for them, here … Continue reading

Posted in DBA, SQL | Leave a comment

DBA Corner

Just a quick blog post today to remind my readers that I write a regular, monthly column for Database Trends & Applications magazine called DBA Corner. The DBA Corner is geared toward news, issues, and technologies that will be of interest to … Continue reading

Posted in DBA, NoSQL, performance, SQL | Leave a comment

SQL Injection Still Causing Trouble

An on-going and important aspect of managing database security is designing your applications to avoid SQL injection attacks. SQL injection is a form of web hacking whereby SQL statements are specified in the fields of a web form to cause … Continue reading

Posted in data breach, Database security, DBA, SQL | Leave a comment

A High-Level Guide to SQL Tuning

SQL tuning is a complicated task and to cover it adequately requires a full-length book of its own – actually, perhaps several if you use multiple DBMS products. That said, there are some good high-level SQL tuning suggestions that should … Continue reading

Posted in performance, SQL | 1 Comment

SQL Coding and Tuning for Efficiency

Coding and tuning SQL is one of the most time consuming tasks for those involved in coding, managing and administering relational databases and applications. There can be literally thousands of individual SQL statements across hundreds of applications that access your … Continue reading

Posted in books, performance, SQL | 2 Comments

What the Null? Handling Missing Information in Database Systems

In relational database systems, a null represents missing or unknown information at the column level. A null is not the same as 0 (zero) or blank. Null means no entry has been made for the column and it implies that … Continue reading

Posted in NULL, SQL | Leave a comment

Why isn’t e-mail more easily queryable?

Today’s blog post is just a short rumination on finding stuff in my vast archive of email… Do you ever wonder why e-mail systems don’t use database management technology?  Don’t you store some of your e-mails for long periods of … Continue reading

Posted in e-mail, SQL | 1 Comment

A Good Start for Your SQL Library

Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But you can’t buy them all unless you are independently … Continue reading

Posted in books, DBA, performance, SQL | Leave a comment