Discuss in the Community


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...
23 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...
82 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...
50 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...
112 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...
109 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...
110 0 /
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...
139 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...
132 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...
105 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...
32 0 /
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 .
93 0 /
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...
56 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...
68 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...
136 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...
52 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...
51 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...
135 0 /
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...
204 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...
173 0 /
John Dorlon
Follow /25 Aug 2015 at 10:27pm / Toad for Oracle

How to create an Oracle Cloud Database

Oracle's got a new thing called "Database Cloud Service" which, as the name implies, is just a database out in the cloud somewhere. It's hosted on an Oracle Unix server and you have complete control over it. Remote SQL*Net connections...
144 0 /
Steven Feuerstein
Follow /25 Aug 2015 at 10:21pm / Oracle

Table Functions, Part 5b: Table Functions vs Pipelined Table Functions

Last week, I published my first post in the Table Function series on pipelined table functions. I included this advice at the top of the post: Here's my first piece of advice regarding this interesting and in many ways unique (within PL/SQL) feature...
159 0 /
Jen McCown
Follow /25 Aug 2015 at 3:00pm / SQL Server

Assigned reading: FREEPROCCACHE

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one of those days. I’d like you to read Grant Fritchey’s excellent piece, “Targeted Plan Cache Removal“, for this...
170 0 /
Dinesh Asanka
Follow /25 Aug 2015 at 3:00pm / SQL Server

Moving Your SQL Infrastructure to Microsoft Azure

Just Another Big Business (JABB) Systems International is a fictional, 2,400-employee business with global offices. It manufactures security equipment, such as surveillance systems, alarms, bulletproof glass and cars, safes and related technologies. Its...
170 0 /
Derik Hammer
Follow /25 Aug 2015 at 2:00pm / SQL Server

Lone DBA, Lemming or Master of your Domain

Are you a lone lemming or the master of your domain? Many organizations hire only one database administrator. This lone DBA is in a unique position which can be both rewarding and challenging. I have spent years as a lone DBA and am able to compare...
157 0 /
Craig Mullins
Follow /25 Aug 2015 at 2:00pm / IBM DB2

Influencing the DB2 Optimizer: Part 6 - Using Optimization Hints

So far we have discussed several standard methods of influencing DB2’s access path selection -- in the first 4 parts of this series ( 1 , 2 , 3 , 4 ) -- as well as updating DB2 Catalog statistics in part 5 . But there is another tool in your DBA arsenal...
197 0 /