Expert Blogs - Toad World

Expert Blogs


Arun Sirpal
Follow /25 Oct 2016 at 3:02am / SQL Server Blog

Azure App Service Companion for iOS

This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt like blogging about it. I saw an announcement recently and I was intrigued by it. All my excitement was over … Continue reading →
32 0 /
Pinal Dave
Follow /25 Oct 2016 at 2:30am / SQL Server Blog

SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time

Recently I was troubleshooting at a customer location something that looked trivial. When the customer approached me for a consulting requirement wherein they were saying their system was going unresponsive every day in the morning around a certain time...
29 0 /
Fernando Garcia
Follow /24 Oct 2016 at 11:33pm / NoSQL Blog

Análisis de datos con Python (I)

Cuando ingresamos al mundo del Big Data y el análisis de datos solemos comenzar a estudiar diversas tecnologías de infraestructura, almacenamiento y modelización. Así es como nos sumergimos en soluciones como Hadoop, HDFS,...
48 0 /
Follow /24 Oct 2016 at 12:43pm / Oracle Blog

Create new swap file to Linux

to add new swap file to Linux just follow the below steps , in my case i will add 32GB and i am not using LVM :- just create file by the below command :- touch /new.swap Write on the file :- dd if=/dev/zero of=/new.swap bs=1024 count=33554432 Format the...
48 0 /
Sten Vesterli
Follow /24 Oct 2016 at 12:02pm / Oracle Blog

ADF is a Strategic Choice

At OpenWorld, I gave my evergreen presentation "The Five Ways of Building Oracle Applications", but now expanded into seven ways. Oracle currently offers the following toolkits and frameworks for application development: Forms ADF ...
127 0 /
Follow /24 Oct 2016 at 8:00am / Oracle Blog

Direct NFS: please check that oradism is setuid

The above error appeared in Database Alertlog and it's related to permission, i am using DNFS as file system for Database :- ls -ltr $ORACLE_HOME/bin/oradism -rwxrwxr-x 1 sorabill oinstall 109247 Jul 7 2014 /u01/app/oracle/product/12.1.0/dbhome_1...
49 0 /
Nakul Vachhrajani
Follow /24 Oct 2016 at 4:30am / SQL Server Blog

#0391 – SQL Server – SSIS – OLE DB Destination – Table Fast Load – Performance – Table Lock option

The "Table Lock" checkbox on an OLE DB destination task works identical to the T-SQL TABLOCK table hint. I explore how to leverage OLE DB Table Lock setting to get better SQL Server data load performance.
50 0 /
Pinal Dave
Follow /24 Oct 2016 at 2:30am / SQL Server Blog

PowerShell – Script to Listing all Backups Taken with SQL Server

I always like to keep a number of scripts handy in my USB drive with my Laptop. These scripts are used for my internal use when I am suddenly looking for something interesting in customer environments. One of the scripts that I use is shown below. Many...
54 0 /
Deiby Gomez
Follow /23 Oct 2016 at 10:05pm / Oracle Blog

Invisible Columns in Oracle 12c

Starting in Oracle there are several new features, +500 I have heard, and one of a good features for developers is "Invisible Columns". Invisible Columns allows a developer create a table with some special columns. These special columns...
232 0 /
Abu Fazal Abbas
Follow /23 Oct 2016 at 8:50am / Oracle Blog

Oracle 12c: Customize your seed (pdb$seed) template PDB

