Blogs - - Site Root - Toad World
Clarisa Maman Orfali
Follow /23 Mar 2017 at 5:56pm / MySQL

How to create an instance of a MySQL database in Amazon RDS

By Clarisa Maman Orfali In a previous article we learned how to create an account in Amazon Web Services (AWS). Besides knowing what Amazon RDS is, we learned how to configure an Oracle Database Instance in Amazon RDS. Here are the links for each...
79 0 /
Follow /23 Mar 2017 at 5:16pm / Oracle Blog

Testing in an Agile Development Environment: TDD vs. BDD

By Wissem El Khlifi with Tanja Bach, Certified Scrum Product Owner (Scrum Alliance), UX Consultant and Agile Evangelist Introduction In a traditional environment development and testing are separated into two phases: developers who build features...
52 0 /
Deiby Gomez
Follow /22 Mar 2017 at 3:32pm / Oracle Blog

Taking Care of Block Change Tracking While Duplicating Databases

By Deiby Gomez Before Oracle 12c, pluggable databases didn’t exist; whenever we wanted to clone a database we had use either RMAN Backup and Restore or RMAN Duplicate (Active or from backup location). There are several use cases to consider...
373 0 /
Arun Sirpal
Follow /22 Mar 2017 at 1:00pm / SQL Server Blog

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. Time … Continue reading →
60 0 /
Steven Feuerstein
Follow /21 Mar 2017 at 9:22pm / Oracle Blog

Tightening security in your PL/SQL code with 12c new features, part 1

Oracle Database 12c offers several enhancements to improve security in your PL/SQL program units. These features include: Code-based access control: fine-tune access to database objects inside program units by granting roles to program units , rather...
102 0 /
Pinal Dave
Follow /21 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the initial size itself was huge and when they tried to shrink...
72 0 /
Clarisa Maman Orfali
Follow /20 Mar 2017 at 9:45pm / MySQL

What is PhpMyAdmin and how to manage a MySQL database with this tool

By Clarisa Maman Orfali In this article we are going to give an overview of this application called PhpMyAdmin , which is one of the most popular applications for the management of MySQL databases. Throughout my professional career I have used this...
33 0 /
Dan Hotka
Follow /20 Mar 2017 at 8:03pm / Oracle Blog

Index Clustering Factor and Oracle

Hi, There is quite the scenario that the Oracle Cost-Based Optimizer (CBO) uses when deciding when to use indexes to process your SQL. I go into this in great detail in my SQL Performance Tuning course ( click here for details ). Clustering factor...
130 0 /
Henrik Loeser
Follow /20 Mar 2017 at 1:57pm / IBM DB2 Blog

IBM Bluemix in Germany, includes dashDB and Cloudant

32 0 /
Arun Sirpal
Follow /20 Mar 2017 at 6:30am / SQL Server Blog

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to … Continue reading...
70 0 /