Category Archives: availability

Q+A: Upgrading the Company DBMS

Posted on November 16, 2023 by craig@craigsmullins.com

I regularly receive questions from readers and every now and then I choose one to highlight here on the blog. Today, I want to share a Q+A from a reader/student asking for guidance on things a company should consider when … Continue reading →

Posted in architecture, availability, change management, maintenance, relational, scalability | Leave a comment

Optimizing Database Performance

Posted on August 29, 2023 by craig@craigsmullins.com

Last week I was proud to publish my latest database book, this time on the important topic of achieving and maintaining efficient performance for your databases and the applications that access them. Appropriately enough, this book is titled Optimizing Database … Continue reading →

Posted in analytics, availability, data availability, DBA, indexing, operational, optimization, performance | Tagged , , , | Leave a comment

Perhaps The Most Important Data Management Issue Today

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

Although there are many important issues that organizations are struggling with regarding data and data management these days, few would argue that securing and protecting their data is not among the most vital. With the increasing reliance on digital systems … Continue reading →

Posted in auditing, availability, compliance, data, data availability, data breach, data governance, DBA | Leave a comment

How Much Data Availability is Enough?

Posted on September 17, 2018 by craig@craigsmullins.com

I bet that some of you reading the title of this blog post scoffed at it. I mean, in this day age, isn’t round-the-clock availability for every application and user just a basic requirement? No, it shouldn’t be. Let’s discuss. … Continue reading →

Posted in availability, DBA, SLA | Leave a comment

Minimizing Database Outages with Replication

Posted on April 2, 2018 by craig@craigsmullins.com

A primary goal of most organizations is to minimize downtime and improve the availability of their IT systems and applications. According to a recent study on achieving 2018 database goals by Unisphere Research, “Enterprises seek to base most, if not … Continue reading →

Posted in availability, data integration, DBA | 2 Comments

DBA: Development Versus Production

Posted on October 15, 2013 by craig@craigsmullins.com

There are many different ways to look at database administration. It can be done by task, by discipline, by DBMS, by server, and so on. But one useful way to look at DBA is in terms of the type of … Continue reading →

Posted in availability, backup & recovery, change management, database design, DBA, SQL | 3 Comments

Defining Database Availability

Posted on June 24, 2013 by craig@craigsmullins.com

Before anyone can reasonably discuss the importance of data and database availability, it is necessary to first have a good definition of availability. After all, we should know what we are talking about. Simply stated, availability is the condition wherein … Continue reading →

Posted in availability, backup & recovery, DBA, performance | 8 Comments

Diminishing Downtime

Posted on July 16, 2012 by craig@craigsmullins.com

One of the on-going goals of database administration is to minimize downtime and improve availability. If the DBMS is down, data cannot be accessed. If the data is not available, applications cannot run. And if your applications cannot run, your … Continue reading →

Posted in availability, change management, data integrity, DBA | 2 Comments