Discuss in the Community


Follow /7 Jul 2015 at 5:53pm / Toad for IBM DB2

Easily Understand Your Database Objects

Understanding the dependencies and relationships of your database objects gives you the greatest insight into your DB2 system. And now there’s an easy way to expand your knowledge in this area. It’s called a visual database map and it goes...
239 0 /
Sten Vesterli
Follow /7 Jul 2015 at 3:12pm / Oracle

License Management: Do You Feel Lucky?

It seems like I've been discussing Oracle licensing a lot lately, possibly because Oracle is giving their sales people bonuses for selling Cloud-based solutions. This means that many customers will be subjected to an argument why everything would...
164 0 /
Follow /7 Jul 2015 at 1:41pm / Oracle

/usr/ccs/bin/as: not found/No such file or directory on Solaris 11.2

While trying to install Oracle Database 12c on Solaris 11.2 the i faced the following the errors in the logs and dbca was unable to start :- INFO: sh[2]: /usr/ccs/bin/as: not found [No such file or directory] INFO: make: Fatal error: INFO: *** Error code...
96 0 /
Abu Fazal Abbas
Follow /6 Jul 2015 at 8:36am / Oracle

Oracle: The myth, reality and the curious case of count(*)

Today’s article is all about the popular count(*) method of checking cardinality and is dedicated to novice Oracle DBAs like me. We use count(*) almost everyday at some point to check the number of rows in a particular table. Sometime it gives...
198 0 /
Iggy Fernandez
Follow /5 Jul 2015 at 6:28am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 38: Shakespeare’s advice for database upgrades

Previous installment: POISED: A problem-solving method First installment: DON’T PANIC “ Those friends thou hast, and their adoption tried, Grapple them unto thy soul with hoops of steel; But do not dull thy palm with entertainment Of each...
649 0 /
Porus Homi Havewala
Follow /4 Jul 2015 at 2:29pm / Oracle

You will now be able to use Exadata on the Oracle Database Cloud

Friends, ever wanted to use Exadata for your databases, but couldn’t? Oracle will now make it possible to use Exadata databases directly on the cloud. Last month, on June 22, Oracle announced the availability of the Oracle Database Cloud Exadata...
189 0 /
Follow /3 Jul 2015 at 2:30pm / SQL Server

010 – Ayman El-Ghazali - WaterOx Consulting

Reading Time: 2 minutes The community makes it all happen! In WOxPod!, episode # 009 –... The post 010 – Ayman El-Ghazali appeared first on WaterOx Consulting .
159 0 /
Chris Webb
Follow /3 Jul 2015 at 11:23am / SQL Server

Ensuring Columns Are Always Present In A Table Returned By Power Query

Disappearing or renamed columns in your data source can cause all kinds of problems when you’re importing data using Power Query: errors when you try to refresh the query, broken calculations in Power Pivot, PivotTables that reformat themselves and then...
134 0 /
Follow /2 Jul 2015 at 10:19am / SQL Server

SSMS Tip Of The Day – Show Row Count

Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway. If you want to see the number of rows in a table you can always use Select count ( * ) from TableName but it...
141 0 /
Paul Turley
Follow /2 Jul 2015 at 2:10am / SQL Server

Power BI Hands-On Workshop at PASS Global Summit

Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring your laptop and let’s build a real business intelligence (BI) solution using Power BI! In this deep-dive session, we build a complete...
140 0 /
Mark Kurtz
Follow /2 Jul 2015 at 12:36am / Toad Data Modeler

Preserving the data while making a change to a table

I was talking to a customer this week about the process of generating a Change Script when they are ready to deploy their changes and they were concerned about the fact that the script generation always wants to drop and rebuild the object. They did not...
135 0 /
Jason Brimhall
Follow /1 Jul 2015 at 8:19pm / SQL Server

Database Drops in SQL 2012

In the previous article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who dropped the database and when they dropped it.  In that article, I demonstrated how the information ...
151 0 /
Craig Mullins
Follow /1 Jul 2015 at 7:03pm / IBM DB2

Influencing the DB2 Optimizer: Part 1

