Discuss in the Community

Blogs

Deiby Gomez
Follow /30 Jan 2015 at 1:48pm / Oracle

Spreading RMAN Backups Across Multiple Disks

If you have multiple disks dedicated to Use them for Backups, why to wait until the first disk get full in order to use the second one?. With RMAN you can use them at the same time using the spreading feature of RMAN. In this article I will show you how...
74 0 /
Tracy McKibben
Follow /30 Jan 2015 at 1:00pm / SQL Server

Friday Followup For January 30, 2015

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 Building (for FREE) a Virtual Server for SQL Demos...
66 0 /
Project Lucy
Follow /30 Jan 2015 at 6:05am / SQL Server

Version 5 of the Spotlight Essentials Plug-in for SQL Server Management Studio

Version 5 of the Spotlight Essentials Plug-in for SQL Server Management Studio includes real-time Performance Health. This powerful new feature examines the wait events occurring on an instance to determine its overall health. New features in Version...
39 0 /
Kevin Stern

SQL Tuning - Let SQL Optimizer Do The Work For You

The SQL Tuning Problem If you ask most DBA's what their #1 pain point is the likely response would be database performance issues. The quickest and least expensive way to solve database performance issues is to try and tune the database workload...
84 0 /
Brad Wulf
Follow /29 Jan 2015 at 11:44pm / Toad for Hadoop - Blog

How-To: Add character delimited data to HDFS and then prep it for querying with Hive

So not all data going into Hadoop is your garden variety rigidly structured, highly normalized relational data from Oracle. ***for the situations where this is the case, this blog post describes how to use Toad for Hadoop to import Oracle data into HDFS...
18 0 /
Jen McCown
Follow /29 Jan 2015 at 8:15pm / SQL Server

Minion Reindex 1.1 Release (and re-release)

