Discuss in the Community - Toad World

Discuss in the Community


Chris Webb
Follow /27 Nov 2015 at 9:30am / SQL Server

New SSAS, Power BI And SQL Server Training Courses For 2016

I’ve just added a number of new 2016 training course dates to the Technitrain site. If you’re looking for Power BI, Analysis Services, SQL Server or Data Science training in London then please check them out! Also, if you’d like to sign up for the Technitrain...
33 0 /
Arthur Olcot
Follow /26 Nov 2015 at 8:51pm / SQL Server

UK Contractors - As you were, for now at least

I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks there has been plenty of reports of doom and gloom from the various media...
52 0 /
Follow /26 Nov 2015 at 8:17pm / Oracle

BGOUG Autumn Conference - Extraordinary trip

it's 19-Nov-2015 and this day means that i should start packing and prepare myself for traveling to Bulgaria, at first everything was normal and i thought it will be like any other trip i did before. since there is no direct flight to Bulgaria then...
92 0 /
Arthur Olcot
Follow /26 Nov 2015 at 8:04pm / SQL Server

Temporary Post Used For Theme Detection (b4dd5212-1214-4a73-ab89-2e9107f53b84 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (9ef4d2a7-197a-4c68-8beb-0f37348d6aec - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
60 0 /
Dan Hotka
Follow /26 Nov 2015 at 1:43pm / Oracle

Oracle11 SQL Inlining Coding Feature

Hi! I have been talking a little bit about the context switch when you are working with PL/SQL and SQL together. IF you call a function from the SQL statement, a context switch will occur to pass control to the PL/SQL engine then back when the PL...
52 0 /
Derik Hammer
Follow /26 Nov 2015 at 1:00pm / SQL Server

Statistics Parser

Today I’d like to recommend a free community tool, StatisticsParser.com . Statistics Parser is web-based tool for interpreting the text output of the T-SQL SET STATISTICS IO and TIME settings. The tool was created and is maintained by Richie Rump...
41 0 /
Sten Vesterli
Follow /26 Nov 2015 at 12:54pm / Oracle

Brand-new Oracle Forms 12c heading out of support

I was happy that Oracle finally got around to releasing Oracle Forms 12c, and confidently expected Oracle to offer us the normal 5 years of premier support and 3 years of extended support. But that's not what happened. You see, Oracle considers...
107 1 /
Clarisa Maman Orfali
Follow /26 Nov 2015 at 2:21am / Oracle

Definir Valores de Interfaz de Usuario por Defecto (UI) en Oracle APEX 5.0

Muchas veces estamos usando en nuestra aplicación tablas de datos en Informes/Pantallas en diferentes páginas y lo que es habitual siempre necesitamos cambiar el nombre de los encabezados de columnas para que sea más representativo...
55 0 /
Paul Turley
Follow /26 Nov 2015 at 2:09am / SQL Server

Complete DAX Function Reference

The DAX function reference documentation in MSDN can be found on separate pages,  organized by categories but you can’t view all of the functions in one page.  If you don’t know exactly what you’re looking for, this can be a bit of a hunting...
57 0 /
Ed Elliott
Follow /25 Nov 2015 at 10:42pm / SQL Server

Convert select statements in scripts into Inline-TVF's automatically

In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror of horrors Scalar Functions. Taking select statements and turning them into in-line TVF's is actually really...
55 0 /
Fernando Garcia
Follow /25 Nov 2015 at 10:36pm / Oracle

¿Para qué sirve la cláusula CROSS APPLY?

La versión 12c del servidor de base de datos Oracle incluye una nueva extensión del lenguaje SQL: la cláusula CROSS APPLY. Existen diversos escenarios en los que dicha cláusula nos resulta de gran utilidad. En general, los...
145 0 /
Thomas LaRock
Follow /25 Nov 2015 at 5:09pm / SQL Server

The DBA Plate for 2016

Four years ago I wrote about the DBA Plate, which was a reference to the food plate that replaced the food pyramid right about the time the U.S. Congress declared pizza to be a vegetable. I had every intention of keeping the plate updated annually but...
58 0 /
Ed Elliott
Follow /25 Nov 2015 at 5:07pm / SQL Server

ScriptDomVisualizer - Now Displays TSqlParserToken's

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script. Honestly if you are doing anything with...
60 0 /
Denny Cherry
Follow /25 Nov 2015 at 4:00pm / SQL Server

Inline Nonclustered Indexes

One of the new features that I just recently learned about in SQL Server 2014 is the ability to create nonclustered indexes on a table inline with the creation of the table. This is handy in a couple of ways. First it makes it so that all the indexes...
67 0 /
Craig Mullins
Follow /25 Nov 2015 at 4:00pm / IBM DB2

Happy Thanksgiving 2015

Every year this week those of us in the USA take time out to give thanks for all that we have. We do this by taking time off of work, gathering with our families, eating turkey (and a lot of other stuff), and watching football. It is one of my favorite...
169 0 /
Norm [TeamT]
Follow /25 Nov 2015 at 3:45pm / Oracle

UTL_FILE Operation fails with ORA-29283

A process that called ”UTL_FILE” was failing in the test system, but worked fine with exactly the same set up in production. Why? The error was ORA-29283: invalid file operation. How do we find out exactly why it was failing? MY_DIRECTORY...
56 0 /
Kenneth Fisher
Follow /25 Nov 2015 at 2:00pm / SQL Server

Women in technology

Earlier this week a friend of mine (Lynn Swayze (Hall) ( b / t )) posted this great article on women in technology . It’s a great read and I highly recommend it. In fact, go read it right now. I’ll wait. You’re back? Good. So, her...
66 0 /
Svetoslav Gyurov
Follow /25 Nov 2015 at 10:04am / Oracle

How to rename ASM disk groups in Exadata

Deployment of Exadata requires you to generate configuration using Oracle Exadata Deployment Assistant (OEDA). Within the same the default  ASM disk groups names are DBFS_DG, RECOC1 and DATAC1. I usually change those to RECO01 and DATA01 as others doesn’t...
62 0 /
Deiby Gomez
Follow /25 Nov 2015 at 6:40am / Oracle


In our daily tasks as a Database Administrator it's common to see requests to get the DDL sentence from any object. Everybody knows that there is the package DBMS_METADATA that can be used for this kind of requests. But most of the DBAs uses DBMS_METADATA...
160 0 /
Clarisa Maman Orfali
Follow /25 Nov 2015 at 2:20am / Oracle

Crear Informe-Formulario tipo Maestro-Detalle en Oracle APEX 5.0

Una de las más populares características en Oracle APEX es el asistente para crear un formulario del tipo Maestro/Detalle con el cual fácilmente podemos crear un informe y su correspondiente formulario (Pantalla) para manejar los...
84 0 /
Chris Webb
Follow /24 Nov 2015 at 10:42pm / SQL Server

Using Parameter Tables To Control Data Refresh In Power BI

The use of parameter tables is a well-known technique in Power Query. It involves using a table from the current Excel workbook to hold various parameter values that are read using a Power Query query, and these parameter values are then passed to another...
76 0 /
Ed Elliott
Follow /24 Nov 2015 at 8:44pm / SQL Server

Changing case of T-SQL Keywords

Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person "Mr Bert Ernie" anyway I digress, whether you are working by yourself or in a team you sometimes want to...
53 0 /
Paul Turley
Follow /24 Nov 2015 at 8:21pm / SQL Server

SQL Server 2005 End of Support and Business Intelligence

How does the official end of support for SQL Server 2005 mean for companies using Reporting Services, Analysis Services and other BI features? I was recently interviewed for a CIO Magazine article by freelance writer Andy Patrizio about what the end of...
63 0 /
Sten Vesterli
Follow /24 Nov 2015 at 7:56pm / Oracle

Be careful when upgrading VMware

If you are running VMware 5.0 or 5.1, you'll be aware that support runs out August 2016. However, upgrading VMware has important implications for your Oracle licensing. In 5.0 and earlier, you only had to license the cluster you were running VMware...
111 0 /
Bob Pusateri
Follow /24 Nov 2015 at 6:33pm / SQL Server

SQL Saturday Chicago 2016 Registration Open!

Registration is now open for Chicago’s 6th SQL Saturday ! It will be taking place at DeVry University’s Addison Campus on March 5 2016. Please join us! If you’re not familiar with SQL Saturday , it’s a free day of training for...
58 0 /