Blogs

Bert Scalzo
Follow /21 May 2018 at 10:54pm / SQL Server Blog

What Happened to My Database?

Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common scenarios where some little detail slips through the proverbial crack and that often results in some kind...
109 0 /
Bert Scalzo
Follow /21 May 2018 at 10:53pm / Oracle Blog

What Happened to My Database?

Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common scenarios where some little detail slips through the proverbial crack and that often results in some kind...
105 0 /
Bert Scalzo
Follow /6 May 2018 at 12:38am / SQL Server Blog

TEMP is A Four Letter Word

It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taught record oriented or “record at a time...
125 0 /
Bert Scalzo
Follow /6 May 2018 at 12:37am / Oracle Blog

TEMP is A Four Letter Word

It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taught record oriented or “record at a time...
137 0 /
Bert Scalzo
Follow /24 Apr 2018 at 5:39pm / Oracle Blog

Managing Mountains of Data

When is data less valuable? How do you manage data as it becomes less valuable? In the good old days the answer to these questions was easy; it was simply based on what the company was willing to pay for relatively expensive onsite disk space. So while...
159 0 /
Bert Scalzo
Follow /13 Apr 2018 at 4:34pm / Oracle Blog

Running Oracle RAC in the Cloud

For purpose of discussion let's assume that you have Oracle 11g or 12c RAC cluster deployed on premise, and now you've been directed to see about moving it to the cloud. Of course there is always the Oracle cloud, but let's further assume...
206 1 /
Bert Scalzo
Follow /3 Apr 2018 at 11:11pm / Oracle Blog

Stretch Tables for Any Database

Microsoft has been extremely innovative the past few years – especially with regard to their SQL Server relational database both on premise and in the cloud. Although I am a Linux bigot and love the fact that Microsoft now offers SQL Server on Linux...
143 0 /
Bert Scalzo
Follow /3 Apr 2018 at 11:10pm / Oracle Blog

New Free Data Migration Tool

If you ever need for a simple, light lifting training and absolutely free data migration tool then you should try Data Puppy Lite . It offers the ability to migrate a schema at a time from a source to target database, and it supports the following databases...
222 0 /
Bert Scalzo
Follow /7 Jun 2017 at 7:56pm / Oracle Blog

Oracle In-Memory's Performance Screams

Since the dawn of database technology the Achilles heel or key limiting factor has been disk IO. In order to address this issue traditional spinning disk drive vendors historically offered 10K and even 15K RPM models. But more speed was needed. Then came...
648 0 /
Bert Scalzo
Follow /3 Mar 2017 at 2:49pm / Oracle Blog

Database Administrators and the Cloud

There’s no fighting progress. Decades ago database administrators managed and controlled everything – the OS, network, storage and database. Times have changed and DBAs have had to evolve (i.e. accept) well established principles of economics...
615 0 /