Expert Blogs - Toad World

Expert Blogs


Jen Stirrup
Follow /24 Jul 2016 at 9:44pm / SQL Server Blog

Happy Birthday Power BI! London PUG News #PowerBI

To the Power BI Team – Happy Birthday and congratulations on all of your achievements! You’ve spawned a fantastic product plus a wonderful ecosystem of creative partners, happy consultants, MVPs and Community Contributors, User Group Leaders...
19 0 /
Follow /24 Jul 2016 at 1:13pm / Oracle Blog

Multi Node Installation EBS R12.2 and start CD

As an Apps DBA its our responsibility to install and configure E-Business suite system. Oracle EBS installation is performed using rapid install wizard and this wizard will be included in start Here CD. As we Oracle EBS system supports single node and...
16 0 /
Follow /24 Jul 2016 at 9:48am / Oracle Blog

Oracle EBS R12.2 Installation Issue with Start CD 51

Oracle EBS 12.2 Installation is performed by using the start here CD and oracle keeps on releasing the newer version of start CD’s to include bug fixes and new enhancements. Currently start CD 51 is the latest available start CD .Earlier I’ve...
45 0 /
Follow /24 Jul 2016 at 8:32am / Oracle Blog

addnode Oracle 12c RAC – Error on Saving cluster Inventory

In one of the recent assignment we were adding 2 cluster nodes to an existing 8 node cluster and we encountered an error while saving a cluster Inventory on the new cluster nodes. The following is the screen shot where it encountered the error. ...
47 0 /
Pinal Dave
Follow /24 Jul 2016 at 2:30am / SQL Server Blog

How to Find Outdated Statistics? – Interview Question of the Week #081

Recently in one of the webcast, while I was presenting about statistics and performance tuning, I was asked by one of the attendees that if there is anyway to find out all the outdated statistics based on the dates from the server. This is indeed a very...
56 0 /
Porus Homi Havewala
Follow /23 Jul 2016 at 1:00pm / Oracle Blog

Latest Enterprise Manager Application Management Pack (AMP) for Oracle EBS

Enterprise Manager Cloud Control 13c’s Application Management Pack (AMP) for Oracle E-Business Suite has been recently released. Using this, you can manage Oracle E-Business Suite, 12.0, 12.1, and 12.2 installations. You can...
76 0 /
Pinal Dave
Follow /23 Jul 2016 at 2:30am / SQL Server Blog

SQL SERVER – Network Servers List is Empty in SQL Server Management Studio

I have in numerous places told that the first tool that I often open when the computer boots up will be SQL Server Management Studio. I get intrigued whenever someone comes up with an error relating to SSMS. There is something that gets my troubleshooting...
67 0 /
Pinal Dave
Follow /22 Jul 2016 at 2:30am / SQL Server Blog

SQL SERVER – Install Error – Could not Find the Database Engine Startup Handle

Note: There are multiple reason of above error and this blog shows just one of them. I am sure that this blog would give you guideline about what do to in case you see this error about install error. Some errors are generic and there is no single path...
50 0 /
Shaun Stuart
Follow /21 Jul 2016 at 9:06pm / SQL Server Blog

Viewing Statistics in SSMS

I’m in the process of creating a post about statistics and came across something in SQL Server Management Studio that was driving me crazy. I thought I’d post it here so that others might not waste an hour or two like I did puzzling over this...
36 0 /
Sten Vesterli
Follow /21 Jul 2016 at 8:44pm / Oracle Blog

Oracle Sets New Security Patch Record

Oracle has released the July 2016 Critical Patch Update , and it covers a record 274 security issues across pretty much every Oracle product. If you are an Oracle customer, you are almost certainly running a vulnerable product and should patch. WebLogic...
125 0 /
Jason Brimhall
Follow /21 Jul 2016 at 8:30pm / SQL Server Blog

Another Query to Help Find the Right Event

Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to  Extended Event Help Queries , I...
31 0 /
Tim Radney
Follow /21 Jul 2016 at 5:58pm / SQL Server Blog

SQL Server: Consolidation Tactics and Best Practices

My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices . In this course I spend just over two hours sharing my experiences and knowledge of consolidating numerous clients over the years. I...
91 0 /
David Fitzjarrell
Follow /21 Jul 2016 at 4:18pm / Oracle Blog

