Discuss in the Community

Blogs

Fernando Garcia
Follow /29 Aug 2015 at 3:29pm / Oracle

Cómo corroborar expresiones de calendario

Cuando necesitamos ejecutar tareas repetitivas en nuestra base de datos Oracle, podemos utilizar el planificador de tareas interno implementado por Oracle mediante el paquete DBMS_SCHEDULER. Para especificar cuándo ejecutar las tareas repetitivas...
75 0 /
Kellyn PotVin
Follow /29 Aug 2015 at 1:05am / Oracle

Creating a Trace File from EM12

Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action. Enterprise Manager also removes some of the syntax options that could get a developer...
128 0 /
Steven Feuerstein
Follow /28 Aug 2015 at 9:05pm / Oracle

Optimizing PL/SQL Panel at Oracle Open World 2015 - Questions welcome!

At Oracle Open World 2014, I was a member of a panel on SQL and PL/SQL Performance. It was an awful lot of fun, but as I had expected, most of the questions focused on SQL performance, and most of them were answered by Tom Kyte (no complaints from me...
149 0 /
Ricardo Leka
Follow /28 Aug 2015 at 8:27pm / SQL Server

Event Notification para kill

Algum tempo atras fiz um post sobre Event Notification para monitorar DeadLock o que funciona muito bem,,, Com um pouco de modificação o mesmo código pode ser utilizado para muitas outras coisas,,, por exemplo: limitar acesso a uma instância bloqueando...
217 0 /
WaterOx
Follow /28 Aug 2015 at 2:30pm / SQL Server

017 – Thinking Like A Manager - WaterOx Consulting

Reading Time: 2 minutes Thinking Like A Manager In WOxPod!, episode # 017 – “Thinking Like... The post 017 – Thinking Like A Manager appeared first on WaterOx Consulting .
217 0 /
Iggy Fernandez
Follow /28 Aug 2015 at 1:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 39: Unfriending the optimizer statistics

Previous installment: Shakespeare’s advice for database upgrades First installment: DON’T PANIC “Heigh-ho, sing heigh-ho, unto the green holly. Most friendship is feigning, most loving mere folly. Then heigh-ho, the holly. This life...
564 0 /
Fernando Garcia
Follow /27 Aug 2015 at 10:41pm / Oracle

Ejemplos de uso de expresiones de calendario

En este artículo veremos ejemplos de uso concreto de expresiones de calendario. Este es el cuarto artículo de una serie dedicada al planificador de tareas interno de Oracle. Te recomiendo leer los artículos anteriores: Oracle...
114 0 /
Dan Hotka
Follow /27 Aug 2015 at 8:14pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 10)

Hi! OK, we have been discussing cardinality and the importance of order in the Explain Plan. I have shown you newer syntax (and tools that runs said syntax) that shows actual row counts (cardinality) per line of explain plan. I’ve beat round...
135 0 /
Jen McCown
Follow /27 Aug 2015 at 6:22pm / SQL Server

I am not a “wogrammer”

So apparently the COO of Facebook is trying to make the word “wogrammer” – a woman programmer – a thing.  (Thanks to Vicky Harp for pointing out this infuriating thing.) I cannot stress how fundamentally opposed I am to this, new...
97 0 /
Marlon Ribunal
Follow /27 Aug 2015 at 4:30pm / SQL Server

Getting Started With Power BI Desktop: Simple Visualization

This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data . In this post, let’s see how easy it is to create visualization on Power BI Desktop. If...
162 0 /
Chris Yates
Follow /27 Aug 2015 at 2:39pm / SQL Server

SQLSat403 – Recap

The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event has come and gone, but this time it was different. The reason for this was from the hard work, effort, countless hours, and collaboration that...
154 0 /
Fernando Garcia
Follow /26 Aug 2015 at 9:49pm / Oracle

Como calendarizar tareas con DBMS_SCHEDULER

En los últimos dos artículos hemos estado conociendo el planificador de tareas interno de Oracle. Al crear una tarea es indispensable que indiquemos qué hacer y cuándo hacerlo. Como en general hablamos de tareas repetitivas...
131 0 /
prashanthjayaram
Follow /26 Aug 2015 at 8:20pm / SQL Server

