Category Archives: SQL

The Impact of Row Size on Query Performance

Posted on July 3, 2023 by craig@craigsmullins.com

As part of my job as a database consultant, I regularly keep my eyes open for interesting topics in relevant blogs and forums. Recently, one interaction caught my eye, where somebody asked what kind of a performance impact could be … Continue reading →

Posted in database design, performance, SQL | Leave a comment

Bad Database Standards

Posted on May 10, 2022 by craig@craigsmullins.com

Several years ago I wrote a series of blog posts on bad database standards, that is, things you should avoid doing when creating the standards for your organization regarding database systems and development. These posts, although over a decade old … Continue reading →

Posted in DBA, DBMS, SQL, standards | Leave a comment

A Few Good SQL Book Recommendations

Posted on May 2, 2022 by craig@craigsmullins.com

Every professional programmer that accesses data in a relational/SQL database should have a good book (or four) on SQL… Actually, the same goes for DBAs because they also regularly use SQL in their day-to-day work. There are many SQL books … Continue reading →

Posted in books, performance, SQL | Leave a comment

Let’s Talk About Database Performance Analyzer

Posted on March 11, 2022 by craig@craigsmullins.com

Recently, I published a tweet thread on database performance and SolarWinds’ Database Performance Analyzer. Today’s blog post captures those tweets for posterity! Let’s talk about #DatabasePerformance and SolarWinds (Tweet #1) Applications that access relational databases are only as good as … Continue reading →

Posted in automation, DBA, optimization, performance, SQL | Tagged | 1 Comment

Heterogeneous Database Management with Navicat Premium 16

Posted on December 14, 2021 by craig@craigsmullins.com

Navicat Premium is a heterogeneous database development and management tool that makes it easy to quickly build, manage, and maintain your databases. With Navicat Premium you can simultaneously connect to heterogeneous database systems. Support is available for MySQL, MariaDB, Microsoft … Continue reading →

Posted in cloud, DBA, DBMS, Microsoft SQL Server, MySQL, SQL | Leave a comment

Use a Little SQL Magic to Clean Up Your Data

Posted on October 21, 2021 by craig@craigsmullins.com

Data integrity sometimes can be a vexing problem to overcome. Data gets brought into our systems in many different ways: through data entry clerks, online by customers, purchased data, ETL, and on and on. And there is no guarantee, many … Continue reading →

Posted in DBA, SQL | Leave a comment

What causes SQL Server to have performance issues or run slow?

Posted on June 29, 2020 by craig@craigsmullins.com

Today’s post is a guest article written by a friend of the blog, Kevin Kline, an expert on SQL and Microsoft SQL Server. Image Source: Pixabay SQL Server can suffer from all sorts of problems if it is not properly … Continue reading →

Posted in DBA, Microsoft SQL Server, optimization, performance, SQL | Leave a comment

A New and Improved Navicat Monitor

Posted on June 28, 2019 by craig@craigsmullins.com

DBAs are always looking for ways to better manage the performance of their database systems and the applications that access those databases. Indeed, monitoring and tuning are perhaps the most frequent tasks that DBAs perform. So, it makes sense that … Continue reading →

Posted in DBA, performance, SQL | Leave a comment

Navicat Enables DBAs to Adopt Modern Platforms and Practices

Posted on January 31, 2019 by craig@craigsmullins.com

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

Posted on December 11, 2018 by craig@craigsmullins.com

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