Discuss in the Community

Blogs

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...
3 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 12.1.0.2 (Download at http...
28 0 /
DuncanDavies
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...
11 0 /
WaterOx
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 .
31 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...
12 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...
33 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
35 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...
19 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...
124 0 /
rickdelgado
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...
86 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...
525 0 /
o.mustafaoracle
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 :-...
117 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...
124 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...
43 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...
54 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...
118 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
154 0 /
WaterOx
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 .
69 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...
205 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...
30 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...
139 0 /
Jason Brimhall
Follow /1 Sep 2015 at 1:21pm / SQL Server

Shredding Extended Event Actions

The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow up post about XML in Extended Events. Well, today I present to you another opportunity for you...
132 0 /
Jen McCown
Follow /1 Sep 2015 at 1:00pm / SQL Server

Time for T-SQL Tuesday #70!

Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in a number of ways, but I tend to default to two definitions: “the things I’m in charge of” and...
122 0 /
Vaclav Frolik
Follow /1 Sep 2015 at 9:35am / Toad Data Modeler

Synchronization and Mapping of Renamed Table Columns

Toad Data Modeler contains many powerful synchronization features, incl. model comparison, model merge and generation of change scripts. In addition to the complex features, there is another possibility how to quickly compare selected object with database...
97 0 /
Kellyn PotVin
Follow /31 Aug 2015 at 7:21pm / Oracle

Raspberry Pi Controlled Airplane Launcher

Everything I do with the Raspberry Pi is about finding ways to incorporate STEAM, (Science, Technology, Engineering, Art and Math) into my projects.  This is no easy feat, but I have a lot of fun while I try.  This latest project, we’re still working...
128 0 /