What’s the Difference Between Purging, Deleting and Archiving in a Database?

If you’ve worked with databases for a while, you probably have heard of purging, archiving, and deleting data. Although some of the terms are used interchangeably, there are enormous differences between them. Archiving Database archiving is the process of moving historical data from production environments to an archive environment, freeing up IT storage space and […]

READ MORE

7 Things To Consider Before Moving To The Cloud

Your company has started the move to the cloud, but you’re not yet fully cloud-native. As your business grows and adapts, you’ll discover that there are several processes that will help make that transition easier. If you’re ready to become cloud-native, make sure you’re implementing these key pieces of your plan to ensure that you’ll […]

READ MORE
what-you-should-know-about-your-data

What You Don’t Know About Your Data Can Hurt You

The following blog is based on the podcast interview of Jeff Garbus, hosted by HC Biz during the Health IT Expo, which took place in New Orleans from May 30th, 2018 through June 1, 2018. Listen to the full interview here. In this day and age, data is everything. Trade secrets, legal pleadings, tax returns, […]

READ MORE

Supplier Data Quality: How It Affects Your Business

Even though automation is transforming the business industry, human interaction is still critical when the buyer-supplier relationship and the procurement department are involved. Imagine a multinational organization working with tens of thousands of suppliers, having to keep personal and business relationships with each, without proper database management in place. How can a company with handle […]

READ MORE
why-is-database-architecture-so-important

Why is Database Architecture So Important?

The following is an excerpt from Chapter 8 of the book Mining New Gold – Managing Your Business Data by Penny, Jeffrey and Gillian Garbus which can be purchased here. On previous blogs, we’ve discussed the importance of determining the order of priority of your data and establishing processes for storage, maintenance, and backup. But […]

READ MORE
prioritizing-environment-workload

Prioritizing Environment Workload

The following is an excerpt from Chapter 9 of the book Mining New Gold – Managing Your Business Data by Penny, Jeffrey and Gillian Garbus which can be purchased here. How often do you set up a maintenance schedule for your technical environment? What about management processes? The truth is that the first time you […]

READ MORE
how-much-data-can-i-afford-to-lose

How Much Data Can I Afford to Lose?

The following is an excerpt from Chapter 3 of the book Mining New Gold – Managing Your Business Data by Penny, Jeffrey and Gillian Garbus which can be purchased here. How did you store data 10 years ago? Is it comparable with how you store it today? If you’ve upgraded, list the reasons why: Are […]

READ MORE
database-performance-for-executives-2

Database Performance for Executives

The following is an excerpt from Chapter 18 of the book Mining New Gold – Managing Your Business Data by Penny, Jeffrey and Gillian Garbus which can be purchased here. One of the biggest nightmares a business owner can face is the possibility of getting sued. The issue becomes even worse when the damages claimed […]

READ MORE
cloud-environment-security-vs-on-premise-environment-security

Cloud Environment Security vs. On Premise Environment Security

The following is an excerpt from Chapter 7 of the book Mining New Gold – Managing Your Business Data by Penny, Jeffrey and Gillian Garbus which can be purchased here. A significant number of people seem to be under the impression that if their data is stored in a third-party cloud, the information is safe […]

READ MORE
Clustered vs Nonclustered Indexes

Don’t Drink the Kool-Aid | Clustered vs. Nonclustered Indexes

Editor’s Note:  “Don’t Drink the Kool-Aid” which was originally published at https://logicalread.com/dont-drink-kool-aid/#.Wud159PwZTZ. Soaring Eagle Advice Column By: Jeff Garbus Don’t believe everything you read on the web about clustered vs. nonclustered indexes I suspect almost every reader of this article has seen or heard the following, as it is posted “everywhere” on the web. Yet if the […]

READ MORE