Expert Blogs - Toad World

Expert Blogs


Follow /10 Dec 2016 at 3:13am / SQL Server Blog

Linux – How to generate and configure SSH Key authentication to connect to a remote system

Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today I will walk you through how we can achieve this in 3 simple steps For this demo I will be configuring SSH key authentication...
28 0 /
Pinal Dave
Follow /10 Dec 2016 at 1:30am / SQL Server Blog

SQL SERVER – Unable to create login AlwaysOn availability group secondary replica

One of my clients reported a usual behavior of the AlwaysOn availability group. He informed me that he is trying to add a login on the secondary replica in the AlwaysOn AG environment but it is failing with below error: Msg 3906, Level 16, State 1,...
29 0 /
Dan Hotka
Follow /9 Dec 2016 at 6:46pm / Oracle Blog

Oracle Block Internals Part 6

This is the final article in our Block Internals article series. It covers a couple of other issues you could have with long-running transactions. This article also covers how direct path loading works. Direct path loading doesn’t create a problem...
40 0 /
Jen McCown
Follow /9 Dec 2016 at 2:45pm / SQL Server Blog

Why won’t my SP work THIS time?

Why won't my SP work? I did this exact thing. You're never too old to do something like this. The post Why won’t my SP work THIS time? appeared first on The MidnightDBA Star-Times .
49 0 /
Follow /9 Dec 2016 at 2:02pm / Oracle Blog

OCP Upgrade 1Z0-060 Exam guide

This guide will get Oracle admins up to date with the latest developments in Oracle 12c. It includes all the necessary information that you need to implement in your existing systems. All of the information in this book has been handpicked to help you...
70 0 /
Porus Homi Havewala
Follow /9 Dec 2016 at 9:11am / Oracle Blog

Some Interesting New features in Oracle Database 12.2 – Part I

Oracle Database 12c Release 2 has been released on the Oracle Database Cloud, first on the Exadata Express Cloud Service. Many people are waiting for this version to be released on-premise as well. Let’s go through some interesting features of this...
97 0 /
Arun Sirpal
Follow /9 Dec 2016 at 8:48am / SQL Server Blog


NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and MAY cause blocking. I used to think that a NOLOCK (which is the same as read uncommitted) hint actually meant … Continue reading →
41 0 /
Pinal Dave
Follow /9 Dec 2016 at 1:30am / SQL Server Blog

SQL SERVER – Error: 26014 – Unable to Load User-Specified Certificate

After seeing various issues with SQL Server startup problem, I felt that I know almost most of the errors, but I was wrong till someone contacted me with a new error. But I learned that Errorlog is always a good place to start with.  SQL SERVER – Where...
53 0 /
John Dorlon
Follow /8 Dec 2016 at 10:15pm / Toad for Oracle Blog

Oracle 12c Release 2 New Features Supported in Toad 12.10

(And a few 12.1 features that are newly supported in Toad) As you may have heard, Oracle 12c Release 2 is now available. As of December 2016, it is only available in the Oracle Cloud, but hopefully we’ll be able to download it soon. Here’s...
117 0 /
Dinesh Asanka
Follow /8 Dec 2016 at 4:08pm / SQL Server Blog

Microsoft R Server 9.0 now available

Microsoft today announced the availability of R Server 9.0 on MSDN and Visual Studio Dev Essentials. This new release is built on top of the latest open source R engine, and comes with several new capabilities. In MRS 9.0, you can combine the algorithms...
73 0 /
Follow /8 Dec 2016 at 12:00pm / IBM DB2 Blog

DB2 Basics: The Role of Databases

This blog article should appeal to a wide audience. This article is not specific to DB2, but speaks to the larger role of the database in the IT organization. What is a Database? At the most basic level, a database is an organized collection of information...
29 0 /
Pinal Dave
Follow /8 Dec 2016 at 1:30am / SQL Server Blog

SQL SERVER Management Studio – Taking DB Offline Made Easier

I have an appetite to observe and learn from what happens around me more. These are the best ways we realize how life has been gifted to us. Since I have been traveling lately like mad with families where there has been enough vacation filled with some...
56 0 /
Gokhan Atil
Follow /7 Dec 2016 at 8:16pm / Oracle Blog

Oracle 12.2 New Feature: SQL*Plus History

