Expert Blogs - Toad World

Expert Blogs


Nassyam Basha
Follow /22 Oct 2016 at 3:34pm / Oracle Blog

DB Link between Oracle and MSSQL and resulted “internal error in heterogeneous remote agent”

DB Link between Oracle and MSSQL and resulted “internal error in heterogeneous remote agent” This blog post based on the experience with one of customer, it is so simple but i rarely worked on these heterogeneous db links, so am writing for...
25 0 /
Nassyam Basha
Follow /22 Oct 2016 at 3:18pm / Oracle Blog

Know size of all databases from OMR – #EM

Know size of all databases from OMR – #EM I have been asked to know all the databases size and export them in excel file, that’s all!!!  We are using EM 11.1 of course old but that is no matter for me and in total we have 173 target databases...
28 0 /
Nassyam Basha
Follow /22 Oct 2016 at 2:58pm / Oracle Blog

ORA-3113 End of communication channel with Select query vs sqlnet.ora

ORA-3113 End of communication channel with Select query vs sqlnet.ora This blog post writing based on the recent issue i’ve seen, Let’s start, customer reported as connection to the database from the client version 11gR2 was successful...
29 0 /
Syed Jaffar Hussain
Follow /22 Oct 2016 at 10:53am / Oracle Blog

Is Fixed Objects Stats needed in PDB?

Doesn't matter if we are working on a new technology or something we are very family with. When we encounter tricky situations, sometimes neither we could find things in the manuals nor could find any useful references. All what you need is an action...
38 0 /
Brendan Tierney
Follow /22 Oct 2016 at 10:41am / Oracle Blog

Our first OUG Ireland Meet-up

Last Thursday evening (20th October) we had our first Meet-up event for OUG Ireland. Up to recently we have had a one or two full day SIG events that covered both the Tech and BA/Big Data areas. But we have been finding it increasingly difficult to get...
43 0 /
Pinal Dave
Follow /22 Oct 2016 at 2:30am / SQL Server Blog

PowerShell – Tip: How to Format PowerShell Script Output?

I have been writing on various ways of working with PowerShell and how to connect to SQL Server. Personally, when I see text on command prompt it is quite a mess and very difficult to decipher the same. If you play around and look at various blog posts...
42 0 /
Melissa Coates
Follow /22 Oct 2016 at 12:55am / SQL Server Blog

Why You Want to Use the Latest SQL Server Management Studio Release

We have two main built-in tools for interacting with a SQL Server database platorm: SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT). This post is about SSMS and why you may want to install the latest release...even if you're not...
14 0 /
Chris Webb
Follow /21 Oct 2016 at 7:43pm / SQL Server Blog

Nested Variables In DAX

Last week, at the SQL Server Days conference in Belgium, Kasper mentioned in his presentation that it was possible to define variables inside variables in DAX. So, for example, you could define a measure like so: MyMeasure = var Outer1 = var...
12 0 /
Stuart Ainsworth
Follow /21 Oct 2016 at 4:27pm / SQL Server Blog

One (Last) Trip to the Emerald City for #SQLPASS

On Monday, I’m flying out to the Emerald City (Seattle, WA) for the annual gathering of Microsoft database geeks known as the PASS Summit ; as always, I’m excited to see friends and learn new stuff. However, this will probably be my last Summit...
17 0 /
Pinal Dave
Follow /21 Oct 2016 at 2:30am / SQL Server Blog

PowerShell Scripts – get-process with SQL Server process

Working with powershell scripts can be interesting. I have in the past shown a number of such scripts that we can use with SQL Server. In this blog, I was playing around understanding how I can use the get-process commandlet and how it can be used with...
52 0 /
Kellyn PotVin
Follow /20 Oct 2016 at 10:23pm / Oracle Blog

User Group Boards, Voting, Oh Yeah and ODTUG

I think we’ve just about all heard enough about voting this election year, but I want to discuss a slightly different angle and that’s when it comes to user groups.  As most people know, I’m pretty passionate about everyone contributing...
32 0 /
Gokhan Atil
Follow /20 Oct 2016 at 9:28pm / Oracle Blog

EM13c: Get List of URLs Monitored by Beacons

When you need to monitor web services, you can use EM beacons. A beacon is a target that allows the EM Agent to remotely monitor services. You can add beacons to any EM agent using “Add Non-Host Targets by Specifying Target Monitoring Properties”...
105 0 /
Sten Vesterli
Follow /20 Oct 2016 at 8:10pm / Oracle Blog

