Discuss in the Community


Abu Fazal Abbas
Follow /5 Sep 2015 at 8:12am / Oracle

Simple tricks to remove OEM Console’s blackout from command line: OEM 12c

Problem Summary When a target OEM agent is put under blackout from OEM console (GUI), the only valid way to remove the blackout is to use OEM console. However, there might be situations when we might not have access to the GUI or the GUI is not working...
52 1 /
Dinesh Asanka
Follow /5 Sep 2015 at 4:06am / SQL Server

24 hours of SQLPass is coming

24 hours of SQL Pass is happening on Sept 17 & 18th. These are short little 1-hour web casts, but may be of interest to someone. Registration is FREEEEEEEE!!! Link to sessions: http://www.sqlpass.org/24hours/2015/summitpreview/Schedule.aspx http:...
33 0 /
Mike Smithers
Follow /4 Sep 2015 at 9:00pm / Oracle

Caching in – Oracle Sequences and Performance

Several years ago, the BBC found itself a little financially embarassed. Appropriately enough, given the topic at hand, it was a bit strapped for cache…er…cash. In an attemmpt to reduce expenditure, the decision was taken to re-broadcast...
28 0 /
Melissa Coates
Follow /4 Sep 2015 at 7:03pm / SQL Server

Direct Connect Options in Power BI for Live Querying of a Data Source

In a recent Power BI post, I wrote about two ways to utilize Power BI: one being the "Report Only" and the other including the "Query, Model and Report" alternative . Since then I've done a Power BI POC for a new customer and seen...
29 0 /
Johannes Ahrends
Follow /4 Sep 2015 at 4:36pm / Oracle

Standard Edition 2 (SE2) Available

Time has come. As already announced in July and rejected few days later (see Blog http://www.carajandb.com/en/blogs/blog-jahrends-en/230-standard-edition-2-en ) on September 1st Oracle releases Standard Edition 2 as version (Download at http...
48 0 /
Follow /4 Sep 2015 at 4:00pm / Oracle

Sharing HCM Cloud Project Plans Effectively

One thing that’s different in the world of Oracle HCM Cloud is that there are more, quicker projects than in the ‘old world’. Instead of an 18-month upgrade we have shorter initial implementations, often with a smaller scope, and then...
27 0 /
Follow /4 Sep 2015 at 3:30pm / SQL Server

018 – Learn Like A Pro! - WaterOx Consulting

Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like... The post 018 – Learn Like A Pro! appeared first on WaterOx Consulting .
51 0 /
Denny Cherry
Follow /4 Sep 2015 at 3:00pm / SQL Server

Recommended reading from mrdenny for September 04, 2015

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Building High Performance, Highly Available SQL Servers on Azure Fear has Replaced Apathy as the Number One Enemy of Data...
6 0 /
Craig Mullins
Follow /4 Sep 2015 at 2:00pm / IBM DB2

Influencing the DB2 Optimizer: Part 7 - Miscellaneous Additional Considerations

In this 7th, and final installment of this series on influencing the DB2 optimizer's access path choices, we will take a look at a couple of additional things to consider as you work toward improving your SQL performance. Favor Optimization Hints...
77 0 /
Jason Brimhall
Follow /4 Sep 2015 at 12:57pm / SQL Server

XEvent Session Supporting Cast

So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated some quick and simple means to retrieve some metadata via the catalog views and DMVs . Beyond the metadata in the the catalog...
44 0 /
Bert Scalzo
Follow /4 Sep 2015 at 12:38pm / Toad for Oracle

Toad Unleashed available and on-sale

Toad Unleashed for Oracle is now available and it's on-sale for the labor day holiday. http://www.informit.com/promotions/labor-day-sale-140905?WT.mc_id=Author_Oracle_laborday2015
46 1 /
Vaclav Frolik
Follow /4 Sep 2015 at 11:19am / Toad Data Modeler

Creating or Updating Models from Excel Files

Microsoft Excel is a powerful tool. I think I can say it excels in many areas, but... can it be used for database modeling? Yes and No. As you probably know, Toad Data Modeler introduced support for import and export to Microsoft Excel in version 5...
25 0 /
Dan Hotka
Follow /4 Sep 2015 at 12:08am / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 11)

