Discuss in the Community - Toad World

Discuss in the Community

Blogs

Kellyn PotVin
Follow /8 Feb 2016 at 8:42pm / Oracle

EM13c Upgrade Tips- Part II

There is a flurry of excitement about Enterprise Manager 13c and I’m blown away by how many customers are looking not just to install and test out the new release, but have plans already underway to upgrade to it.  At Oracle, we’re covering...
24 0 /
Chris Webb
Follow /8 Feb 2016 at 8:28pm / SQL Server

Disabling Excel PivotTable Grouping And Session Cubes In SSAS Multidimensional

The Excel PivotTable grouping functionality that is available when you are connected to an SSAS Multidimensional cube (but not a Tabular model ) is a Very Bad Thing indeed. In my experience it is a major cause of query performance problems – not just...
28 0 /
Denny Cherry
Follow /8 Feb 2016 at 7:40pm / SQL Server

Would you like Microsoft to pay for you to move to Azure?

Have you been wanting to move some of your services up to Azure , but you don’t have the budget to move them up to th e cloud? Microsoft has an excellent deal for you. Microsoft will pay for (at least part) of the consulting time needed to get you...
32 0 /
Dan Hotka
Follow /8 Feb 2016 at 3:32pm / Oracle

Write your own hints

Ever have a need to do something with the library cache where it would be just plain convenient if the SQL always hard parsed? I’ve discussed the issues with bind variables. In recent articles and blogs, I’ve discussed Oracle’s work...
74 0 /
Dan Hotka
Follow /8 Feb 2016 at 3:29pm / Oracle

User Groups in your Area

Hi! Do you regularly attend user groups? Do you know if one is in your area? Do a little research… Many user groups, such as the Dallas OUG…meet once a month in the evenings. Many user groups such as the Twin Cities and the Heartland...
82 0 /
Gethyn Ellis
Follow /8 Feb 2016 at 3:00pm / SQL Server

Introduction to SQL Server: The Main Components

There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a new person just starting a career as a data professional using Microsoft's SQL Server data platform could use to learn all about...
81 0 /
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...
39 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...
86 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...
44 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...
44 0 /
Richard_RP
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 ....
61 0 /
Abu Fazal Abbas
Follow /6 Feb 2016 at 5:23pm / Oracle

Oracle 12c (12.1.0.2): 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...
140 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...
63 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...
71 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...
70 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...
58 0 /
sqlsanctum
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 –...
162 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...
66 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...
63 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...
122 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...
110 0 /
Henrik Loeser
Follow /4 Feb 2016 at 3:04pm / IBM DB2

How to Navigate Bluemix - My Starter Guide

37 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...
67 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...
154 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...
27 0 /