Critical Patch Update Oct 2016 - Serious WebLogic Issues

It’s that time of year again - the last Oracle Critical Patch Update for 2016 . With 253 fixes, it’s another big one, though not as big as the previous one. Bad news especially for WebLogic users - three different issues with a scary 9...
278 0 /
Craig Mullins
Follow /20 Oct 2016 at 7:48pm / IBM DB2 Blog

Using Extended Indicator Variables in DB2 for z/OS

As you all should know by now, version 10 of DB2 for z/OS greatly expands support for indicator variables. Those of you who write programs that must handle results that could be null should know what an indicator variable is. Basically, DB2 represents...
68 0 /
Kellyn PotVin
Follow /20 Oct 2016 at 7:22pm / Oracle Blog

Pass Summit 2016 and Old School MSSQL DBA Skills

I’ll be attending my very first Pass Summit next week and I’m really psyched!  Its an amazing event and for those of you who are my Oracle peeps, wondering what Summit is, think Oracle Open World for the Microsoft SQL Server expert folks....
28 0 /
Thomas LaRock
Follow /20 Oct 2016 at 6:50pm / SQL Server Blog

How To View Always Encrypted Data in SQL Server Management Studio

One of the shiny new features in SQL Server 2016 is Always Encrypted. Here's how you can view the plain text data inside of SQL Server Management Studio. The post How To View Always Encrypted Data in SQL Server Management Studio appeared first on...
84 0 /
John Dorlon
Follow /20 Oct 2016 at 5:44pm / Toad for Oracle Blog

New in Toad's Automation Designer: Query Iterator

This blog contains references to features that will be released in Toad for Oracle version 12.11, starting with the first beta. An iterator is a control component in Toad’s Automation Designer which runs child actions multiple times, once for...
64 0 /
Jen Stirrup
Follow /20 Oct 2016 at 10:28am / SQL Server Blog

Top 5 Signposts to deep technical expertise at PASS Summit 2016

How do you find deep technical expertise at PASS Summit 2016? Signpost Number 1: Watch Joseph Sirosh’s Day One keynote. Attend in person if you can, or watch the live stream on PASS TV if you can’t. The world around us – every business...
52 0 /
Pinal Dave
Follow /20 Oct 2016 at 2:30am / SQL Server Blog

SQL SERVER – How to Avoid Triggers for Multiple Row Operations in a Table

Customers have a unique way to give you challenges that you never faced. It was one of those evenings that I was working late night on some SQL activity when I received a mail from one of my very old customers. It is rare that I get a ping from them and...
63 0 /
Arun Sirpal
Follow /20 Oct 2016 at 2:03am / SQL Server Blog

Another way to move SQL DB to Azure

About 8 months ago I wrote an article ( ) where I showed you how to migrate your “earth” SQL Database to Azure using a BACPAC import. If you look at the following diagram I will now show you the...
63 0 /
Follow /20 Oct 2016 at 12:29am / SQL Server Blog

PASS Summit 2016 – Invest in Your SQL Server Future

Have you registered yet for PASS Summit 2016 , October 25-28 in Seattle? “Of course I have,” you say confidently. “Reserved my hotel, booked my flight and packed my bags two weeks ago. I’ve got this.” Or maybe . . ...
492 0 /
Denny Cherry
Follow /19 Oct 2016 at 9:10pm / SQL Server Blog

Obscurity is not Security

We’ve all heard the argument that using a different TCP port number for SQL, other than 1433, is more secure.  Here’s the truth, it isn’t.  Andy said it best here in a conversation on Twitter that happened in the #sqlhelp hash tag. ...
37 0 /
James Serra
Follow /19 Oct 2016 at 4:00pm / SQL Server Blog

Data Warehouse Fast Track for SQL Server 2016

Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to deliver validated, pre-configured solutions that reduce the complexity of implementing a data warehouse on SQL Server Enterprise Edition...
36 0 /
Steven Feuerstein
Follow /19 Oct 2016 at 3:16pm / Oracle Blog

Weird SQL Behavior? No. And the Importance of Table Aliases.

I received this email yesterday with a question about "weird SQL behavior". I wrote a SQL delete statement with a select statement in its where clause. I made a mistake and forgot to create a column in the table that I used in the subquery....
66 0 /
Kenneth Fisher
Follow /19 Oct 2016 at 2:00pm / SQL Server Blog

Installing SQLCMD

For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says anything I want to point out that yes, I realize that you can use Powershell instead. Of course not all of us know Powershell...
39 0 /