Expert Blogs - Toad World

Expert Blogs


Thomas LaRock
Follow /17 Jan 2017 at 5:45pm / SQL Server Blog

6 Ways To Treat Your Data Right

Not everyone understands just how important data is until it is gone. Here are six ways that you can treat your data right. The post 6 Ways To Treat Your Data Right appeared first on Thomas LaRock . If you liked this post then consider subscribing to...
15 0 /
Henrik Loeser
Follow /17 Jan 2017 at 3:44pm / IBM DB2 Blog

Bluemix: Simplified Deployment of Complex Cloud Foundry Apps

4 0 /
Pinal Dave
Follow /17 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore

One of my clients reported that he is trying to apply security patch for SQL Server clustered instance and it was failing. Since this is SQL 2005 instance, there is no official support available from Microsoft at this point. So, they contacted me. I asked...
43 0 /
Clarisa Maman Orfali
Follow /16 Jan 2017 at 10:50pm / Oracle Blog

Nuevas mejoras en el uso del elemento de tipo "Explorador de Archivos..." en Oracle APEX 5.1

En la versión de Oracle APEX 5.0 en la sección de configuración del ítem teníamos estas opciones: Tipo de Almacenamiento: Table APEX_APPLICATION_TEMP_FILES: Almacena los archivos cargados en una ubicación...
50 0 /
Arun Sirpal
Follow /16 Jan 2017 at 6:05pm / SQL Server Blog

Looking at wait stats differently with SQL 2016

Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on  sys.dm_os_wait_stats and/or sys.dm_os_waiting_tasks. Did you know from SQL 2016 you have the ability to work with wait...
54 0 /
Natik Ameen
Follow /16 Jan 2017 at 3:45pm / Oracle Blog

Help Me Help You!

Hello everyone, I hope the holidays went well for you, best of wishes from my family to yours! It is a new year and we all have new year resolutions! After years of creating blogs for you all, I have decided to turn it up a notch! As many of you already...
79 0 /
Brendan Tierney
Follow /16 Jan 2017 at 3:34pm / Oracle Blog

Explicit Semantic Analysis setup using SQL and PL/SQL

In my previous blog post I introduced the new Explicit Semantic Analysis (ESA) algorithm and gave an example of how you can build an ESA model and use it. Check out this link for that blog post. In this blog post I will show you how you can manually create...
46 0 /
Follow /16 Jan 2017 at 9:04am / SQL Server Blog

Monday Coffee 2017-01-16

I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything down because I have a bad memory or if I have a bad memory because I write everything down. About a year ago I stopped using notepads and tried...
47 0 /
Nakul Vachhrajani
Follow /16 Jan 2017 at 3:30am / SQL Server Blog

#0398 – SQL Server – SSIS – Performing a DISTINCT using the SORT transformation

Within the data flow task of a SSIS package, it is generally considered a best practice to avoid using the SORT transformation because it is a blocking transformation. In case you do need to use the SORT transformation when working with non-relational...
53 0 /
Pinal Dave
Follow /16 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – Fix – Error 15240, Severity: 16, State: 2 – Cannot write into file

I always keep playing with my virtual machine which has SQL Server installed. Recently I was trying to apply the patch of SQL Server and I was surprised to see that SQL Server was not getting started after patching. The error was Error 15240 it cannot...
56 0 /
Pinal Dave
Follow /15 Jan 2017 at 1:30am / SQL Server Blog

How to Query Multiple SQL Server with a Single Query? – Interview Question of the Week #106

Question: How to Query Multiple SQL Server with a Single Query? Answer:  One of the toughest jobs in the world is being a DBA. Trust me, I have high regards to this job because it might look easy, but it has the most stressful times when things go as...
56 0 /
Pinal Dave
Follow /14 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – SSMS Tip – Using Drag and Drop Capability

SQL Server Management Studio is an interesting tool. The more you work, the more you discover tricks from it. It doesn’t come as a surprise to how I get to know something new whenever I talk with someone. People have figured out new ways to work with...
67 0 /
Porus Homi Havewala
Follow /13 Jan 2017 at 9:28am / Oracle Blog

Database Vault: Realm violation for GRANT on RESOURCE

