Expert Blogs - Toad World

Expert Blogs

Blogs

Gokhan Atil
Follow /20 Jan 2017 at 11:35am / Oracle Blog

EMCLI: Add a Database Target with Specific DB System Name

On Oracle Community forum, I’ve seen a good question about using EMCLI to add targets. The forum user says that they decided to name the database targets with combining db_name and hostname. As you may know, when you add a database target, EM also...
8 0 /
Arun Sirpal
Follow /20 Jan 2017 at 8:18am / SQL Server Blog

MVPs and ACEs

I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program and they asked me (being the one that works with Microsoft technology) what Microsoft’s equivalent was, to which I answered …...
30 0 /
Clarisa Maman Orfali
Follow /20 Jan 2017 at 3:34am / Oracle Blog

Actualizando nuestro entorno de desarrollo local de APEX 5.0 a APEX 5.1

En este artículo quiero mostrarte cómo podemos actualizar nuestro entorno de desarrollo local de Apex 5.0 a Apex 5.1. En la esquina inferior derecha de la página de Inicio de APEX podemos ver la versión que tenemos corriendo...
28 0 /
Jen McCown
Follow /19 Jan 2017 at 4:20pm / SQL Server Blog

Webinar: Introducing Minion CheckDB!

Minion CheckDB will be available for download on February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on Wednesday, February 1 at 12:00 PM, and, another Minion CheckDB webinar on Friday, February 3 at 12:00 PM. And, we will be giving...
57 0 /
John Pocknell
Follow /19 Jan 2017 at 12:18pm / Toad for Oracle Blog

Introducing a new Toad for Oracle Web Based Training course

To round-out 2016 and the two Toad product releases we had in June (12.9) and September (12.10), I’d like to announce a new Web-Based Training course module which we launched yesterday which provides Toad users with a full update on both releases...
41 0 /
Porus Homi Havewala
Follow /19 Jan 2017 at 4:49am / Oracle Blog

What is Basic Flashback Data Archive?

This is an interesting tidbit. The Database Licensing Guide here makes the following statement: “ Basic Flashback Data Archive is in all editions. Optimization for Flashback Data Archive requires EE and the Advanced Compression option.”...
86 0 /
Pinal Dave
Follow /19 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – Understanding JSON Use is Case-Sensitive

The things I get to learn from my daughter is amazing. I think all of us need to constantly explore without any prejudice and set biases. Whenever I get a new toy for some occasion, I see there is at least a half hour of exploration to understand how...
59 0 /
Steven Feuerstein
Follow /18 Jan 2017 at 11:00pm / Oracle Blog

Players for PL/SQL Challenge Championship for 2016

The following players will be invited to participate in the PL/SQL Challenge Championship for 2016, currently scheduled to take place on 23 March at 14:00 UTC. The number in parentheses after their names are the number of championships in which they have...
81 0 /
James Serra
Follow /18 Jan 2017 at 4:00pm / SQL Server Blog

Microsoft Products vs Hadoop/OSS Products

Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads.  This means Microsoft will provide customers the best environment to run their big data/Hadoop as well as a place where Microsoft can...
110 0 /
Steven Feuerstein
Follow /18 Jan 2017 at 12:57pm / Oracle Blog

Emulating a finally clause in PL/SQL

PL/SQL does not support a finally clause, as many other languages do, including Java. Here's a description of the finally block from the Java SE doc: The finally block always executes when the try block exits. This ensures that the finally block is...
79 0 /
Henrik Loeser
Follow /18 Jan 2017 at 11:19am / IBM DB2 Blog

Context Path Routing of Apps and Services in Bluemix

31 0 /
Arun Sirpal
Follow /18 Jan 2017 at 3:00am / SQL Server Blog

SQL database built-in intelligence

I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in Azure. SQL database has built-in intelligence and with that intelligence it may recommend an elastic pool setup if it’s more …...
64 0 /
Pinal Dave
Follow /18 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key