Hi! OK, we have been discussing cardinality and the importance of order in the Explain Plan. I have shown you newer syntax (and tools that runs said syntax) that shows actual row counts (cardinality) per line of explain plan. I’ve beat round...
133 0 /
Follow /3 Sep 2015 at 11:52pm / NoSQL

Big Data Obstacles Faced by Developing Nations

Fully utilizing big data and making the most of its potential is no easy task. Even among the most technologically advanced organizations, proper use of big data analytics can be a challenge, so it’s easy to see how the enormous difficulties faced...
95 0 /
Brad Wulf
Follow /3 Sep 2015 at 4:17pm / Toad for Hadoop - Blog

Toad for Hadoop Charts Perspective (Pre - BETA)

Toad for Hadoop Charts Perspective (BETA) NOTE: This functionality is pre release, but should be available in time for Hadoop World , enjoy! What follows is a detailed walkthrough of the newly added features, let us know if this is helpful and what...
598 0 /
Follow /3 Sep 2015 at 1:19pm / Oracle

ORA-00845: MEMORY_TARGET not supported on this system

SQL> alter system set memory_max_target=2GB scope=spfile; System altered. SQL> alter system set memory_target=2GB scope=spfile; System altered. SQL> startup ; ORA-00845: MEMORY_TARGET not supported on this system Check the following Space :-...
127 0 /
Vinoth Nm
Follow /3 Sep 2015 at 10:54am / SQL Server

Update - PowerShell Script for SQL Server Cluster/Stand Alone unattended Install and Uninstall - SQL 2014/SQL 2016 Support Added

For a long time I have been using different scripts for SQL Server install based on the various user requirements, with my latest client requirement I decided to create a master script for unattended install either in Clustered environment or as Standalone...
140 0 /
Kellyn PotVin
Follow /2 Sep 2015 at 9:48pm / Oracle

Updating the Raspberry Pi Vbox Image

So one of the things I like to do is test out a lot of my python gaming code, (as far as for the coding and syntax) on my Oracle Virtualbox image of my Raspberry Pi .  Another great thing about building games on the Raspberry Pi, is a built in module...
47 0 /
Denny Cherry
Follow /2 Sep 2015 at 7:39pm / SQL Server

PASS Summit 2015 1st Timers Webcast is Next Week

Just a reminder, that if you are planning on attending the PASS Summit this year you’ll want to make sure to get registered for my 1st timers webcast which is scheduled for September 7th. 2015 at 1pm Pacific Time. I know it’s a holiday here...
62 0 /
Steven Feuerstein
Follow /2 Sep 2015 at 4:28pm / Oracle

Zero tolerance for out-of-scope references!

I received this question last week: Hi Steven, Here is a question that I have been pondering for sometime and haven't found a definitive answer to. Perhaps you can shed some light. When writing a procedure in PL/SQL, I pass it all the variables that...
126 0 /
Ed Elliott
Follow /2 Sep 2015 at 4:16pm / SQL Server

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool: https://medium.com/@edelliott.the.agilesql.club/let-s-start-doing-profes... Tags: Sql Server SSDT Medium
163 0 /
Follow /2 Sep 2015 at 3:45pm / SQL Server

Checking for Excessive Permissions in SQL Server - WaterOx Consulting

Reading Time: 2 minutes Who can do what? One of the key things that a DBA... The post Checking for Excessive Permissions in SQL Server appeared first on WaterOx Consulting .
78 0 /
Kenneth Fisher
Follow /2 Sep 2015 at 1:00pm / SQL Server

Learning Regular Expressions

I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term for me, but not something I’d ever looked at much. Well as it happens I had something that I needed to use it on a day or two...
221 0 /
Vaclav Frolik
Follow /2 Sep 2015 at 9:35am / Toad Data Modeler

How to Display and Format Links to Referenced Objects

Workspaces in Toad Data Modeler can be used for splitting Entity Relationship Diagrams (ERD) to smaller parts. In case your model is large, it is always recommended to use workspaces to limit the amount of visualized items. When you create a new model...
34 0 /
Chris Webb
Follow /1 Sep 2015 at 4:23pm / SQL Server

Excel 2016 BI Branding Changes

Office 2016 is on the verge of being released, and although Power BI is the cool new thing Excel 2016 has added several new BI-related features too. What is also interesting – and less well publicised – is that several of the BI features in Excel 2016...
145 0 /