Discuss in the Community

Blogs

Deiby Gomez
Follow /1 Oct 2014 at 2:28am / Oracle

Oracle 12c nueva cláusula “REPLACE DISK”

Mientras leía en un blog sobre Flex ASM me encontré con una nota que decia que en Oracle 12c existe una nueva cláusula "REPLACE DISK" con la cual se puede reemplazar un disco con otro en una misma sentencia. En las versiones...
8 0 /
Ryan Adams
Follow /30 Sep 2014 at 10:03pm / SQL Server

PASS 24HOP AlwaysOn Questions Answered

I presented a session titled “SQL Server AlwaysOn Quickstart” on September 10th for the 24 Hours of PASS event.  You can view the session recording HERE if you missed it.  The session was a preview of the full session I will be presenting...
22 0 /
DuncanDavies
Follow /30 Sep 2014 at 7:41pm / Oracle

Larry’s OOW Keynote on the future of Oracle Applications

Introduction Although there had been many analyst and Oracle ACE briefings for much of the preceding week, Sunday night was the 'proper' opening for Oracle OpenWorld 2014. It kicked off with Larry's first keynote of the conference. (He...
25 0 /
Johannes Ahrends
Follow /30 Sep 2014 at 6:42pm / Toad for Oracle

Toad – My DBA Tool

For more than 20 years my profession is the Oracle database administration. Starting in the early 90 th on DEC VMS with a VT-100 terminal I’ve worked with many different tools. SQL*Plus is of course the most important one because it’s available...
60 0 /
James Serra
Follow /30 Sep 2014 at 4:00pm / SQL Server

IaaS, PaaS, and SaaS explained

You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS , Saas .  Cloud providers offer their services according to these three fundamental models: Infrastructure-as-a-service (IaaS) This is the most basic model...
40 0 /
WaterOx
Follow /30 Sep 2014 at 3:00pm / SQL Server

Video: Walk & Talk #003 – RPO

What is the RPO? And why does it matter? Join me as I walk through Jefferson Patterson Park’s Indian village and discuss the Recovery Point Objective and what it means is respect to SQL Server. Location: Jefferson Patterson Park More info...
30 0 /
Porus Homi Havewala
Follow /30 Sep 2014 at 2:50pm / Oracle

Oracle Enterprise Manager–Based Patching

Friends, Hope those of you who could make it, are enjoying Oracle Open World (OOW). An interesting OOW session my colleague Hari Srinivasan pointed out for Wednesday Oct 1 this week: Databases to Oracle Exadata: The Saga Continues for Oracle Enterprise...
25 0 /
karen.r.morton
Follow /30 Sep 2014 at 2:40pm / Oracle

Nulls and execution plan operation options

A while back, I was asked to take a look at a situation where a COUNT(*) query was using full table scan instead of an Index Fast Full Scan. The scan of the index would've been faster and used less resources but even with a hint, the full scan was...
25 0 /
Richard_RP
Follow /30 Sep 2014 at 11:04am / SQL Server

Service Pack – SQL Server 2008 R2 SP3

Despite the fact that end of mainstream support ended for SQl Server 2008 R2 earlier this year, Microsoft have released SQL Server 2008 R2 Service Pack 3. SQL Server 2008 R2 SP3 is available for download at the SQL Server 2008 R2 SP3 download page...
34 0 /
Jen Stirrup
Follow /30 Sep 2014 at 7:59am / SQL Server

Data Analysts Toolkit Deck 1: Overview of Data Visualisation and Power BI

My slides from my Preconference training at SQLBits and SQLServerDays. In this module, we will look at an overview of theory and scientific evidence about data visualisation. Understanding the ‘why’ can help to make us better at the ‘how’, regardless...
43 0 /
DuncanDavies
Follow /29 Sep 2014 at 10:23pm / Oracle

PeopleSoft and Shellshock

As many will have no doubt heard, there’s a new vulnerability that has been spotted, and there are already exploits for it in the wild. The vulnerable systems are those running Bash – so Windows machines are safe, it’s just Unix/Linux...
37 0 /
rickdelgado
Follow /29 Sep 2014 at 9:15pm / NoSQL

How Multi-Tiered Storage Could Solve Your Storage Challenges

