No database can process all queries expediently, but we can strive to make sure our databases process SQL as efficiently as possible. That means applying SQL performance tuning and optimization to our...
Are you trying to figure out how to load data from Excel into your database? The problem: load data to Oracle Many business analysts rely heavily upon Microsoft Excel as one of their primary sources ...
In a prior blog, I examined data modeling and data modeling tools at a very high level. I answered basic questions such as what is data modeling, why should I care, and what capabilities should data m...
What is data modeling, why should I care, and what capabilities should data modeling tools offer? These are all important and timely questions that I’ll explore in this blog, each on their own. Finall...
Wondering how to copy Oracle data to Excel using Toad? The problem with exporting Oracle data to Excel Many business analysts rely heavily upon Microsoft Excel as one of their primary tools for manip...
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...
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 taug...
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 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 ...
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 ...
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 f...
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 eve...