A friend wrote: “I enabled Database Vault (explained here ) in my database. Now the management wants me to create a new user with connect as well as resource privileges. “However, when I connect as a user with the DBV_ACCTMGR role and try...
127 0 /
Arun Sirpal
Follow /13 Jan 2017 at 4:00am / SQL Server Blog

Checking Time Zones in SQL Server

I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself as I found a way to get a time based on a geographic region. This new feature is available to … Continue reading →
57 0 /
Pinal Dave
Follow /13 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid

If you have landed on this blog by searching below error, then I must tell you that your SQL Server service is not getting started. Let us learn in this blog how to fix  The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid...
56 0 /
Svetoslav Gyurov
Follow /12 Jan 2017 at 10:51am / Oracle Blog

Unable to perform initial elastic configuration on Exadata X6

I had the pleasure to deploy another Exadata in the first week of 2017 and got my first issue this year. As we know starting with Exadata X5, Oracle introduced the concept of Elastic Configuration. Apart from allowing you to mix and match the number...
115 0 /
Pinal Dave
Follow /12 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – Why Cluster Network is Unavailable in Failover Cluster Manager?

It’s always a good experience to visit customer sites and talk to people. Sometimes I get to see things outside SQL world as well. There is a lot to learn and I believe that I can do that by sharing what I learned. In this blog post we will discuss Why...
63 0 /
Dan Hotka
Follow /11 Jan 2017 at 8:01pm / Oracle Blog

Toad Tips and Techniques

Toad Tips and Techniques Hi, 2017 is upon us. Toad ventures into another year! Toad can do so many things but I think people sometimes forget the little things that Toad has to offer. Let’s start with one of my favorite topics for people...
322 0 /
Julie Hyman
Follow /11 Jan 2017 at 5:08pm / Toad Data Point Blog

Toad Data Point 4.1 is now available.

Toad Data Point 4.1 is now available. This new release focused on… New 64-bit version of Toad Data Point. Integrated search tool that allows users to easily search Toad World and Knowledgebase articles for errors that are encountered...
45 0 /
Follow /11 Jan 2017 at 3:14pm / Oracle Blog

Kill Databump job that running inside Database

even if you interrupt data bump job on shell therefore you have to do the following :- as / as sysdba run the below query : select * from dba_datapump_jobs After checking the status of each one, run the following :- DECLARE h1 NUMBER; BEGIN h1:=DBMS_DATAPUMP...
82 0 /
Arun Sirpal
Follow /11 Jan 2017 at 10:07am / SQL Server Blog

I used to shrink my databases!

This is an entry level post and a response to SQLEspresso’s blog challenge( where we share mistakes from our “younger” days. My post takes me back 11 years and while it is nothing...
80 0 /
Pinal Dave
Follow /11 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – Query to Get the List of Logins Having System Admin (sysadmin) Permission

Though the script sounded simple to me, but I found that there are lots of incorrect scripts available on the internet.  Here is the one of the script I found to find out the details of the system admin. Please note that following script is not accurate...
91 0 /
Clarisa Maman Orfali
Follow /11 Jan 2017 at 1:21am / Oracle Blog

Nueva categoría de iconos en la versión de Apex 5.1 - Font Apex

Apex 5.1 viene ahora con un gran conjunto de iconos, tanto que nos hacía falta para nuestras aplicaciones!. Estos iconos están contenidos en una fuente llamada Font Apex y tiene una gran variedad de iconos de tipo técnicos. Esta fuente...
89 0 /
Iggy Fernandez
Follow /10 Jan 2017 at 9:10pm / Oracle Blog

The Most Important Tool for SQL Tuning

Summary: SQLT is a tool that collects comprehensive information on all aspects of a SQL performance problem. SQL tuning experts know that EXPLAIN PLAN is only the proverbial tip of the iceberg but the fact is not well recognized by the Oracle database...
1662 0 /
Deiby Gomez
Follow /10 Jan 2017 at 8:47pm / Oracle Blog

How to solve user errors with Oracle Flashback 12cR2 and its enhancements

Introduction: Flashback is a technology introduced in Oracle Database 10g to provide fixes for user errors. For example, one of the most common issues it can solve is when a DELETE operation was executed without a proper WHERE clause. Another case...
543 0 /