There is little question how important data has become for businesses hoping to develop new strategies that outmatch the competition. Data is being generated at an incredible pace, and collecting it has never been more vital than it is now. But with any...
16 0 /
Dan Hotka
Follow /29 Sep 2014 at 6:41pm / Oracle

What is Compression? - Part 2

What is Row Compression - continued Hi! Last week we discussed Oracle’s row compression feature. I illustrated how the BASIC and ADVANCED row compression works and where they should be used. Last week we reviewed the following...
36 0 /
karen.r.morton
Follow /29 Sep 2014 at 4:49pm / Oracle

Endorsements on LinkedIn (a bit off topic)

I joined LinkedIn a long time ago as it was all the rage and lots of colleagues were sending me connection requests. I've tried to keep my profile fairly up to date. I've even had a couple of folks reach out to me via LinkedIn. But even in those...
45 0 /
gilallouche
Follow /29 Sep 2014 at 4:46pm / NoSQL

Create a data-driven culture in your enterprise through simple steps

Creating a data-driven culture within an enterprise isn’t without its challenges. Knowing what steps to take to change the culture of your organization will help you move forward and reach your goals. Step back - IT managers need to take time...
10 0 /
Mike Walsh
Follow /29 Sep 2014 at 1:57pm / SQL Server

DBA Reminders from an FAA Fire

Last Friday a long time employee set fire to the FAA’s Chicago Control Center. You can read about the fire and the 2,000+ flight cancellations that resulted   here  and  here . Keeping with the spirit of ripping lessons from headlines like I did...
50 0 /
Kenneth Fisher
Follow /29 Sep 2014 at 1:00pm / SQL Server

Database default locations

One of the options you had when installing your instance was setting some default file locations. Defaut data file location Default log file location Default backup file location If you are new to installing SQL Server (and even if you aren’t...
42 0 /
Rohit Garg
Follow /29 Sep 2014 at 10:44am / SQL Server

SQL Server 2008 R2 Service Pack 3 Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008 R2 Service Pack 3 contains all the hotfixes released since the initial release...
46 0 /
Rohit Garg
Follow /29 Sep 2014 at 10:38am / SQL Server

SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be

Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the issue, Seems to be a WMI error :- 1) If using Window Server 2008 &...
38 0 /
Chris Webb
Follow /29 Sep 2014 at 9:30am / SQL Server

Advanced Options For Loading Data From SQL Server With Power Query

Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example). However there are a few advanced options, not all of which are currently shown in the online help although they are in...
54 0 /
Deiby Gomez
Follow /29 Sep 2014 at 12:40am / Oracle

PCTFREE is ignored in Indexes

In my last article I asked you the following question: do you know that PCTFREE is ignored in indexes after the creation? Well, in this blog post I will show you that indeed this parameter is ignored after the index creation. I will use the following...
92 0 /
Jen Stirrup
Follow /29 Sep 2014 at 12:08am / SQL Server

Jen's Diary: Figuring it out - Virtual Chapter Pathways

Ok. Here goes. Disclaimer: I don't speak on behalf of PASS, only the Exec Committee can do that. I want to thank everyone, just from myself, for all their patience and support for the past week. You know who you all are, and I wanted to say thank...
43 0 /
zaheer.appsdba
Follow /28 Sep 2014 at 7:55pm / Oracle

Configure IPS Repository on Oracle Solaris 11.2

Its been some time now Oracle released new version of Solaris "Oracle Solaris 11.2". There are litlle changes in the configuration of repository on Solaris 11.2 compare to Solaris 11.1. In this article i will demonstrate configuration of Local...
35 0 /
Iggy Fernandez
Follow /28 Sep 2014 at 5:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 11–22)

Previous installment: The Final Exam! (Part III We Don’t Use Databases; We Don’t Use Indexes) First installment: DON’T PANIC Before continuing with this series, please take a minute to read any installments that you may have missed...
88 0 /
Iggy Fernandez
Follow /27 Sep 2014 at 5:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 22: The Final Exam! (Part III We Don’t Use Databases; We Don’t Use Indexes)

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them I'll have a long beard by the time I read them” — Whiskers and Rhymes by Arnold Lobel Previous installment: The Final...
195 0 /