Discuss in the Community

Blogs

Natik Ameen
Follow /23 Oct 2014 at 5:37am / Oracle

Configure Oracle Exadata Write Back Flash Cache

In addition to improving read I/Os, Oracle Exadata Write back flash cache also provides the ability to cache write I/Os directly to PCI flash. Exadata storage software version 11.2.3.2.1 is the minimum version required to use write back flash cache. Grid...
20 0 /
Jason Brimhall
Follow /22 Oct 2014 at 10:16pm / SQL Server

Database Ghosts

Recently you may have seen my first article on this topic over at SQL Solutions Group.  If not, here is the link so you can read that article first before proceeding here.  This article is intended as a first of two part follow-up to that article . ...
40 0 /
DuncanDavies
Follow /22 Oct 2014 at 10:01pm / Oracle

What’s coming in Taleo 14B

The release notes are out, and the other night I attended a webinar showing the highlights of the Taleo Enterprise Edition 14B release (provisionally due on November 24th). It was a really worthwhile hour and the presenter – who I believe was Fabrice...
32 0 /
John Weathington
Follow /22 Oct 2014 at 4:04pm / Toad BI Suite

We Don't Support That Here

Introduction I was sitting in my hotel room last night frustrated with the speed of my Internet connection, so I called the front desk to upgrade my bandwidth. Unfortunately my problem was over their head, so they gave me the number to their IT support...
12 0 /
David Fitzjarrell
Follow /22 Oct 2014 at 3:37pm / Oracle

Memory Improvement

Oracle 12c (version 12.1.0.2) offers the option of using in-memory processing to speed things along. Called the In-memory option it’s installed when you install the 12.1.0.2 software. Using it can make a considerable difference in processing speed...
31 0 /
Derik Hammer
Follow /22 Oct 2014 at 3:13pm / SQL Server

Backup testing with PowerShell

This week I released a two part blog series on testing your backup files and reporting on the results in an automated fashion. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your organization...
38 0 /
Kenneth Fisher
Follow /22 Oct 2014 at 12:00pm / SQL Server

Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures . In a similar situation to the questioner let’s say we have a Baseball team. There are teams and players. A player can...
31 0 /
Richard To
Follow /22 Oct 2014 at 6:58am / SQL Optimizer for Oracle

SQL Rewrite to Twist Cost Estimation

There are mainly three problems that database SQL optimizer cannot find the best way to process your SQL statements. Cost estimation error The cost estimation error is not only caused outdated statistics, but lots of other factors that a SQL's...
17 0 /
Fernando Garcia
Follow /21 Oct 2014 at 11:16pm / Oracle

Curiosidades Oracle; el DISCONNECT que no desconecta.

Para comprender esta curiosidad de la base de datos Oracle necesitamos introducirnos en el mundo de las sesiones y conexiones. ¿Qué es una sesión de base de datos? Una sesión de base de datos se define como una entidad...
108 0 /
Paul Turley
Follow /21 Oct 2014 at 6:01pm / SQL Server

SQL Server Upgrade Preconference at PASS Summit 2014

Please join me and my associates for an all-day SQL Server Upgrade workshop on November 3rd If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. Join John Martin, Sr. Technology...
7742 0 /
Dan Hotka
Follow /21 Oct 2014 at 4:56pm / Oracle

Simple Index Tips

This week I have a collection of simple index tips I’d like to share. I am a strong believer of rebuilding indexes when there has been some DML on the table objects. Set the PCTFREE very low so the blocks fill. The idea here is to use the...
46 0 /
Steven Feuerstein
Follow /21 Oct 2014 at 1:06pm / Oracle

The PL/SQL Whisperer

[oreiginally published at FeuerThoughts in December 2011] I spent two days in Berlin, training 25 developers at an event sponsored by DOAG . Then I headed over to the Netherlands to spend a couple of days with 37 developers at an AMIS -sponsored training...
51 0 /
Stuart Ainsworth
Follow /21 Oct 2014 at 1:00pm / SQL Server

#SQLPASS–Data Professionals?

