Discuss in the Community

Blogs

Sten Vesterli
Follow /30 Oct 2014 at 4:49pm / Oracle

We don't need Pre-Production and Test Anyway

The ongoing legal battle between Oracle and Cover Oregon about Oregon's failed Obamacare system keeps turning up interesting lessons. It seems that Cover Oregon actually asked Oracle to run only a production environment without any pre-production...
84 0 /
Larry Leonard
Follow /30 Oct 2014 at 4:00pm / SQL Server

Two Simple Ways to Find Last SQL Server Restart

The first command below will tell you the last time the SQL Server service was started. The second will tell you the last time the server itself was restarted. -- Format will be: 2013-01-19 14:13:53.243 select sqlserver_start_time from sys.dm_os_sys_info...
21 0 /
Ashish Banga
Follow /30 Oct 2014 at 1:24pm / SQL Server

How to Configure Search in SharePoint 2013 || Configure Search Topology in SharePoint 2013

Hello Friends, I was getting lot of responses on blogs and mails. It will be difficult to cover all at once . So covering today the latest one “How to Configure Search in SharePoint 2013” and in Standalone server. Microsoft is focusing more and...
20 0 /
sqlkris
Follow /30 Oct 2014 at 12:00pm / SQL Server

Get Ready to Learn SQL Server: 17. How to use the Intersect Operator

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 . How to use the Intersect Operator...
23 0 /
derekewilson
Follow /30 Oct 2014 at 11:49am / SQL Server

SQL Pass Summit 2014

Next week I will be in Seattle for the 2014 SQL Pass Summit event.  If you are involved in projects that leverage the Microsoft SQL Server stack this is a great conference to attend. If this is your first time going and would like some tips on making...
24 0 /
Cristian Molaro
Follow /29 Oct 2014 at 9:02pm / IBM DB2

DB2 11 for z/OS: Top 11 features, a year later

DB2 11 for z/OS was announced about a year ago with a long and promising list of new features, changes, and improvements. I have been actively involved with DB2 11 in various ways since its Early Support Program. But I know that, as with every new...
89 0 /
gilallouche
Follow /29 Oct 2014 at 8:59pm / NoSQL

How Much is Your Data Worth?

There is no doubting the incredible value of big data in today’s national and global economy. This new technology has taken dramatic strides in the last few years, and we are seeing numerous positive effects from its implementation across a variety...
20 0 /
Kellyn PotVin
Follow /29 Oct 2014 at 8:09pm / Oracle

Metric Thresholds and the Power to Adapt

Metric thresholds have come a long way since I started working with OEM 10g.  I remember how frustrating it could be if an ETL load impacted the metric values that had to be set for a given IO or CPU load for a database when during business hours, a much...
53 0 /
Steven Feuerstein
Follow /29 Oct 2014 at 5:20pm / Oracle

Dinodate, PL/SQL as Scripting Language Liberator, watch the show!

As I mentioned in a previous post , I had an awful lot of fun with Christopher Jones doing our PL/SQL: The Scripting Language Liberator talk at OOW. PL/SQL: The Scripting Language Liberator : While scripting languages go in and out of favor, Oracle Database...
45 0 /
Iggy Fernandez
Follow /29 Oct 2014 at 5:00pm / Oracle

OT: Oracle Trivia Quiz

All the answers to the quiz are in the November 2014 issue of the NoCOUG Journal . I am the editor of the NoCOUG Journal. What’s NoCOUG, you ask? Only the oldest and most active Oracle users group in the world. If you live in the San...
64 0 /
DuncanDavies
Follow /29 Oct 2014 at 2:00pm / Oracle

Cedar wins Silver – Fusion Partner of the Year 2014/15

If you follow any number of those in the Partner community on LinkedIn you’ll have seen many of us asking that you vote for us in the UKOUG’s annual Partner of the Year competition. All of the partners are really grateful for your votes as...
28 0 /
Derik Hammer
Follow /29 Oct 2014 at 12:00pm / SQL Server

Rebooting HRSSUG

This week I’m excited to announce the reboot of the Hampton Roads SQL Server User Group (HRSSUG). We will be coming back online this Novemeber, holding meetings every third Wednesday of the month. Check out our announcement below and be advised...
102 0 /
Kenneth Fisher
Follow /29 Oct 2014 at 12:00pm / SQL Server