Today is July 1, 2015 - mid way through the year and the beginning a fresh, new month. With that in mind, I'm kicking off a new series of blog posts here on the various methods of influencing the DB2 Optimizer's access path decisions. The bulk...
101 0 /
Follow /1 Jul 2015 at 6:16pm / Oracle

The End of Oracle Content Server

Hello Day in and day out I'm hearing from reputable sources and clients alike that Oracle Content Server looks dated, it is hard to use, it's UI sucks and similar alarming remarks. And the UI indeed hasn't changed much in years, so that begs...
135 0 /
James Serra
Follow /1 Jul 2015 at 4:00pm / SQL Server

What is Polyglot Persistence?

Polyglot Persistence is a fancy term to mean that when storing data, it us best to use multiple data storage technologies, chosen based upon the way data is being used by individual applications or components of a single application.  Different kinds...
151 0 /
Follow /1 Jul 2015 at 3:30pm / SQL Server

Speaking at PASS Summit 2015 & SQL Live360! - WaterOx Consulting

Reading Time: 2 minutes Seattle, here we come! I am excited, and honored that it is... The post Speaking at PASS Summit 2015 & SQL Live360! appeared first on WaterOx Consulting .
136 0 /
Chris Yates
Follow /1 Jul 2015 at 1:15pm / SQL Server

SQL Saturday Field Notes

As you walk toward the entrance the door opens and there stands a volunteer smiling welcoming you in. You make your way into the building where you are ushered toward the sign in table; there is where you are greeted by more volunteers who help you get...
136 0 /
Kenneth Fisher
Follow /1 Jul 2015 at 1:00pm / SQL Server

Blocking and deadlocking on purpose

Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling or prove a point and then you need to do the unusual. Blocking and Deadlocking are based on lock requests and locking is handled...
151 0 /
Follow /30 Jun 2015 at 11:02pm / SQL Server

Don't Always Blame The Data

Just a quick post on this error I received yesterday. While I was working at a client, the application manager made some changes to a Slowly Changing Dimension of type 2 with effective dates, as mentioned here . This dimension contains the organisational...
141 0 /
Ed Elliott
Follow /30 Jun 2015 at 8:00pm / SQL Server

Download SSMS, SSDT or SSDT-BI

It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing. This is an example of some frustration: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c82354d0-2f88-4......
151 0 /
Steven Feuerstein
Follow /30 Jun 2015 at 7:38pm / Oracle

The Oracle Database Developer Choice Awards: We Need You!

Years ago, Oracle Corporation gave out Excellence Awards for developers. For example, I was honored to be chosen as "PL/SQL Developer of the Year" in both 2002 and 2006. But it's been a while since developers received those awards. The focus...
147 0 /
Follow /30 Jun 2015 at 5:33pm / Toad for IBM DB2

Advanced Space Management for DB2

To take advantage of DB2’s parallelism during query processing, you have to equally distribute your data across all partitions. Now there’s an easy way to identify incorrect distribution and quickly fix it. With the new DB Admin Module...
343 0 /
Juan Carlos Olamendy
Follow /30 Jun 2015 at 5:02pm / Oracle

Big Data and Oracle database

In this article, I want to talk how to apply Big Data techniques along with data stored in Oracle database. Let me start talking about that in computer science, there are dichotomies between optimizing read vs write operations, transactional vs analytical...
151 0 /
Derik Hammer
Follow /30 Jun 2015 at 2:00pm / SQL Server

Writing Repeatable T-SQL

Writing code for a database is more of a challenge than writing for applications. Before the developers bite my head off, I do not mean that the languages, such as T-SQL, are more difficult or that applications are any less sophisticated than database...
175 0 /
Deiby Gomez
Follow /30 Jun 2015 at 8:13am / Oracle

Oracle Open World Lationamericano 2015 - Brasil

Del 23 al 25 de Junio se celebró en São Paolo, Brasil el Oracle Open World Latinoaméricano, durante la misma semana también se celebró la primera reunion de Líderes de los Grupos de Usuarios de Oracle en Latinoamérica...
205 0 /