On An Average Day

"There are other advantages," continued the child. "For instance, if one rat were cornered by nine cats, on the average, each cat would be ten percent rat and the rat would be ninety percent cat. If you happened to be a rat, you can see...
47 0 /
Deiby Gomez
Follow /21 Jul 2016 at 7:26am / Oracle Blog

My OTN Tour 2016 Agenda

This year will be the 4th year that I have been Speaker in one of the biggest event in Latin America, the OTN Tour 2016 . This event touches 10 countries of Latin America in just 2 weeks, several experts are speaking in this event from different countries...
122 0 /
Pinal Dave
Follow /21 Jul 2016 at 2:30am / SQL Server Blog

Free DBA Tools for SQL Server Professionals – Notes from the Field #133

[Note from Pinal ]: This is a 133rd episode of Notes from the Field series. I know Mike for many years and Mike has always inspired me with his positive energy. I have always enjoyed spending time with him as I have always learned something new but along...
36 0 /
Julie Hyman
Follow /21 Jul 2016 at 2:06am / Toad Data Point Blog

New Toad Data Point v4.0 makes Data Preparation even easier!

Toad Data Point version 4.0 is being released today! With each release of Toad Data Point we are focusing on adding enhancements requested by users which make connecting, querying and data prep easier for all of our users, regardless of your level of...
168 0 /
Follow /20 Jul 2016 at 4:40pm / SQL Server Blog

Remove-SQLDatabaseSafely My First Contribution to DBATools

What is DBA Tools? A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now grown into a collection of various commands that help automate DBA tasks and encourage best practices. You can read...
49 0 /
James Serra
Follow /20 Jul 2016 at 4:00pm / SQL Server Blog

Multi-tenant databases in the cloud

For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge arises on how to architect that solution in the cloud.  For example, say you have a software solution that stores patient data for hospitals...
51 0 /
Follow /20 Jul 2016 at 3:51pm / SQL Server Blog

The new SQL Server Management Studio

Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting around to writing this now. SSMS is now a separate release from SQL itself. The latest release is here . Monthly releases and no longer having to download...
55 0 /
Kenneth Fisher
Follow /20 Jul 2016 at 2:00pm / SQL Server Blog

Want to be able to read your database between restores?

When restoring a database there are times when it would nice to restore a bit, check what’s been restored so far, restore a bit more etc. However, traditionally most people only know RECOVERY and NORECOVERY . This means that you restore to a point...
49 0 /
Michael J. Swart
Follow /20 Jul 2016 at 1:00pm / SQL Server Blog

Simplified Order Of Operations

I recently learned that when combining multiple operators in a SQL expression, AND has a higher precedence than OR but & has the same precedence as | . I expected the precedence rules for the logical operators to be consistent with the bitwise operators...
97 0 /
Mike Walsh
Follow /20 Jul 2016 at 12:45pm / SQL Server Blog

SQL Server First Responder Kit [Free DBA Tool of the Week]

I can’t do a series on free SQL Server DBA tools without including the SQL Server First Responder Kit put out by Brent Ozar and his company (and the SQL Family who helped)! This is that post. A couple weeks ago, I was inspired to start this blog...
60 0 /
Paul Turley
Follow /20 Jul 2016 at 5:47am / SQL Server Blog

SSRS 2016 Book Nearly Done… My Brain is now Jell-O

(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content complete!  The book is well into the editing stage– still, another grueling phase of the publishing process, but...
81 0 /
Fernando Garcia
Follow /20 Jul 2016 at 1:42am / NoSQL Blog

Las bases de grafos y la ciudad de Konigsberg.

Formalmente un grafo es una colección de nodos y relaciones que los conectan. Los grafos representan a las entidades como nodos . Las formas en que dichos nodos se relacionan, están representadas como relaciones . ¿Es necesario profundizar...
77 0 /
Jason Brimhall
Follow /19 Jul 2016 at 10:37pm / SQL Server Blog

Extended Event Help Queries

Enjoy this article re-publication from my original work at SQL Solutions Group. When working with Extended Events, there are times when a little more information is, well, helpful.  You know you want to use extended events to try and monitor for a specific...
44 0 /