Along with performance consulting, sometimes I also get requests from a few clients to look at the AlwaysOn availability group related problems. ENVIORNMENT: Three node AlwaysOn availability group with multi-subnet cluster with two nodes (SQL-A and...
55 0 /
Michael McLaughlin
Follow /18 Jan 2017 at 1:22am / Oracle Blog

Tips & Techniques - PL/SQL Object Table Function

This article covers how to write PL/SQL object table functions. PL/SQL object table functions provide you with a powerful technique to solve complex query problems. You can use object table functions to return result sets that you can’t write as...
186 0 /
Deepak Vohra
Follow /17 Jan 2017 at 8:26pm / Oracle Blog

DevOps for Docker - A Trend for 2017

Docker container has revolutionized the use of software with its modularity, platform independence, efficient use of resources, and fast installation time. Docker lends itself to the DevOps approach to software development. This article looks at the technology...
65 0 /
Paul Turley
Follow /17 Jan 2017 at 7:54pm / SQL Server Blog

Publish Power BI Reports to SSRS On-premise Preview Now Available

This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available”  This feature addition will allow Power BI reports to be published to a local SQL Server Reporting...
62 0 /
Thomas LaRock
Follow /17 Jan 2017 at 5:45pm / SQL Server Blog

6 Ways To Treat Your Data Right

Not everyone understands just how important data is until it is gone. Here are six ways that you can treat your data right. The post 6 Ways To Treat Your Data Right appeared first on Thomas LaRock . If you liked this post then consider subscribing to...
103 0 /
Henrik Loeser
Follow /17 Jan 2017 at 3:44pm / IBM DB2 Blog

Bluemix: Simplified Deployment of Complex Cloud Foundry Apps

20 0 /
Pinal Dave
Follow /17 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore

One of my clients reported that he is trying to apply security patch for SQL Server clustered instance and it was failing. Since this is SQL 2005 instance, there is no official support available from Microsoft at this point. So, they contacted me. I asked...
76 0 /
Clarisa Maman Orfali
Follow /16 Jan 2017 at 10:50pm / Oracle Blog

Nuevas mejoras en el uso del elemento de tipo "Explorador de Archivos..." en Oracle APEX 5.1

En la versión de Oracle APEX 5.0 en la sección de configuración del ítem teníamos estas opciones: Tipo de Almacenamiento: Table APEX_APPLICATION_TEMP_FILES: Almacena los archivos cargados en una ubicación...
74 0 /
Arun Sirpal
Follow /16 Jan 2017 at 6:05pm / SQL Server Blog

Looking at wait stats differently with SQL 2016

Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on  sys.dm_os_wait_stats and/or sys.dm_os_waiting_tasks. Did you know from SQL 2016 you have the ability to work with wait...
72 0 /
Natik Ameen
Follow /16 Jan 2017 at 3:45pm / Oracle Blog

Help Me Help You!

Hello everyone, I hope the holidays went well for you, best of wishes from my family to yours! It is a new year and we all have new year resolutions! After years of creating blogs for you all, I have decided to turn it up a notch! As many of you already...
111 0 /
Brendan Tierney
Follow /16 Jan 2017 at 3:34pm / Oracle Blog

Explicit Semantic Analysis setup using SQL and PL/SQL

In my previous blog post I introduced the new Explicit Semantic Analysis (ESA) algorithm and gave an example of how you can build an ESA model and use it. Check out this link for that blog post. In this blog post I will show you how you can manually create...
66 0 /
DBAFromTheCold
Follow /16 Jan 2017 at 9:04am / SQL Server Blog

Monday Coffee 2017-01-16

I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything down because I have a bad memory or if I have a bad memory because I write everything down. About a year ago I stopped using notepads and tried...
66 0 /
Nakul Vachhrajani
Follow /16 Jan 2017 at 3:30am / SQL Server Blog

#0398 – SQL Server – SSIS – Performing a DISTINCT using the SORT transformation

Within the data flow task of a SSIS package, it is generally considered a best practice to avoid using the SORT transformation because it is a blocking transformation. In case you do need to use the SORT transformation when working with non-relational...
71 0 /