Discuss in the Community


Steven Feuerstein
Follow /4 Mar 2015 at 8:34pm / Oracle

Looking for Another Oracle Developer Advocate for SQL

The Oracle Developer Advocates team is responsible for helping users fully leverage their investment in Oracle Database and to promote the use of Oracle Database technologies for application developers, including SQL, PL/SQL, Application Express, Oracle...
86 0 /
Chris Shaw
Follow /4 Mar 2015 at 3:31pm / SQL Server

Tip # 5 – SQL Server Maximum Memory (Tips for SQL Server Performance and Resiliency)

This article is part 5 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #5: Not Setting a Maximum Memory Default configurations are...
84 0 /
Derik Hammer
Follow /4 Mar 2015 at 2:00pm / SQL Server

Running PowerShell in a SQL Agent Job

When creating a SQL Agent Job to execute a PowerShell script, you have to decide which way that you want the PowerShell to run. Depending upon which version of SQL Server that you are using and which job step type that you choose, you might be running...
73 0 /
Stuart Ainsworth
Follow /4 Mar 2015 at 2:00pm / SQL Server

(Personal) Kanban Myths: The Myth of The Process

Recently, my friend Joe Webb has posted some great resources on Personal Kanban on his Facebook timeline.  Joe’s an influential guy in the tech community (particularly the #SQLFamily ), so I’ve been excited about the flurry of emails and comments regarding...
79 0 /
Kenneth Fisher
Follow /4 Mar 2015 at 1:00pm / SQL Server

I want to blog but …

I don’t know how to get started. Pretty simple. There are a number of free blogging sites out there. Personally I use WordPress. All you need to do is go to http://www.wordpress.com and sign up for a free space. I have a blog but setting it...
86 0 /
Steven Feuerstein
Follow /4 Mar 2015 at 12:22pm / Oracle

Oh those tricky exception sections! Why won't it handle my error?

Fielded a question the other day from a frustrated PL/SQL developer. He included an exception handler for an exception that was being raised in his program, but the exception propagated out unhandled from the block anyway. What's with that ? To answer...
89 1 /
Follow /4 Mar 2015 at 6:14am / Oracle

Dealing with Crontab

Schedule tasks under Linux is an powerful procedure which is used by almost everyone, and to do this using program called cron. more about it here . Procedure : make a new text file, and enter this line in that text file like the below :- crontab myfirstjob...
101 0 /
Fernando Garcia
Follow /3 Mar 2015 at 11:39pm / Oracle

Gracias Toad World! / Thank you Toad World!

Este es un post muy cortito, pero muy importante para mí. Hoy me sorprendí muy gratamente al ingresar a Toad World y enterarme de que fui reconocido como Oracle Pro del mes de marzo. Me siento profundamente agradecido con Toad World...
173 0 /
Kellyn PotVin
Follow /3 Mar 2015 at 9:57pm / Oracle

RMOUG 2015 Training Days Review

I’m at HotSos Symposium 2015 speaking this week, so thought I would blog about the results of the conference I’m the director of and that finished up just two weeks ago.  I’m not admitting to being overwhelmed by OEM questions here,...
90 0 /
Ed Elliott
Follow /3 Mar 2015 at 6:25pm / SQL Server

Unit Test Sql Server Code

In part 3 of this series of blogs on "getting more agile" I am going to look at unit testing and why we need to do it. My code is perfect, I need no stinking tests Ah you are like me, my code is perfect as well, good point. blog end. ...
106 0 /
Ricardo Leka
Follow /3 Mar 2015 at 6:15pm / SQL Server

Powershell, Excel e SQL uma combinação excelente

Uma coisa muito legal em automatizar tarefas é a dificuldade que temos em planejar o que vai ser executado, a forma que vai ser executado e manter da forma mais genérica possível para garantir que vai funcionar na maior parte dos ambientes sem precisar...
80 0 /
Steven Feuerstein
Follow /3 Mar 2015 at 4:03pm / Oracle

Mining the Oracle Database for Cool Appdev Features

One of the key missions of the Oracle Developer Advocate (ODA) is to make sure our users realize how many great features for application developers are packed into Oracle Database. Sure, there's SQL and PL/SQL - the "big" appdev features...
99 0 /
Richard Douglas
Follow /3 Mar 2015 at 3:12pm / SQL Server

50 Shades of Brown – The Series

That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to tell you about something that is critically important to every business. But why Shades of Brown if it is critical? Everybody knows that it’s red alerts...
144 0 /
Follow /3 Mar 2015 at 3:00pm / Oracle

I’m William Reynolds and this is How I Work

William joined PeopleSoft in November of 1995 as a developer in the Inventory product. Since then he has worked in various roles within the FSCM pillar eventually landing in the Enterprise Architecture group where he straddles the world between PeopleTools...
84 0 /
Follow /3 Mar 2015 at 1:16pm / SQL Server

SSIS: Password Policy Rules Not Met When Creating Catalog

Last week I was at a client site showing them how to set up the Integration Services Catalog. We were walking through the steps in how to create it and we input the password into the Create Catalog configuration screen. It was a strong password, that...
86 0 /
Follow /3 Mar 2015 at 1:00pm / SQL Server

Interview with Brad Botz on Business Analysts

I recently met Brad Botz in a professional Facebook group we both belong to and found we we have much in common.  I really like databases and development, and Brad likes to read user’s minds.  Well not really, but see Brad is a Business Analyst...
164 0 /
Chris Webb
Follow /3 Mar 2015 at 1:00pm / SQL Server

Submit Your Feedback On BI Features In SQL Server V.Next

Following on from last month’s post on ideas for new features in SSAS Multidimensional, if you are interested in telling Microsoft what features you think should be added to the on-prem SQL Server BI tools in the next version you can do so here: http...
77 0 /
Follow /3 Mar 2015 at 8:16am / Oracle

Sort process depend on memory

top - display top CPU processes Once top starts, press F to switch to the sort field screen. Choose one of the fields listed by pressing the key listed on the left; you probably want N for MEMORY Done
95 0 /
Follow /2 Mar 2015 at 11:51pm / SQL Server

Why do We Have to Be at Risk? Enough is Enough!

When Do We Say Enough Is Enough? Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information of up to 80 million customer was stolen. It wasn’t anything about medical history taken, just all their customer’s...
103 0 /
Fernando Garcia
Follow /2 Mar 2015 at 11:06pm / Oracle

El análisis forense de un “abrazo mortal”

Este artículo está dedicado a Juan Dabarca y a todos los DBAs que están trabajando en Zaragoza, España. Para aprovecharlo mejor, es altamente recomendable leer mi post anterior titulado “ El abrazo mortal en Oracle ”...
179 0 /
Kevin Kline
Follow /2 Mar 2015 at 3:05pm / SQL Server

ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance

Don’t miss these great articles on SQLPerformance.com from the industry’s top experts: A Look At DBCC CHECKCONSTRAINTS and I/O Erin Stellato ( b | t ) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of...
95 0 /
Richard Douglas
Follow /2 Mar 2015 at 2:57pm / SQL Server

SQLBits XIV – Welcome to the UK

A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was something just for people from the UK has been transforming into something much larger, more multicultural and more engaging as the community...
93 0 /
Kenneth Fisher
Follow /2 Mar 2015 at 1:00pm / SQL Server

SQL Judo’s Monthly Challenge – March 2014 – Powershell something

Every month SQL Judo (Russ Thomas) ( b / t ) challenges us to do his Monthly DBA Challenge . I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For example...
107 0 /
Iggy Fernandez
Follow /2 Mar 2015 at 5:10am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 36: The sisters of the mother of all SQL antipatterns

SECOND WITCH. Fillet of a fenny snake, In the caldron boil and bake; Eye of newt, and toe of frog, Wool of bat, and tongue of dog, Adder's fork, and blind-worm's sting, Lizard's leg, and owlet's wing,— For a charm of powerful trouble...
1048 0 /
Deiby Gomez
Follow /2 Mar 2015 at 2:38am / Oracle

Indexes on Virtual Columns (Part 2)

This article is a continuation of the article "From the Concept to Internals: Indexes on Virtual Columns" where we saw how indexes are created on virtual columns and what is its behaviour since the value indexed is "dynamic" for the...
163 0 /