Oracle has introduced multi tenant architecture with the release of Oracle database 12c ( In a multi tenant Oracle database, we have a ROOT container database (CDB$ROOT), a SEED database (PDB$SEED) and the potential to have a number of pluggable...
189 0 /
Porus Homi Havewala
Follow /23 Oct 2016 at 3:28am / Oracle Blog

MySQL Enterprise Monitor 3.3 generally available (GA)

The Oracle MySQL database has an Enterprise Edition , and included with that subscription is MySQL Enterprise Monitor which is a tool to monitor and manage MySQL databases. The latest release of MySQL Enterprise Monitor is version 3.3, recently released...
60 0 /
Pinal Dave
Follow /23 Oct 2016 at 2:30am / SQL Server Blog

Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094

A very common question I often see users not sure about the answer. This is indeed a tricky question, but a very simple one. If I am the interviewer, I may ask this question to the user, but if they do not know the answer of this question, I would not...
70 0 /
Nassyam Basha
Follow /22 Oct 2016 at 3:34pm / Oracle Blog

DB Link between Oracle and MSSQL and resulted “internal error in heterogeneous remote agent”

DB Link between Oracle and MSSQL and resulted “internal error in heterogeneous remote agent” This blog post based on the experience with one of customer, it is so simple but i rarely worked on these heterogeneous db links, so am writing for...
66 0 /
Nassyam Basha
Follow /22 Oct 2016 at 3:18pm / Oracle Blog

Know size of all databases from OMR – #EM

Know size of all databases from OMR – #EM I have been asked to know all the databases size and export them in excel file, that’s all!!!  We are using EM 11.1 of course old but that is no matter for me and in total we have 173 target databases...
65 0 /
Nassyam Basha
Follow /22 Oct 2016 at 2:58pm / Oracle Blog

ORA-3113 End of communication channel with Select query vs sqlnet.ora

ORA-3113 End of communication channel with Select query vs sqlnet.ora This blog post writing based on the recent issue i’ve seen, Let’s start, customer reported as connection to the database from the client version 11gR2 was successful...
49 0 /
Syed Jaffar Hussain
Follow /22 Oct 2016 at 10:53am / Oracle Blog

Is Fixed Objects Stats needed in PDB?

Doesn't matter if we are working on a new technology or something we are very family with. When we encounter tricky situations, sometimes neither we could find things in the manuals nor could find any useful references. All what you need is an action...
67 0 /
Brendan Tierney
Follow /22 Oct 2016 at 10:41am / Oracle Blog

Our first OUG Ireland Meet-up

Last Thursday evening (20th October) we had our first Meet-up event for OUG Ireland. Up to recently we have had a one or two full day SIG events that covered both the Tech and BA/Big Data areas. But we have been finding it increasingly difficult to get...
56 0 /
Pinal Dave
Follow /22 Oct 2016 at 2:30am / SQL Server Blog

PowerShell – Tip: How to Format PowerShell Script Output?

I have been writing on various ways of working with PowerShell and how to connect to SQL Server. Personally, when I see text on command prompt it is quite a mess and very difficult to decipher the same. If you play around and look at various blog posts...
67 0 /
Melissa Coates
Follow /22 Oct 2016 at 12:55am / SQL Server Blog

Why You Want to Use the Latest SQL Server Management Studio Release

We have two main built-in tools for interacting with a SQL Server database platorm: SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT). This post is about SSMS and why you may want to install the latest release...even if you're not...
59 0 /
Chris Webb
Follow /21 Oct 2016 at 7:43pm / SQL Server Blog

Nested Variables In DAX

Last week, at the SQL Server Days conference in Belgium, Kasper mentioned in his presentation that it was possible to define variables inside variables in DAX. So, for example, you could define a measure like so: MyMeasure = var Outer1 = var...
42 0 /
Stuart Ainsworth
Follow /21 Oct 2016 at 4:27pm / SQL Server Blog

One (Last) Trip to the Emerald City for #SQLPASS

On Monday, I’m flying out to the Emerald City (Seattle, WA) for the annual gathering of Microsoft database geeks known as the PASS Summit ; as always, I’m excited to see friends and learn new stuff. However, this will probably be my last Summit...
46 0 /
Pinal Dave
Follow /21 Oct 2016 at 2:30am / SQL Server Blog

PowerShell Scripts – get-process with SQL Server process

Working with powershell scripts can be interesting. I have in the past shown a number of such scripts that we can use with SQL Server. In this blog, I was playing around understanding how I can use the get-process commandlet and how it can be used with...
64 0 /
Kellyn PotVin
Follow /20 Oct 2016 at 10:23pm / Oracle Blog

User Group Boards, Voting, Oh Yeah and ODTUG

I think we’ve just about all heard enough about voting this election year, but I want to discuss a slightly different angle and that’s when it comes to user groups.  As most people know, I’m pretty passionate about everyone contributing...
37 0 /
Gokhan Atil
Follow /20 Oct 2016 at 9:28pm / Oracle Blog

EM13c: Get List of URLs Monitored by Beacons

When you need to monitor web services, you can use EM beacons. A beacon is a target that allows the EM Agent to remotely monitor services. You can add beacons to any EM agent using “Add Non-Host Targets by Specifying Target Monitoring Properties”...
119 0 /
Sten Vesterli
Follow /20 Oct 2016 at 8:10pm / Oracle Blog

Critical Patch Update Oct 2016 - Serious WebLogic Issues

It’s that time of year again - the last Oracle Critical Patch Update for 2016 . With 253 fixes, it’s another big one, though not as big as the previous one. Bad news especially for WebLogic users - three different issues with a scary 9...
320 0 /