Expert Blogs - Toad World

Expert Blogs

Blogs

James Serra
Follow /18 Jan 2017 at 4:00pm / SQL Server Blog

Microsoft Products vs Hadoop/OSS Products

Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads.  This means Microsoft will provide customers the best environment to run their big data/Hadoop as well as a place where Microsoft can...
2 0 /
Steven Feuerstein
Follow /18 Jan 2017 at 12:57pm / Oracle Blog

Emulating a finally clause in PL/SQL

PL/SQL does not support a finally clause, as many other languages do, including Java. Here's a description of the finally block from the Java SE doc: The finally block always executes when the try block exits. This ensures that the finally block is...
20 0 /
Henrik Loeser
Follow /18 Jan 2017 at 11:19am / IBM DB2 Blog

Context Path Routing of Apps and Services in Bluemix

11 0 /
Arun Sirpal
Follow /18 Jan 2017 at 3:00am / SQL Server Blog

SQL database built-in intelligence

I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in Azure. SQL database has built-in intelligence and with that intelligence it may recommend an elastic pool setup if it’s more …...
39 0 /
Pinal Dave
Follow /18 Jan 2017 at 1:30am / SQL Server Blog

SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key

Along with performance consulting, sometimes I also get requests from a few clients to look at the AlwaysOn availability group related problems. ENVIORNMENT: Three node AlwaysOn availability group with multi-subnet cluster with two nodes (SQL-A and...
38 0 /
Michael McLaughlin
Follow /18 Jan 2017 at 1:22am / Oracle Blog

Tips & Techniues - PL/SQL Object Table Function

This article covers how to write PL/SQL object table functions. PL/SQL object table functions provide you with a powerful technique to solve complex query problems. You can use object table functions to return result sets that you can’t write as...
75 0 /
Deepak Vohra
Follow /17 Jan 2017 at 8:26pm / Oracle Blog

DevOps for Docker - A Trend for 2017

Docker container has revolutionized the use of software with its modularity, platform independence, efficient use of resources, and fast installation time. Docker lends itself to the DevOps approach to software development. This article looks at the technology...
46 0 /
Paul Turley
Follow /17 Jan 2017 at 7:54pm / SQL Server Blog

Publish Power BI Reports to SSRS On-premise Preview Now Available

This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available”  This feature addition will allow Power BI reports to be published to a local SQL Server Reporting...
43 0 /
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...
64 0 /
Henrik Loeser
Follow /17 Jan 2017 at 3:44pm / IBM DB2 Blog

Bluemix: Simplified Deployment of Complex Cloud Foundry Apps

11 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...
58 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...
61 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...
59 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...
96 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...
56 0 /
DBAFromTheCold
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...
55 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...
59 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...
60 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...
66 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...
71 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...
142 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 →
60 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...
59 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...
120 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...
67 0 /