Discuss in the Community - Toad World

Discuss in the Community


Kenneth Fisher
Follow /8 Feb 2016 at 2:00pm / SQL Server

Impersonation can give you the wrong answer

I use impersonation all the time to let me see additional permissions information I can only get that way and, sometimes to help me see what permissions error someone is getting. For those of you who aren’t aware, with the right permissions you...
6 0 /
Jorge Segarra
Follow /8 Feb 2016 at 1:30pm / SQL Server

T-SQL Tuesday #75 Invitation: Jump into Power BI!

Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI ! If you’re reading this and thinking “crap, I’m not a BI person!”, don’t you fret. My intention is to make folks...
6 0 /
Steve Hood
Follow /8 Feb 2016 at 12:00pm / SQL Server

Database Log VLFs

Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files work in the background.  These are created automatically, but automatically doesn’t always mean perfect.  Here’s a practical...
21 0 /
Nakul Vachhrajani
Follow /8 Feb 2016 at 3:30am / SQL Server

#0373 – SQL Server – Interview Questions – Parameters required for server-side paging mechanisms

For a mid-level SQL developer profile, this is one of my favourite interview questions if their current projects involve some sort of paging mechanism while displaying results on a grid. What is the minimum number of parameters that your stored procedure...
29 0 /
Follow /6 Feb 2016 at 10:16pm / SQL Server

SQL Server Database File Size and Free Space Revisited

I recently had a comment posted to one of my first articles I wrote way back in 2012 concerning adding a column that detailed the used space as a %age. So without any further ado, here is an updated version of a script originally blogged about here ....
54 0 /
Abu Fazal Abbas
Follow /6 Feb 2016 at 5:23pm / Oracle