So, in my last post, I described the financial pressures of community building; two companies benefit from building a community organization.  I’ve tried to stay away from assumptions, but I am assuming that their influence must factor into the Board...
55 0 /
Deiby Gomez
Follow /20 Oct 2014 at 9:18pm / Oracle

Recreate controlfile from notepad

Sometimes you see that all the controlfiles in your databas are corrupted and you don't have backup and the instance is down. When that happens you have to use a controlfile template in order to recreate the controlfile but also to know where the...
197 2 /
Jen McCown
Follow /20 Oct 2014 at 5:12pm / SQL Server

Minion Reindex arrives this Friday!

The MidnightDBA team is announcing the release of a new, free index maintenance solution for SQL Server: Minion Reindex by MidnightDBA.  We designed Minion Reindex to solve all of the reindexing headaches we’ve experienced at dozens and dozens of client...
147 0 /
Jason Strate
Follow /20 Oct 2014 at 3:00pm / SQL Server

Last Weeks Top “Reading” Links #105

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” ( so exciting ), follow me on  twitter  ( @StrateSQL ).  And see these throughout the day as I tweet out links of things I find interesting...
40 0 /
Stuart Ainsworth
Follow /20 Oct 2014 at 1:10pm / SQL Server

#SQLPASS–Who’s Making It Rain?

  As promised in my previous post ( #SQLPASS–Good people, bad behavior… ), I’d like to start diving in to some of the controversies that have cropped up in the last year and critically analyze what I consider to be “bad decisions”.  This...
141 0 /
Rohit Garg
Follow /20 Oct 2014 at 12:56pm / SQL Server

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically. Steps to Add Database File on Database...
100 0 /
Kenneth Fisher
Follow /20 Oct 2014 at 12:00pm / SQL Server

Update to “The clustered index columns are in all of the non clustered indexes.”

I certainly hadn’t planned on creating a part two of this post but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete. So I did some additional testing, confirmed a few things with Paul Randal ( b /...
48 0 /
Jen Stirrup
Follow /20 Oct 2014 at 10:38am / SQL Server

Future Decoded – I’m speaking on machine Learning

I’m speaking at Future Decoded, at the same event as Professor Brian Cox , Sir Nigel Shadbolt (Co-founder & Chairman, ODI Open Data Institute), Or Arbel, (CEO, Yo), Michael Taylor (IT Director, Lotus F1 Team), Kenji Takeda, Microsoft Research...
49 0 /
Chris Webb
Follow /19 Oct 2014 at 10:37pm / SQL Server

Sentiment Analysis In Excel With Azure Machine Learning And Power Query

You may have seen Joseph Sirosh’s blog post last week about the ability to publish Azure Machine Learning models to the Azure Marketplace, and that MS have published a number of APIs there already. There’s a new Excel add-in that can be used with these...
75 0 /
Porus Homi Havewala
Follow /19 Oct 2014 at 7:32am / Oracle

Managing Oracle Database 12c with Enterprise Manager – Part IX

We are discussing the management of Oracle Database 12c via Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at how easy it was to set up Oracle Data Redaction for a 12c database using Enterprise Manager - this capability...
53 0 /
Sten Vesterli
Follow /18 Oct 2014 at 7:01pm / Oracle

Oracle Forms 12c

At Oracle OpenWorld, Oracle confirmed that there will be a Forms 12c released "sometime in 2015." Of course, they also show a slide saying that they aren't really promising anything. Michael Ferrante, the Oracle Forms Principal Product...
97 0 /
Mike Smithers
Follow /18 Oct 2014 at 6:01pm / Oracle

Going dotty – Generating a Filename containing a parameter value in SQL*Plus

As I have alluded to previously, I was not born in the UK. Nope, my parents decided to up-sticks and move from London all the way to the other side of the world, namely Auckland. Then they had me. Then they came back. To this day, they refuse to comment...
69 0 /
Cristian Molaro
Follow /18 Oct 2014 at 3:29pm / IBM DB2

What could go wrong with your fenced user ID?

Suddenly, your db2 stored procedures and user defined functions are failing. This example shows a failure when calling a user written stored procedure. ============================================================================ Run: CRIS.SPC733A(CHAR...
168 0 /