Expert Blogs - Toad World

Expert Blogs

Blogs

Porus Homi Havewala
Follow /1 Oct 2016 at 11:30am / Oracle Blog

Oracle Database 12.2 available on Exadata Express Cloud Service (new features doc on docs.oracle.com but not under database)

My friend told me today that Oracle 12.2 is available on the cloud on the following link: https://cloud.oracle.com/database I checked that link. The following database cloud services can be seen on that page: 1. Oracle Database Cloud Service ...
52 0 /
Pinal Dave
Follow /1 Oct 2016 at 2:30am / SQL Server Blog

PowerShell – Create a User with Read Rights on a Database

I have written a number of PowerShell script in the blog and they have been used by many. Most of these scripts are there because someone wanted something different and I got about creating something simple. After I create something for a given use case...
51 0 /
Johannes Ahrends
Follow /30 Sep 2016 at 10:16pm / Oracle Blog

Multitenant Database Option in a Dataguard Environment

Actually I have a project where we are going to set up a high availability infrastructure with RAC and Dataguard. Due to the requirements from several applications (e.g. Flashback) we decided to implement the Multitenant database option. Even though it...
56 0 /
Denny Cherry
Follow /30 Sep 2016 at 7:08pm / SQL Server Blog

Recommended reading from mrdenny for September 30, 2016

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. SQLSweet16!, Episode 7: Install Option for Instant File Initialization SQL Server on Xeon Phi? VMware Announces Alliances and Strategies...
19 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

Digital archive of the NoCOUG Journal—The best little Oracle users group magazine in the world

417 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

The Little Oracle Users Group That Could

The story of the Little Engine That Could is very old. The oldest version that I could find is from The Expositor and Current Anecdotes , Volume XIII, Number 1 (1911). Once upon a time a little freight car loaded with coal stood on the track in a coal...
248 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

NoCOUG Journal: A Few of My Favorite Things

