© 2021 Mullins Consulting, Inc. All Rights Reserved Privacy Policy Contact Us
SQL Performance, Part 4: Additional Considerations.
IDERA Community Blog, December 10, 2018.
Fourth and final part of my series of posts on SQL performance; Part 4 provides a quick overview of several additional aspects of SQL optimization that we have yet to discuss .
Managing Database Performance.
Database Trends and Applications, December 4, 2018.
This month in the DBA Corner we examine the task of managing the performance of database systems and applications, a significant job responsibility for DBAs.
SQL Performance, Part 3: Multiple Table Access Methods.
IDERA Community Blog, November 30, 2018.
Third of a four part series on SQL performance; Part 3 focuses on the access methods that are used when multiple tables are accessed by SQL (joins).
SQL Performance, Part 2: Query Analysis and Access Path Formulation.
IDERA Community Blog, November 19, 2018.
Second of a four part series on SQL performance; Part 2 focuses on query analysis and the ways that SQL gets turned into executable code.
SQL Performance, Part 1: Relational Optimization.
IDERA Community Blog, November 12, 2018.
First of a four part series on how SQL is turned into executable code. Part 1 covers optimization at a high level and the things that impact it (CPU, I/O, statistics, etc.)
The Impact of the Connected Economy on Database Administration.
Database Trends and Applications, November 1, 2018.
More and more devices are being connected to the Internet and they are generating more and more data. This enormous growth in data creation is bringing about many important changes to IT and data management, which are discussed in this month’s edition of the DBA Corner.
The Importance of Data Lineage.
IDERA Community Blog, October 31, 2018.
How many times have you been querying some data, or looking at a report, and asked yourself something like “Should I believe this data? I wonder where this data came from?” Well, what you are asking about is the lineage of the data.
Data Modeling Still Important in a Big Data, Analytics World.
IDERA Community Blog, October 22, 2018.
Somehow an erroneous assumption has gained traction that data modeling is no longer required because of big data and NoSQL. This article exposes why this is a fallacy.
The Mainframe Does Big Data.
Database Trends and Applications, October 10, 2018.
Mainframes are not often mentioned in big data articles and advertising, but they should be. This month’s edition of the DBA Corner column explains why mainframes are perfect for big data and analytics.
IT Infrastructure Transparency Vital to the Modern Enterprise.
Planet Mainframe, September 6, 2018.
Today’s modern data centers are composed of many different systems that work both independently and in conjunction with each other to deliver business services. This article outlines the many challenges of managing modern age IT.
DevOps and the Database.
Database Trends and Applications, September 4, 2018.
With DevOps, more frequent and higher quality program code migrations can occur, but additional work needs to be done to incorporate database change management into the process. This month we examine database management and programming through the lens of DevOps in the DBA Corner.
Blazing Fast Access with Ancelus Algorithmic Database.
Database Trends and Applications, August 8, 2018.
This month the DBA Corner examines a the Ancelus database, a DBMS based on a new algorithmic approach that delivers high speed and easy administration.
We Are in Need of Data Ehtics Now.
Database Trends and Applications, July 2, 2018.
It seems that businesses these days have abdicated any responsibility for ethically managing the collection and usage of data. In this month’s DBA Corner column I discuss ways to correct these ethical shortcomings.
Who Owns the Data?
Database Trends and Applications, June 1, 2018.
With all of the data breaches and accusations of improper data usage in the news these days, the question of who owns data looms large. This month’s DBA Corner column examines the issue of data ownership.
Architecting the Modern Enterprise: 10 Key Technologies for a Strong Foundation.
Big Data Quarterly, May 11, 2018.
Technology is constantly changing, and IT architects need to keep up with modern developments to ensure that their companies are achieving the best possible return on their IT investment. Here’s a look at 10 key technologies for modern enterprise IT.
Relational Database Management System Optimization.
Database Trends and Applications, May 8, 2018.
In this month’s DBA Corner column we take a look at the heart of the RDBMS -
No Money Should be Harmed: IT Infrastructure Transparency & the Modern Enterprise.
Direction IT, April 19, 2018.
Today’s modern data cetners are composed of many different systems that work both independently and in conjunction with each other to deliver business services. This article outlines the many challenges of managing modern age IT.
How to Evaluate a DBA Job Offer.
TDAN, April 18, 2018.
As a DBA, it is inevitable that you’ll change jobs several times during your career. But how to make the decision to change jobs? This article provides some useful questions to ask along the way.
Data Lake Versus Data Warehouse: Understanding the Differences.
Database Trends and Applications, April 12, 2018.
Sometimes newer tech can confuse and co-
Embracing the Challenges of Gaining Value from Analytics.
Planet Mainframe, April 6, 2018.
Customer and end-
TIMESTAMP versus DATE/TIME.
datAvail Blog, March 28, 2018.
Consider a database design decision point where you need to store both date and time information on a single row in Db2. Is it better to use a single TIMESTAMP column or two columns, one DATE and the other TIME?
Db2 Nulls and the IS [NOT] DISTINCT FROM Clause.
datAvail Blog, March 15, 2018.
As a followup to the Null Troubles post, we look at the IS [NOT] DISTINCT FROM clause introduced without a lot of fanfare in Db2 V8 for z/OS.
Code for Performance from the Start.
Database Trends and Applications, March 7, 2018.
In this month’s DBA Corner column we explain how application developers can code their programs for performance from the very beginning… and why that is an important thing to do!
Null Troubles.
datAvail Blog, February 28, 2018.
Nulls cause a lot of confusion for Db2 developers and DBAs. This article defines what a null is and attempts to clarify some of the issues that arise when using nulls.
What is the Elastic SQL Approach?
NuoDB Blog, February 22, 2018.
This article takes a look at a new approach to elastic scalability for SQL databases.
What are the Database Scalability Methods?
NuoDB Blog, February 14, 2018.
This article discusses the predominant architectures for implementing database clustering to achieve scalability.
Db2 Best Practices.
datAvail Blog, February 13, 2018.
An open-
What do we mean by Database Scalability?
NuoDB Blog, February 9, 2018.
At a high level, both scalability and elasticity help to improve availability and performance when demand is changing, but what exactly are these two things? And how do scalability and elasticity help to improve availability and performance?
It’s All Big Data.
Database Trends and Applications, February 1, 2018.
The term “big data” has been bandied about for quite some time now, to the point where it seems to have lost meaning. This month’s DBA Corner column explains why this is not necessarily a bad thing and you can use it to your advantage.
Reinventing DevOps: Continuous delivery and the database.
IBM IT Infrastructure Blog, January 23, 2018.
For DevOps and continuous delivery methodologies to succeed, tighter database integration is required.
What is Production Data?
datAvail Blog, January 16, 2018.
I was asked to provide a definition of “production “data” so I figured I’d find a good definition with a web search. I didn’t… so I wrote one that sounds good to me. What do you think?
Tighten Database-
IBM Z, January 8, 2018.
Application and database changes must be tightly coupled and orchestrated in tandem for successful DevOps.
Don’t Neglect Database Performance.
TDAN, January 3, 2018.
One of the most time-
What is Blockchain? An Introduction to Blockchain for DBAs.
Database Trends and Applications, January 2, 2018.
This month’s DBA Corner column explains the importance of blockchain including what it is, how it works, and why it can be transformational.
Some New Year’s Resolutions for DBAs.
datAvail Blog, January 2, 2018.
At the beginning over every year many of us take the time to make resolutions for the upcoming year. Here are some thoughts on the New Year’s resolutions you might be wise to make as a DBA in 2018.