We released Minion Reindex version 1.1 last week. The changes are fairly small: Made sure Minion Reindex handles all nonstandard naming (e.g., object names with spaces or special characters). Added support for Availability Group replicas. (Basic AG support...
45 0 /
Deiby Gomez
Follow /29 Jan 2015 at 6:03pm / Oracle

Mastering Silent Mode: Installing, Configuring and Creating a WebLogic 12c Cluster

Sometimes we don't have access to GUIs or perhaps you really like to install and configure using silent mode, if so, you could be interested in this article. In this article I will install JDK 7 for WebLogic 12.1.2 on Oracle Linux 6.4 x86-64. I will...
114 0 /
Colleen Morrow
Follow /29 Jan 2015 at 3:00pm / SQL Server

Exam Prep 70-463: Data Flow Transformations

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and...
102 0 /
Sten Vesterli
Follow /29 Jan 2015 at 11:01am / Oracle

Continuous Integration for Database Development

Many organizations are setting up Continous Integration (CI) servers like Hudson to continually build their application (many times a day, sometimes after each checkin to the version control system). This works fine for Java projects, and most documentation...
45 0 /
Dinesh Asanka
Follow /29 Jan 2015 at 5:29am / SQL Server

SQL Server String Functions Cheat Sheet

SqlBak.com presents you a free SQL Server String Functions Cheat Sheet. http://sqlbak.com/blog/wp-content/uploads/2015/01/TSQL-STRING-FUNCTIONS-CHEAT-SHEET.pdf http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
81 0 /
Paul Turley
Follow /29 Jan 2015 at 2:42am / SQL Server

Power BI Workshop Videos

I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this year.  The workshop is available from an hour-long quick demo to a full-day, hands-on workshop with a hosted lab environment in the cloud. ...
53 0 /
Fernando Garcia
Follow /28 Jan 2015 at 11:03pm / Oracle

Como resolver el problema del umpersand (&) en SqlPlus

Un problema típico con el que se topan todos los usuarios de SqlPlus en algún momento de sus vidas es el del umpersand (&) . ¿En qué consiste el problema del umpersand (&) ? Supongamos que tenemos una tabla de empresas...
122 0 /
Iggy Fernandez
Follow /28 Jan 2015 at 9:00pm / Oracle

OT: Pictures from the NoCOUG winter conference at Oracle HQ

There were 130 attendees at the NoCOUG winter conference on January 27 at the Oracle conference center in Redwood City. There was a fantastic breakfast spread. The registration desk was a marvel of neatness. Delphix sent its most photogenic...
271 0 /
datachick
Follow /28 Jan 2015 at 3:45pm / SQL Server

Join #TeamData for a Virtual Pi Day 5k

  Register You can join #TeamData on a virtual run or walk any time between 12-15 March. A virtual races means you run it wherever you want, whenever you want during those days.  You can even split your runs/walks over those days. HOW...
96 0 /
Steven Feuerstein
Follow /28 Jan 2015 at 3:37pm / Oracle

Meet (See) the Oracle Database Evangelist Team

We are all out at Oracle Headquarters for meetings this week and yesterday at the BIWA Summit, I was fortunate enough to: Do a YesSQL presentation for the NoCOUG user group. Have Tom Kyte share his thoughts on NoSQL -> SQL -> Not Only SQL ->...
105 1 /
Derik Hammer
Follow /28 Jan 2015 at 2:00pm / SQL Server

Active sessions and block duration

As a DBA, we all need the ability to take a quick glance at the currently active processes on our servers. A lot of times we do this during a problem such as transaction blocking. The first tool that normally comes to mind for this type of investigation...
52 0 /
Kenneth Fisher
Follow /28 Jan 2015 at 1:00pm / SQL Server

A quick email interview of Pass President Thomas LaRock

Back in December I had the thought that it would be fun to do an email interview with someone. As I thought about it Thomas LaRock ( b / t ) sounded like a good choice since he has been working in the community for quite a while and is our current Pass...
54 0 /
datachick
Follow /28 Jan 2015 at 6:52am / SQL Server

Join #TeamData for the Portland Half Marathon

If you’ve been following me on Twitter ( @datachick ), you know I’ve been checking some races off my bucket list.  I apologize for all those tweets, by the way…but I also loved the fact that people could Tweet to me while I ran.  It’s so helpful...
67 0 /
Paul Turley
Follow /28 Jan 2015 at 4:26am / SQL Server

New Power BI Preview and Pricing

Some exciting announcements were made today about the new Power BI cloud-based business analytics service.  Today Power BI is an add-on service for Office 365 that requires an enterprise-level license – about $50 per user per month.  Data transformation...
73 0 /
Kellyn PotVin
Follow /28 Jan 2015 at 12:29am / Oracle

Enterprise Manager and Services, Part I

The term “Service” is used to represent numerous objects within Enterprise Manager 12c.  Although the most common reference to the term is related to the Oracle Management Service, (OMS), in this blog post, we are going to drill down and refer...
52 0 /
Fernando Garcia
Follow /27 Jan 2015 at 11:03pm / Oracle

Mantén tu base sana y evita inyecciones de SQL.

Hace algunos meses, más precisamente en octubre de 2014, el Grupo de Usuarios Independientes de Oracle (IOUG) publicó bajo el titulo "DBA - Superhéroe de la seguridad" los resultados de una encuesta sobre seguridad de los...
162 1 /
sqlkris
Follow /27 Jan 2015 at 1:00pm / SQL Server

What is a Database Trigger?

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide  Getting Started Using SQL Server . What is a Database Trigger? A...
140 0 /
zaheer.appsdba
Follow /27 Jan 2015 at 12:48pm / Oracle

Creating virtualbox shared folder on Oracle Solaris 11 Guest

This article demonstrates steps for enabling a windows host shared folder to oracle solaris 11 guest operating system in a virtualbox environment. Before reading further please make sure that "guest additions" are already Installed and configured...
111 0 /
Dinesh Asanka
Follow /27 Jan 2015 at 12:19pm / SQL Server

SQL Server 2014 Security Enhancements : User Object Permissions

In many database systems, it is a requirement to grant read permission for all databases. To achieve this, there is no other way but grant read permission to each and every database. Read more http://www.sql-server-performance.com/2015/sql-server-2014...
65 0 /
Chris Shaw
Follow /27 Jan 2015 at 12:00pm / SQL Server

Tip # 3 – Maintain your SQL Server

Top 10 Tips for SQL Server Performance and Resiliency This article is part 3 of 10 in a series on the most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I see and is...
64 0 /