Oracle 12c ( Now we can preserve the PDB state between instance startup

As we know, Oracle has introduced the multitanent architecture with Oracle version 12c, where we can have multiple pluggable databases (PDB) within a single container database (CDB). However, when we start up a container database (CDB), all of the associated...
137 1 /
Porus Homi Havewala
Follow /6 Feb 2016 at 2:44pm / Oracle

Tips for the Enterprise Manager Software Library – Part I

The Software Library is a very important and critical “core” part of Oracle Enterprise Manager . It is a file system repository associated with the Enterprise Manager system, and the prime purpose of this library is to store various software...
57 0 /
Clarisa Maman Orfali
Follow /6 Feb 2016 at 2:46am / Oracle

Access Control List (ACL) y JasperReports Integration Kit

Hola amigos, el otro día un amigo me comentó que tenía problemas al trabajar con el JasperReports Integration kit cuando cambiaba de Workspace. Básicamente cuando trabajaba con una aplicación en el workspace1 funcionaba...
64 0 /
Paul Turley
Follow /5 Feb 2016 at 7:51pm / SQL Server

Gartner Magic Quadrant for BI/BA and the Lone Three Leaders

History clearly confirms that good things come in threes!  As far as I know this is the first time that only the three most widely recognized Business Intelligence platforms have been placed in the top-right leaders/visionaries space of the Magic Quadrant...
65 0 /
Denny Cherry
Follow /5 Feb 2016 at 7:19pm / SQL Server

DCAC Now Has 2 VMware vExperts

I’m thrilled to report that Denny Cherry & Associates Consulting now has not 1, but 2 VMware vExperts in our ranks.  No we didn’t go off and hire another consultant.  VMware has decided that this year they will recognize both Myself (Denny...
53 0 /
Follow /5 Feb 2016 at 3:58pm / SQL Server

Get Drive Sizes using SQL or PowerShell

There are countless methods to obtain drive size information, each with its own set of benefits and limitations. I use a few different methods depending on if I have to type out the solution quickly or if I need a comprehensive view. Method 1 –...
140 0 /
Chris Webb
Follow /5 Feb 2016 at 11:48am / SQL Server

New Ways To Concatenate Text In Excel 2016 With CONCAT() And TEXTJOIN()

I don’t normally blog about Excel topics outside of Power Query and Power Pivot , but I think anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more than two text values (although there are plenty of blog...
63 0 /
Gethyn Ellis
Follow /5 Feb 2016 at 10:00am / SQL Server

Its been a busy start to the year

Its been a busy start to the year at gethynellis.com. I have been involved in a Big Data training courses in Alexandria - a suberb of DC, followed by the same course running again in London a week later. This was followed by a SQL Server 2012 skills upgrade...
59 0 /
Clarisa Maman Orfali
Follow /4 Feb 2016 at 11:59pm / Oracle

Personalizar Botones con Imágenes almacenadas en nuestro Espacio de Trabajo usando CSS

Muchas veces nos encontramos en la necesidad de personalizar nuestros botones en nuestras aplicaciones en Oracle APEX, es por ello que el día de hoy te voy a enseñar cómo puedes colocar una imagen en el botón que se encuentra...
119 0 /
Kellyn PotVin
Follow /4 Feb 2016 at 6:23pm / Oracle

Importance of Network to the Cloud

I’ve been discussing for years about the importance of network to database performance, especially once I started working on VLDBs, (Very Large Databases) but its a topic that often is disregarded.  Now that I’m working more and more in the...
109 0 /
Henrik Loeser
Follow /4 Feb 2016 at 3:04pm / IBM DB2

How to Navigate Bluemix - My Starter Guide

34 0 /
Syed Jaffar Hussain
Follow /4 Feb 2016 at 10:58am / Oracle

Storage difference between 2 identical Exa boxes. How and why?

We noticed around 1.6TB storage difference between two Eight (1/8) Exadata boxes while configuring Data Guard. Wondered what went wrong. The Exa box configured for DR was around 1.6TB short compare to the other Exa box. Verified the lun, physical disk...
65 0 /
Fernando Garcia
Follow /3 Feb 2016 at 10:29pm / Oracle

La inteligencia de negocios y el Datawarehouse.

La inteligencia de negocios (BI) y un datawarehouse nos permiten convertir los datos alojados en nuestras bases transaccionales en información que nos ayudará a tomar mejores decisiones de negocio. Oracle define a un datawarehouse como...
148 0 /
Brad Wulf
Follow /3 Feb 2016 at 10:12pm / Toad for Hadoop - Blog

Toad for Hadoop – Impala SQL Editor

With the release of Toad for Hadoop 1.3.0 we’ve introduced Impala SQL on Hadoop editor support! To configure, select Window | Preferences | Ecosystems | <your ecosystem with Impala> | SQL Check the ‘Use Impala’ checkbox and enter the Impala...
24 0 /
Svetoslav Gyurov
Follow /3 Feb 2016 at 6:09pm / Oracle

Exadata onecommand fails at cell disk creation

I was installing another Exadata last month when I got an error on create cell disks step. I’ve seen the same error before when I was extending two to three rack Exadata configuration but thought it was one-off. The cell disk creation failed as...
106 0 /
James Serra
Follow /3 Feb 2016 at 4:00pm / SQL Server

Scaling Azure SQL Database

One of the advantages  Azure SQL Database has over on-prem SQL Server is the ease in which it can scale.  I’ll discuss the various options for horizontal scaling, vertical scaling, and other similar features. Horizontal scaling refers to adding...
140 0 /
Kenneth Fisher
Follow /3 Feb 2016 at 2:00pm / SQL Server

Blogger questions: What if someone else wrote about the same subject?

I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a lot of posts (twice a week for > 3 years). Over 340 of them in fact. Because of this a friend asked me what I do if I write a blog and then...
97 0 /
Michael J. Swart
Follow /3 Feb 2016 at 1:00pm / SQL Server

You’re Probably Taking Sort Order For Granted Somewhere

As many people will point out , you can’t depend on the order of results without using the ORDER BY clause. So it’s easy to say “Simple! Don’t write code that expects unsorted data to be sorted”. But it’s very difficult...
80 0 /
Denny Cherry
Follow /3 Feb 2016 at 7:00am / SQL Server

Fixing a storage pool that doesn’t have an read-write server

Recently I was working on a clients file server cluster and while doing some troubleshooting with Microsoft Support one of the clustered disks wouldn’t respond correctly.  Now this file server cluster is setup in Azure so it is using SIOS Data Keeper...
69 0 /
Abu Fazal Abbas
Follow /3 Feb 2016 at 6:55am / Oracle

Oracle 12c RAC: Clusterware logs are now centralized

When dealing with a Oracle Real Application Cluster (RAC) issue, a DBA generally needs to jump around multiple directories to find the relevant logs. Those days are now history as Oracle has centralized all the Clusterware (RAC) log files in a common...
207 2 /