Use FILEPROPERTY to find free space in all the database

The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot of other attributes of it such as free space and percentage of free space. For other versions of SQL you can refer the below SQL. DECLARE...
166 0 /
Denny Cherry
Follow /26 Aug 2015 at 7:00pm / SQL Server

Connecting To SQL Server Running On An Azure VM

If you have setup a Windows Azure Virtual Machine running SQL Server you may have noticed that you might not be able to connect to the SQL Server running on the machine by using SQL Server Management Studio on your workstation (desktop, labtop, etc) from...
174 0 /
David Fitzjarrell
Follow /26 Aug 2015 at 5:11pm / Oracle

“But, You Don’t Understand…”

"Let me try once more," he said in an effort to explain. "In other words--" "You mean you have other words?" cried the bird happily. "Well, by all means, use them. You're certainly not doing very well with the...
137 0 /
Ben Thompson
Follow /26 Aug 2015 at 3:05pm / Oracle

Non-working logon trigger on Data Guard standby database

Today I did something very dumb when working with a vendor to trace and issue and rendered our Data Guard physical standby database unusable. I added an AFTER LOGON ON DATABASE trigger which collected information about a session and wrote it to a table...
51 0 /
WaterOx
Follow /26 Aug 2015 at 2:30pm / SQL Server

The Problem With AshleyMadison - WaterOx Consulting

Reading Time: 3 minutes What is the real problem with the AshleyMadison data breach? Well, let... The post The Problem With AshleyMadison appeared first on WaterOx Consulting .
117 0 /
akreul
Follow /26 Aug 2015 at 1:55pm / SQL Server

Agile Development – A DBA’s Initial Thoughts

I recently had the opportunity to attend a three day Agile development workshop.  At a very high level, Agile development values making small, iterative changes over short periods of time, unlike traditional software development methods that generally...
78 0 /
Jason Brimhall
Follow /26 Aug 2015 at 1:18pm / SQL Server

Shredding XML in XEvents

One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues. Despite that, Extended Events takes advantage...
92 0 /
Steven Feuerstein
Follow /26 Aug 2015 at 1:16pm / Oracle

Table Functions, Part 5c: Another use case for Pipelined Table Functions (and simple example)

From Oracle Help Center (a.k.a., documentation), we read : Data is said to be pipelined if it is consumed by a consumer (transformation) as soon as the producer (transformation) produces it, without being staged in tables or a cache before being input...
173 0 /
Chris Webb
Follow /26 Aug 2015 at 1:02pm / SQL Server

How To Optimise The Performance Of MDX Queries That Return Thousands Of Rows

One problem I encounter on a regular basis is how to optimise the performance of MDX queries that return thousands, hundreds of thousands, or even millions of rows. The advice I give is always the same: Reduce the number of rows that your query returns...
76 0 /
Kenneth Fisher
Follow /26 Aug 2015 at 1:00pm / SQL Server

The 30 minute rule

In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule . Kind of catchy right? But what did it mean? Simply said, if you have made no progress on a problem for 30 minutes go find some help. The idea is that...
74 0 /
Fernando Garcia
Follow /25 Aug 2015 at 11:44pm / Oracle

Cómo crear una tarea con DBMS_SCHEDULER

En el post anterior hemos visto una introducción al planificador de tareas interno de una base de datos Oracle . En este artículo vamos a crear nuestra primera tarea (job). Nuestro job consistirá en ejecutar un procedimiento almacenado...
155 0 /
rickdelgado
Follow /25 Aug 2015 at 10:37pm / NoSQL

Big Data and the Final Frontier: The Impact of Big Data on Space Exploration

Big data seems to be everywhere these days. In one moment, it’s seen among financial institutions. The next it’s prevalent in the healthcare industry. Then it’s being used among governments both locally and on the national scale. Name...
219 0 /
John Dorlon
Follow /25 Aug 2015 at 10:28pm / Toad for Oracle

How to connect to an Oracle Cloud Database

In my previous blog post, I described how to create an Oracle Cloud Database. Before we continue, you should have private key file. Whoever made the database should have given it to you. There are details about it in my previous blog post. After...
203 0 /