While playing with Oracle 12.2 Database on the Oracle Cloud, I noticed that SQL*Plus has a new feature which would be very useful for all DBAs. Now SQL*Plus can keep history of the commands executed, and let you see and run these commands from the history...
109 0 /
Brendan Tierney
Follow /7 Dec 2016 at 3:33pm / Oracle Blog

12.2 DBaaS (Extreme Edition) possible bug/issue with the DB install/setup

A few weeks ago the 12.2 Oracle Database was released on the cloud. I immediately set an account and got my 12.2 DBaaS setup. This was a relatively painless process and quick. For me I wanted to test out all the new Oracle Advanced Analytics new features...
96 0 /
Follow /7 Dec 2016 at 3:18pm / IBM DB2 Blog

Reliability, Availability, and Scalability Lessons for Holiday Peak Processing

Operational performance is always paramount for applications, websites, and order systems during the busy Christmas holiday shopping season. Keeping holiday peak processing going with good performance is a pains-taking ordeal. Even with the best laid...
23 0 /
Arun Sirpal
Follow /7 Dec 2016 at 8:20am / SQL Server Blog

TDE Recovery

This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can I not get involved with this one? I have been blogging for about a year now and have covered … Continue reading →
68 0 /
Follow /7 Dec 2016 at 7:28am / SQL Server Blog

Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp

In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a directory On a Linux server, by default, the group owner of a file or directory is the primary group of the user who created the file directory...
62 0 /
Pinal Dave
Follow /7 Dec 2016 at 1:30am / SQL Server Blog

SQL SERVER – FIX – Error: 26023 – TCP Port is Already in Use

One of my clients approach me that after patching of SQL instances, database mirroring stopped working. As usual, I asked them to share ERRORLOG file  SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location .  In this blog post we will...
68 0 /
Arun Sirpal
Follow /6 Dec 2016 at 5:30am / SQL Server Blog

Checking your Wait Stats via Power BI

Wait stats is my go to thing, however I do get bored just querying it via a  table so I decided to broaden my horizons and see how “analytical” I could get with it via Power BI. What I usually … Continue reading →
78 0 /
Pinal Dave
Follow /6 Dec 2016 at 1:30am / SQL Server Blog

SQL SERVER – Speed Up Performance Without Code Change

In this blog post we are going to leave about how to Speed Up Performance Without Code Change or Configuration Change in SQL Server. This blog post is going to be a fun and quick read. Please make sure that you read this blog post till the end to learn...
89 0 /
Jen McCown
Follow /5 Dec 2016 at 6:52pm / SQL Server Blog

December: A two-line play.

“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life balance,” she replied, glancing furtively at her sparsely populated blog. Fin   (P.S. The latest blog on MinionWare...
100 0 /
YV Ravi Kumar
Follow /5 Dec 2016 at 6:10pm / Oracle Blog

Role of Grid Infrastructure Management Repository (GIMR) database in Oracle 12c Real Application Cluster (RAC) R1 ( environment

By Y V Ravi Kumar, Oracle ACE and Oracle Certified Master (OCM) Introduction: The Grid Infrastructure Management Repository (GIMR) database now includes the Cluster Health Monitor (CHM) Repository. The CHM architecture supports HUB node and Leaf...
316 0 /
Craig Mullins
Follow /5 Dec 2016 at 6:06pm / IBM DB2 Blog

The Tao of DB2 - Part 13: Constantly Learning More

It is time, once again, to look in on our intrepid young DBA as he continues to learn database administration as an intern to an older, wiser, but soon-to-be-retiring DBA. The intern approached his mentor and said "You have taught me a lot in the...
28 0 /
Brendan Tierney
Follow /5 Dec 2016 at 11:37am / Oracle Blog

Evaluating Cluster Dispersion in Oracle Data Mining

When working with the Clustering algorithms, and particularly k-Means, in the Oracle Data Miner tool there is no way of seeing how compact or dispersed the data is within a cluster. There are a number of measures typically used in various tools and algorithms...
72 0 /
Follow /5 Dec 2016 at 9:17am / SQL Server Blog

Monday Coffee 2016-12-05

You are the DBA your company makes you. Aren’t you? SQL Server has such a wide range of features that no DBA role will implement all of them. So, you use a certain subset in each role that you occupy throughout your career. What those features...
62 0 /