Playing with the log – Before the first full backup

The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log . So the other day I was asking about VLFs and got sent to this great video of a recorded session from PASS SQLRally...
35 0 /
Thomas Klughardt
Follow /29 Oct 2014 at 10:49am / Code Tester for Oracle

Continuous Integration: Code Tester and the Build Process

Especially for agile development and nightly builds it is important to have a simple, easy to do and reliable way to make sure that the application code is free from errors before it is deployed. The building and deployment of an application is usually...
17 0 /
Chris Webb
Follow /29 Oct 2014 at 10:24am / SQL Server

PASS Summit And Other Speaking And Training Dates

This is just a quick post to advertise some upcoming speaking and training dates… PASS Summit I’ll be at the PASS Summit in Seattle next week, and if you see me around be sure to say hello! I’ll be presenting a deep dive session on MDX scoped assignments...
40 0 /
Syed Jaffar Hussain
Follow /29 Oct 2014 at 5:43am / Oracle

AIOUG annual Oracle conference - SANGAM14

All India Oracle User Group (AIOUG) annual Oracle conference Sangam14 is less than 10 days away. This is the largest Oracle conference that take place every year in different cities of India with thousand's of attendees plus over 100 different topics...
2048 0 /
Iggy Fernandez
Follow /29 Oct 2014 at 3:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 26: Answers to the Final Exam! (Part IV)

Previous installment: Answers to the Final Exam! (Part III) First installment: DON’T PANIC Here are the answers to the problem in Part 22 of this series “ We Don’t Use Databases; We Don’t Use Indexes .” External tables...
101 0 /
Fernando Garcia
Follow /28 Oct 2014 at 11:11pm / Oracle

Las columnas que no son columnas

En una base de datos Oracle hay aproximadamente 15 "tipos" de columnas que en realidad no son columnas de tablas. ¿A qué me refiero? Me estoy refiriendo a las llamadas pseudocolumnas . Las pseudocolumnas se comportan como si...
83 0 /
VSRaavi
Follow /28 Oct 2014 at 11:09pm / SQL Server

SQL Server – Failed to bring availability group ‘[availability group name]‘ online

Failed to bring availability group ‘[availability group name]‘ online. via Failed to bring availability group ‘[availability group name]‘ online.
44 0 /
Dan Hotka
Follow /28 Oct 2014 at 10:58pm / Oracle

Oracle11 Invisible Indexes

Hi! Ever hear of such a thing? Sure! Oracle11 now allows you to have indexes that are being maintained but NOT used in explain plans/used by SQL. Why would you want to do such a thing? Well…about a year ago, I submitted...
40 0 /
Jason Brimhall
Follow /28 Oct 2014 at 7:25pm / SQL Server

Ghosts – an eXtrasensory Experience

This is the last article in a mini-series diving into the existence of ghosts and how to find them within your database. So far this has been a fun and rewarding dive into Elysium to see and chat with these entities.  We have unearthed some means to...
48 0 /
Steven Feuerstein
Follow /28 Oct 2014 at 4:51pm / Oracle

Running out of PGA memory with MULTISET ops? Watch out for DISTINCT!

A PL/SQL team inside Oracle made excellent use of nested tables and MULTISET operators in SQL, blending data in tables with procedurally-generated datasets (nested tables). All was going well when they hit the dreaded: ORA-04030: out of process memory...
49 0 /
rickdelgado
Follow /28 Oct 2014 at 3:54pm / NoSQL

The Diversification of IT

Most of us have grown up assuming career success is vertical. We view the corporate ladder as the measuring stick, and job titles as trophies and accomplishments. In order to reach those high levels, we assume we have to be the best at what we do, and...
118 0 /
Jen McCown
Follow /28 Oct 2014 at 3:18pm / SQL Server

Session: Introduction to Powershell Cmdlets for DBAs

I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged about it! Download the session recording here Download the code file here Abstract: You’ve been hearing about this newfangled...
67 0 /
DuncanDavies
Follow /28 Oct 2014 at 2:00pm / Oracle

Cedar Wins Gold – PeopleSoft Partner of the Year

If you follow any number of those in the Partner community on LinkedIn you’ll have seen many of us asking that you vote for us in the UKOUG’s annual Partner of the Year competition. All of the partners are really grateful for your votes as...
29 0 /