Discuss in the Community


Steven Feuerstein
Follow /19 Sep 2014 at 9:24pm / Oracle

Use COLUMN_VALUE when selecting from scalar table function

Received this question today: I don’t have a problem to select from collection when collection is based on objects with columns/attributes. What about a collection defined as: TYPE list_of_numbers_t IS TABLE OF NUMBER; What would be the column name when...
14 0 /
Chris Shaw
Follow /19 Sep 2014 at 7:57pm / SQL Server

Avoid Technology Debt

Can you afford to miss this free training class? See the end of this post on how to sign up. Have you ever been in a situation where you are working on implementing a SQL Server based solution and you need to make a decision about the technology that...
20 0 /
Jason Strate
Follow /19 Sep 2014 at 5:00pm / SQL Server

Reblog: September 12 to September 18

Photo credit – Jenn and Tony Bot Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s...
12 0 /
Follow /19 Sep 2014 at 4:01pm / NoSQL

Best Software Options for Staying Safe Online

It’s no exaggeration to say that getting on the internet these days can be dangerous at times. Every day there seem to be new headlines of viruses infecting computers or sensitive personal information being stolen. The statistics tend to back up...
10 0 /
Jen McCown
Follow /19 Sep 2014 at 2:42pm / SQL Server

Wendy Pastrick and Grant Fritchey: Optimists in Action #passvotes

If I had a favorite kind of politician, it would be the kind that, when asked a question, sighs tiredly, and then regains their gleam of manic optimism as they begin to speak about the path ahead. Given that, my two favorite politicians right now are...
22 0 /
Jorge Segarra
Follow /19 Sep 2014 at 2:30pm / SQL Server

EPM Framework v4 Released!

The Enterprise Policy Management Framework (EPMF) team is proud to announce the updated release of “Enterprise Policy Management Framework 4.0 for project EPMFramework. This is a major release with lots of performance tweaks and The EPM Framework...
16 0 /
Tracy McKibben
Follow /19 Sep 2014 at 1:00pm / SQL Server

Friday Followup For September 19, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Don’t Get Slimed By Bad Parameter Sniffing...
18 0 /
Sten Vesterli
Follow /19 Sep 2014 at 7:20am / Oracle

Larry Ellison stepping down as Oracle CEO

Waiting for the usual Oracle OpenWorld surprises, we just got one that I at least was not expecting: Larry Ellison is stepping down as CEO of Oracle . For better or worse, Larry has been synonymous with Oracle Corporation for decades, so it will be...
30 0 /
Natik Ameen
Follow /19 Sep 2014 at 1:44am / Oracle

Larry Ellison Stepping Down as Chief of Oracle

Larry Ellison, CEO of Oracle is finally stepping down! He’s not leaving Oracle but as part of succession planning will be moving into the Executive Chairman role. He is one of the co-founders of Oracle and started the enterprise in 1977. The CEO...
39 0 /
Kellyn PotVin
Follow /19 Sep 2014 at 1:25am / Oracle

Oracle Open World Schedule

I will be in San Francisco a little early this year and as I’m not longer an ACE Director, it’s to attend the IOUC, ( International Oracle User Conference ) at Redwood Shores on Sept. 25th and 26th.  I’ll be representing RMOUG for the...
38 0 /
Fernando Garcia
Follow /18 Sep 2014 at 11:27pm / Oracle

Algunos recursos excelentes para aprender el lenguaje R.

Hemos instalado el entorno R y la IDE RStudio . Estamos en condiciones de comenzar a dar los primeros pasos con el lenguaje. ¿Qué recursos podemos encontrar en Internet para acelerar nuestro camino hacia el dominio del lenguaje R? Voy a...
137 0 /
Chris Webb
Follow /18 Sep 2014 at 9:17pm / SQL Server

Handling Data Source Errors In Power Query

Recently I was asked an interesting question by Ondra Plánička in the comments of a blog post : how can you handle errors caused by unavailable or missing data sources in Power Query? Let’s imagine you are loading a csv file like this one into Excel...
33 0 /
Josh Howard
Follow /18 Sep 2014 at 7:33pm / Toad Data Point

Analytical detectives — Finding clues that can generate new insights

