Discuss in the Community - Toad World

Discuss in the Community


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...
26 0 /
Clarisa Maman Orfali
Follow /25 Nov 2015 at 2:20am / Oracle

Crear Informe/Formulario 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...
33 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...
44 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...
7 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...
40 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...
60 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...
35 0 /
Jason Strate
Follow /24 Nov 2015 at 4:00pm / SQL Server

Tuesday Morning SQL Break – November 24, 2015

It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me on twitter ( @StrateSQL ). This is a good chance to catch up on data platform technology and career related information...
54 0 /
Chris Yates
Follow /24 Nov 2015 at 3:00pm / SQL Server

Why Should Data Professionals Automate?

Take a minute and look around you. Automation is all around you; whether you see it or not processes are automated on all levels of life. One thing that I’ve noticed among professionals is that “change” is very difficult; while others do not know what...
39 0 /
Ed Elliott
Follow /24 Nov 2015 at 12:28pm / SQL Server

Quickly deploying procedure/functions from SSDT (Bypass Publish)

SSDT is great but one thing that is not so great is the performance of the publish. I am not complaining, I understand it does a lot and is well worth the wait when publishing however, when you are writing and testing code having this process really kills...
43 0 /
Ricardo Leka
Follow /24 Nov 2015 at 10:16am / SQL Server

SQL Saturday #469 – Brasilia

E aí pessoal !!! O conteúdo da palesta sobre backup parcial e restauração parcial e online está disponível. O Slide está disponível para download ou visualização abaixo O link para o download dos scripts e da apresentação está aqui . Quero, novamente...
43 0 /
Ed Elliott
Follow /24 Nov 2015 at 12:20am / SQL Server

Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This is really cool but if you round-trip the T-SQL into an AST and back you lose some important...
56 0 /
Follow /23 Nov 2015 at 10:55pm / SQL Server

Datatypes or Data Types?

I conducted a Twitter poll last week about how to spell DATATYPE (or is it DATA TYPEs?).  Many compound words start out as two separate words, then get hyphenated, then concatenated to a new word.  We saw this with: data base –> data-base...
56 0 /
Fernando Garcia
Follow /23 Nov 2015 at 8:04pm / Oracle

Conociendo el lenguaje SQL y CROSS APPLY

Versión tras versión el servidor de base de datos Oracle nos sorprende con nuevas prestaciones. Oracle no sólo potencia su motor de base de datos a lo largo de los años, sino que también enriquece su lenguaje SQL agregando...
125 0 /
Henrik Loeser
Follow /23 Nov 2015 at 4:28pm / IBM DB2

IDUG 2015 in Dublin: A week with friends

39 0 /
John Pertell
Follow /23 Nov 2015 at 2:00pm / SQL Server

SQL 2016 and R – Working With SQL Data

In the last few posts I’ve gone over installing the components you need to run R in a SQL 2016 instance as well as some simple scripts that played with one of the data sets that’s included with R. Today we’ll start working with data stored inside a SQL...
129 0 /
Kenneth Fisher
Follow /23 Nov 2015 at 2:00pm / SQL Server

Using multiple log files

The transaction log is made up of one or more files that are used sequentially. So in other words if you have multiple log files then new log information will only be written within one of those files at a time. The good To the best of my knowledge...
75 0 /
Deiby Gomez
Follow /22 Nov 2015 at 11:54pm / Oracle

V Congreso de Informática Zacapa

NOTE: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. El dia sábado 7 de noviembre del 2015 estuve por tercera vez compartiendo lo poco...
104 0 /
Deiby Gomez
Follow /22 Nov 2015 at 10:39pm / Oracle

ins_rdbms.mk and Segmentation fault errors with Oracle 12c

Well, you know it is weekend, it is when more free time we have to play with Oracle Stuff plus the 12 hours at night that we have everyday; it was raining, there was coffee, and only Oracle was pending. So I decided to practice some topics for Oracle...
242 0 /
Ed Elliott
Follow /22 Nov 2015 at 10:35pm / SQL Server

SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost but there is no real way other than examining the the tables you are querying and understanding the data...
80 0 /
Clarisa Maman Orfali
Follow /22 Nov 2015 at 8:28pm / Oracle

Restringir la carga de archivos en un Informe a solo PDF en Oracle Apex 5.0

En el artículo de hoy les voy a mostrar cómo pueden restringir la carga de archivos en su aplicación en Apex. Para ésta demo vamos a crear una tabla en nuestro schema: CREATE TABLE "DEMO_FILE_BLOB" ( "ID"...
80 0 /
Porus Homi Havewala
Follow /22 Nov 2015 at 9:44am / Oracle

Oracle Database Appliance and Oracle Enterprise Manager

As many of you may already be aware of, the Oracle Database Appliance (ODA) is a database platform supplied pre-built by Oracle, with high availability (HA) capabilities out of the box. This is so because the ODA comes with two server nodes along with...
77 0 /
Denny Cherry
Follow /21 Nov 2015 at 12:06am / SQL Server

Recommended reading from mrdenny for November 20, 2015

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Keep Your Data Lake from Turning Into a Swamp with Semantics What Data Science Means to Data Scientists Learn First or Use First...
89 0 /
Craig Mullins
Follow /20 Nov 2015 at 8:30am / IBM DB2

DB2 Optimization and Access Paths: Understanding the Basics - Part 2: Join Methods

The DB2 optimizer can choose from a variety of different techniques as it creates optimal access paths for each SQL statement. In Part 1 of this series ( http://www.toadworld.com/platforms/ibmdb2/b/weblog/archive/2015/10/29/db2-optimization-and-access...
237 0 /
Dan Hotka
Follow /20 Nov 2015 at 8:20am / Oracle

Working with Skewed Data

Hi, This article will feature histograms. This is a cost-based statistic that is used during the hard-parse process to get a better idea of row counts for particular where clause predicates. The whole goal here is for the CBO to decide: Do...
88 0 /