Expert Blogs - Toad World

Expert Blogs


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 /
Nakul Vachhrajani
Follow /20 Mar 2017 at 3:30am / SQL Server Blog

#0403 – SQL Server – CAST/CONVERT to string – Pad zeroes or spaces to an integer

Padding zeroes to an integer is often required during data migrations and integrations. Here is the approach I use in such data conversions.
76 0 /
Pinal Dave
Follow /20 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – sp_readrequest – Long Running Process

Just another day while doing performance tuning engagement , Senior DBA of the organization and I both noticed that one of the SP sp_readrequest  is continuously listed as long running SP. Well, the good part was that it was not taking too much of the...
74 0 /
Follow /19 Mar 2017 at 2:58pm / Oracle Blog

Create Backup On Demand On the Cloud

In This Post i will show how to create backup for Dbaas :- Open the Oracle Database Cloud Service console. Click the database deployment for which you want to create a backup. Click the Administration tile. Click Backup Now and then confirm the action...
132 0 /
Pinal Dave
Follow /19 Mar 2017 at 1:30am / SQL Server Blog

How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #114

Question: How to Find How Many Rows Each Query Returned Along with Execution Plan? Answer: During my performance tuning consultancy engagement, this is one of the most asked questions. Everyone wants to know how many row any query returned and what...
85 0 /
Pinal Dave
Follow /18 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request

If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is very helpful and can help in pointing the exact issue...
85 0 /
Dan Hotka
Follow /17 Mar 2017 at 6:09pm / Oracle Blog

Toad Explain Plan More Advanced Options

Hi, I have used this option to show SQL bind variable content for a while, I want to show you how I avoid running SQL Trace with this Toad Explain Plan feature. Toad has also made it very easy to run SQL Trace right from Toad…but this might...
161 0 /
Sten Vesterli
Follow /17 Mar 2017 at 3:26pm / Oracle Blog

Migrating from Oracle to MySQL

By Sten Vesterli With the loss of the Oracle Standard Edition One license, and the free Oracle Express Edition database stuck at the old 11g Release 2 from 2014, many smaller projects are considering whether MySQL might be an alternative. If...
255 0 /
Dinesh Asanka
Follow /17 Mar 2017 at 9:01am / SQL Server Blog

Microsoft Brings New Capabilities to HDInsight and DocumentDB

Microsoft is headed to San Jose this week where they will be announcing new features for HDInsight and DocumentDB at Strata Hadoop + World. Additionally, the company is also announcing a new preview for SQL Server as well. DocumentDB is Microsoft’s fully...
75 0 /
Porus Homi Havewala
Follow /17 Mar 2017 at 3:36am / Postgres - Blog

A First Look at Amazon Aurora with PostgreSQL Compatibility - Benefits and Drawbacks - Part II

by Porus Homi Havewala In the first part of this article series, we looked at the history of Amazon AWS, and how Amazon first released its Relational Database Service (Amazon RDS) supporting disparate and popular relational databases such as MySQL...
301 0 /
Pinal Dave
Follow /17 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – Availability Group Missing or Deleted Automatically?

As a part of my passion, I try to help people in fixing simple issues and explain the behavior by looking at logs. Here is an email from my friend about Availability Group Missing or Deleted Automatically. Pinal, We need your services again to help...
69 0 /
Bruce Momjian
Follow /15 Mar 2017 at 4:24pm / Postgres - Blog

Going Deep on Stats

By Bruce Momjian Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log_statement_stats: SET client_min_messages = log; SET log_statement_stats...
342 0 /
James Serra
Follow /15 Mar 2017 at 3:00pm / SQL Server Blog

PolyBase use cases clarified

I previously talked about PolyBase and its enhancements (see  PASS Summit Announcements: PolyBase enhancements ).  There is some confusion on PolyBase use cases as they are different depending on whether you are using PolyBase with Azure SQL Data Warehouse...
87 0 /
Arun Sirpal
Follow /15 Mar 2017 at 12:01pm / SQL Server Blog

Corrupt Database – I need that data now!

My database is in the recovery pending state and I want to get in and extract the data out into a new database, I have NO BACKUPS available so some data (even if it is dodgy) is better than nothing. … Continue reading →
88 0 /
Pinal Dave
Follow /15 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – Maintenance Plan – Could not load type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100’ from Assembly

One of my client was unable to modify the maintenance plan using SSMS. When we did various tests, we found that existing maintenance plans could execute and work. We tried creating a new maintenance plan and found it to be working.  So, our issue is confined...
101 0 /
Deepak Vohra
Follow /14 Mar 2017 at 9:00pm / NoSQL Blog

A Next-generation Agile Database for the Cloud - AWS DynamoDB

Bry Deepak Vohra With the increasing scale of data stored by web scale applications, several NoSQL databases have become available. The NoSQL databases are different from the relational databases (such as Oracle database and MySQL) in their data...
43 0 /