Do you require solid evidence before making business decisions? Do you like to carry a magnifying glass wherever you go? Maybe you’re an analytical detective . In my previous post , I explained that the research group Aberdeen had surveyed 650...
16 0 /
Dan Hotka
Follow /18 Sep 2014 at 6:18pm / Oracle

Shedding Light on Sub Queries and QBlock Name

Hi! Shedding light on Sub Queries Are you aware that I provide Dell with an article each month as well? I’ve been working on an explain plan series and this months article goes into great detail on sub-query processing using a technology...
44 0 /
Follow /18 Sep 2014 at 3:58pm / SQL Server

Tips for First-Timers Attending PASS Summit 2014

Are you attending PASS Summit 2014 ? If this is your first year at the conference and you’re not sure what to expect, then you are in luck! We are taking the stress and hard work out of conference prep with a simple snap shot of what you need to...
38 0 /
Follow /18 Sep 2014 at 3:45pm / SQL Server

Video: Walk & Talk #002 – RTO

Recovery Time Objective (RTO) What is it and why does it matter? I am actually walking this time! Join me to walk & talk through what the RTO (Recovery Time Objective) is with regards to SQL Server. Location: American Chestnut Land Trust –...
39 0 /
Steven Feuerstein
Follow /18 Sep 2014 at 3:31pm / Oracle

RTFM? KISS? Comment? Whatever, just get the code to work right!

We've been hitting a snag of late with new registrants at the PL/SQL Challenge . As with many sites, to ensure that a person's email is not being hijacked, we send an email with a verification URL. It was working for quite a while, but then we...
45 0 /
David Dye
Follow /18 Sep 2014 at 2:35pm / SQL Server


A common question is what is the difference between truncating a table and deleting a table.  The short answer is that they both do the same thing, but in different ways.  So consider that you have a table that contains 1,000,000 rows and you need to...
43 0 /
Chris Yates
Follow /18 Sep 2014 at 1:17pm / SQL Server

Passwords – A T-SQL Tuesday Topic

Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you by Sebastian Meine Blog | Twitter . Although the time frame has passed I would be amiss if I didn’t continue on my journey...
34 0 /
Follow /17 Sep 2014 at 11:27pm / Oracle

Eight times faster search experience ... same hardware, software, network

We've recently worked on improving the search experience for one of our clients, who use an Enterprise Content Management System to store their documents. Yet again we were able to achieve some impressive gains in user productivity without having...
36 0 /
Craig Mullins
Follow /17 Sep 2014 at 8:10pm / IBM DB2

Plan to Attend IBM Insight 2014

The IBM Insight conference is just around the corner and if you care about DB2, Big Data, Analytics, data warehousing, or really, anything at all about enterprise data, then Las Vegas is the place to be the week of October 26 thru 30, 2014. But what is...
17 0 /
Larry Leonard
Follow /17 Sep 2014 at 7:08pm / SQL Server

CMS: List All Jobs that Do Not Notify on Failure

Using CMS , we can get a list of all the Jobs on all the servers that have no email (nor page, nor netsend) notification set up for Failure. This can be useful to find Jobs that are silently failing, and even Jobs that are no longer in use. -- Find Jobs...
56 0 /
Larry Leonard
Follow /17 Sep 2014 at 6:22pm / SQL Server

CMS: List Jobs not Writing to the Windows Event Log

Using CMS , we can get a list of all the SQL Agent Jobs that aren't writing to the Windows Event Log upon failure, and set them to do so. -- Check for Jobs that aren't writing to the Event Log. declare @JobName sysname -- 0 - Never -- 1 ...
33 0 /
David Dye
Follow /17 Sep 2014 at 6:13pm / SQL Server

Why is My Log File so Big??

This is probably one of the most common posts that I see on the MSDN forums and hear from students.  The most common answer is that the database has been set to full or bulk logged recovery model and a transaction log backup has not been completed.  So...
34 0 /
Follow /17 Sep 2014 at 5:06pm / Oracle

ASM Diskgroup shows USABLE_FILE_MB value in Negative

Today while working on ASM diskgroup i noticed Negative value for USABLE_FILE_MB. I was little surprised as it has been pretty long that i worked on ASM. So i started looking around for blogs and mos docs and found few really nice one around. A negative...
35 0 /