As the editor of the NoCOUG Journal for ten years and counting, I’ve had the interview to interview some of the best minds in the Oracle world. These are a few of my favorite things they said: [Tim Gorman] You are old, father Gorman (as the young...
185 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

How to rebuild a 12 TB index that you accidentally dropped from a 55 TB table

Once upon a time there was a very experienced database administrator who accidentally dropped a 12 TB index from a 55 TB table (you can read the story here ). The question I had was “How did he fix it?” but I did not have the details till...
301 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

SQL pretzels created while experimenting with hallucinogens?

In an interview for the NoCOUG Journal , Steven Feuerstein was asked: “SQL is a set-oriented non-procedural language; i.e., it works on sets and does not specify access paths. PL/SQL on the other hand is a record-oriented procedural language, as...
125 0 /
Pinal Dave
Follow /30 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – Simple Example of BCP Command Line Utility

I was recently asked if I know the fastest way to export data from SQL Server table. This was very interesting question personally, as I have not run any such tests in the past. However, everytime when I had to export data, I have used in past BCP command...
42 0 /
Fernando Garcia
Follow /30 Sep 2016 at 12:56am / NoSQL Blog

Un espacio para aprender MongoDB.

MongoDB University ofrece una serie de cursos en línea pensados para aquellos que deseen desarrollar e implementar aplicaciones que funcionen sobre una base de datos MongoDB. Lo bueno es que todos los cursos son gratuitos! Actualmente la oferta...
108 0 /
Steven Feuerstein
Follow /29 Sep 2016 at 2:51pm / Oracle Blog

Develop a keen eye for unnecessary code

We've been offering quizzes on the PL/SQL Challenge (and now the new Oracle Dev Gym - still in an "early adaptor" user testing phase) since April 2010. We've covered hundreds of topics in PL/SQL, and hundreds more in SQL. Most quizzes...
72 0 /
Arun Sirpal
Follow /29 Sep 2016 at 8:42am / SQL Server Blog

My application to Microsoft

I have been eager to write this blog post for a while now. I want to share my experience of the process that I went through (last year) when I applied to Microsoft for a SQL PFE (Premier Field Engineer) … Continue reading →
63 0 /
Pinal Dave
Follow /29 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – SSMS Trick – Switching Columns in Grid Output

Yesterday when I wrote about what I learnt from Vinod’s session at the SQL Server User Group meeting, one of my friends wrote back asking what else was discussed. Though I knew some of the tips and tricks he showed as part of the sessions, there were...
64 0 /
Sten Vesterli
Follow /28 Sep 2016 at 10:46pm / Oracle Blog

But Where's the Business Logic?

In the U.S., there was an ad where a customer was presented with a very large hamburger bun. When she opens it, she exclaims: But where's the beef? Just back from OpenWorld, I have the same feeling. It was all about the snazzy UIs you can build...
198 0 /
DaveBeulke
Follow /28 Sep 2016 at 4:46pm / IBM DB2 Blog

Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 2

The benefits of having an IDAA appliance is something that every mainframe DB2 shop should investigate.  Investigating and justifying an IDAA appliance can be done at no cost.  In the previous blog, I talked about the set up steps for getting an IDAA...
31 0 /
Steve Hilker
Follow /28 Sep 2016 at 1:16pm / Oracle Blog

Announcing Database Discussions!

Let the discussions begin. Starting on October 10, 2016, Toad World will be launching a new way to engage with our database experts simply called "Database Discussions". Database Discussions will be a round table discussion in blog format...
475 0 /
DBAFromTheCold
Follow /28 Sep 2016 at 12:18pm / SQL Server Blog

Query shortcuts in SQL Server Management Studio

Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you! Following on from my last post Changing connection colours in SSMS I thought I’d write another quick about this cool but also often unused feature in...
82 0 /
Deiby Gomez
Follow /28 Sep 2016 at 5:07am / Oracle Blog

How to Change the Protection Mode with Data Guard Broker

In this article we will see how to change the protection mode in a Data Guard configuration which is managed by Broker, If you want to read more about each Protection Mode you can read HERE . In this article we will focus on what is needed in order to...
301 0 /
Pinal Dave
Follow /28 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – Hidden SSMS Gem: Find Dialog’s Unknown Functionality

I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me survive longer in this industry I suppose. So let me...
82 0 /
Fernando Garcia
Follow /28 Sep 2016 at 1:22am / NoSQL Blog

JSON, BSON y WiredTiger

JSON es uno de los estándares más utilizados en la web para el intercambio de datos. Gracias a la universalidad de las estructuras de datos que ofrece JSON, la mayoría de los lenguajes de programación modernos encuentran en...
81 0 /
Dan Hotka
Follow /27 Sep 2016 at 10:45pm / Oracle Blog

Oracle Open World 2016

Hi, OOW 16 is in the history books. Didn’t seem there were near the volume of people this year. The sessions I sat in on were full but not packed. I have a lot of material to share! The ACE Briefing (always the Thursday and Friday before)...
183 0 /
prashanthjayaram
Follow /27 Sep 2016 at 9:56pm / SQL Server Blog

SQL Server: Monitoring Disk Space with FSUTIL command line utility

Table of Contents Introduction Pre-requisites Data flow Enable xp_cmdshell Download SQL Code Output Conclusion References See Also Introduction This article talks about one of SQL method to fetch the...
35 0 /
Ed Elliott
Follow /27 Sep 2016 at 8:23pm / SQL Server Blog

Refactoring in SQL Server Data Tools - SSDT

In this post I will talk about the in-built refactoring support in SSDT – the language is slightly different from my normal style as originally it was going to be published else but rest assured it is written by myself What is refactoring? In programming...
37 0 /
Chris Yates
Follow /27 Sep 2016 at 3:00pm / SQL Server Blog

Is ROI for Vendors Worth the SQL Saturday Investment?

Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events. Having the opportunity to work alongside these vendors has been both a learning...
38 0 /