Expert Blogs - Toad World

Expert Blogs

Blogs

Gokhan Atil
Follow /26 Feb 2017 at 9:12am / Oracle Blog

Create Blackout for Multiple Targets on EM13c

The notifications emails of a “planned” downtime is one of the annoying things of monitoring systems. You forget creating blackout and you start a maintenance work, and you get lots of notifications mails. Most of the time, the target which...
12 0 /
Nakul Vachhrajani
Follow /25 Feb 2017 at 10:48am / SQL Server Blog

Temporary Post Used For Theme Detection (c4769b6a-7865-40b8-ab68-fa0a485a54d4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (ac944c77-2264-440f-9cad-287c14d43701 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)Filed under: #SQLServer
55 0 /
Pinal Dave
Follow /25 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – Event ID 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name)

While trying to start SQL Service for a named instance, I got an error message related to event id 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name). Here is the text of the error which...
40 0 /
Henrik Loeser
Follow /24 Feb 2017 at 2:22pm / IBM DB2 Blog

Securing Workloads on IBM Cloud - Some Resources

21 0 /
Pinal Dave
Follow /24 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.

A very old client of mine yesterday pinged me with this question about error related to QUOTED_IDENTIFIER. “Pinal, When I run my query it works just fine in SSMS but when I run it via SQL Server Agent Job, it gives me following error. Can you...
57 0 /
Henrik Loeser
Follow /23 Feb 2017 at 10:14am / IBM DB2 Blog

Location and Intent Matter: Data Privacy vs. US Government

20 0 /
Pinal Dave
Follow /23 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost

It is very common for people to move databases now a days to the cloud. The very first question I often hear from them is – How to Improve Application Performance on Cloud While Reducing Bandwidth Cost? However, once the data is moved to any cloud...
61 0 /
John Dorlon
Follow /22 Feb 2017 at 10:07pm / Toad for Oracle Blog

How to create reports in Toad for Oracle with multiple non-related datasets

Toad's Report's Manager has been around for a while, and it's great at making pretty reports of either a single dataset, a simple master-detail dataset, or complex master-detail datasets with multiple detail datasets hanging off of the master...
74 0 /
Michael J. Swart
Follow /22 Feb 2017 at 1:00pm / SQL Server Blog

A Program to Find INSERT Statements That Don’t Specify Columns

Unlike mathematical relations, SQL tables have ordered columns, but please don’t depend on it. In other words, try to treat these tables as the same because it’s super-awkward to turn one into the other: CREATE TABLE PEOPLE ( ...
116 0 /
Arun Sirpal
Follow /22 Feb 2017 at 9:45am / SQL Server Blog

SSMS Presenter Mode

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not recommended for production use. There are many enhancements which you can read here: https://docs.microsoft.com/en...
88 0 /
Vinoth Nm
Follow /21 Feb 2017 at 2:29pm / SQL Server Blog

Quick Tips:- Add SQL User/Rolemember to all Databases in SQL Server

Most of times when you have dedicated SQL Server for an Application clients come up with a request to add a user to all databases in the SQL Server with certain permission, while its east to do it via SSMS for if the system has only couple of databases...
62 0 /
Pinal Dave
Follow /21 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup

While playing with my SQL Server startup parameter, I made some mistakes and came to a situation where SQL Server was not getting started. In this blog post, let us learn about error 17113. Whenever you have a situation where SQL is not getting started...
80 0 /
Arun Sirpal
Follow /21 Feb 2017 at 1:30am / SQL Server Blog

SQL Server vNext: sys.dm_db_stats_histogram

Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for SQL Server 2016 Service Pack … Continue reading...
67 0 /
Thomas LaRock
Follow /20 Feb 2017 at 1:23pm / SQL Server Blog

SQL Slammer Is Back. Here’s What You Need to Know

First reported back in 2002, the SQL Slammer virus caught fire in January of 2003, and spread worldwide. The post SQL Slammer Is Back. Here’s What You Need to Know appeared first on Thomas LaRock . If you liked this post then consider subscribing...
144 0 /
Henrik Loeser
Follow /20 Feb 2017 at 12:50pm / IBM DB2 Blog

Write Your Own CLI Plugins for Bluemix Cloud Foundry

24 0 /
Arun Sirpal
Follow /20 Feb 2017 at 12:01pm / SQL Server Blog

Setting up SQL Server to SQL Database (Azure) Replication

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed a selection of tables that I wanted to off-load to Azure.  For this post I will be going through the … Continue reading →
78 0 /
DBAFromTheCold
Follow /20 Feb 2017 at 9:00am / SQL Server Blog

Monday Coffee 2017-02-20

No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat has never been cleaner! So last week Microsoft announced Availability Groups for SQL Server on Linux . This is a big announcement as one...
63 0 /
Pinal Dave
Follow /20 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – Fix: Error 946, Severity: 14 – Cannot open database ‘DB’ version 782. Upgrade the database to the latest version

I was consulting a client for migration from SQL 2014 to SQL 2016. They were using methodology discussed in books online here. https://msdn.microsoft.com/en-us/library/dn178483.aspx  (Upgrading AlwaysOn Availability Group Replica Instances). Let us learn...
93 0 /
Pinal Dave
Follow /19 Feb 2017 at 1:30am / SQL Server Blog

How to Keep Certain Records on Top While Ordering Data? – Interview Question of the Week #110

Question : How to Keep Certain Records on Top While Ordering Data? Let me elaborate this question as it is originally received. “Hi Pinal, I just returned from an interview and I faced a very strange question. I was asked following question...
85 0 /
Pinal Dave
Follow /18 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – Cannot open backup device. Operating system error 1326 (Logon failure: unknown user name or bad password.)

There might be various reasons for above error, but this case is very specific to a situation where SQL Server was installed on a machine which was in Workgroup whereas the backup destination was the server located in the domain.  Here is the error message...
113 0 /
Paul Turley
Follow /17 Feb 2017 at 4:17pm / SQL Server Blog

Gartner Magic Quadrant for BI 2017 Top 3 Rankings

This is a different spin on the top three vendor rankings visualized in Power BI.  According to the placement of the chart elements in the “Visionary/Leader” quadrant, Microsoft leads Tableau by a little over 36% in the “Vision Completeness “ score and...
142 0 /
Bert Scalzo
Follow /17 Feb 2017 at 2:14pm / Oracle Blog

Speaking at the Annual IOUG Collaborate Conference

I’ll be speaking at the annual IOUG Collaborate Conference in Las Vegas April 3 rd and 5 th . To quote their website: The Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and Quest International Users Group (Quest...
151 0 /
Bert Scalzo
Follow /17 Feb 2017 at 1:49pm / Oracle Blog

Speaking at the Annual Hotsos Symposium

I’ll be speaking at the annual Hotsos Symposium in Dallas TX February 27 th and 28 th . To quote their website: Hotsos is the best conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience...
151 0 /
Henrik Loeser
Follow /17 Feb 2017 at 8:35am / IBM DB2 Blog

Carnival: Even DB2 Wears a Mask (Database Security)

43 0 /
Dinesh Asanka
Follow /17 Feb 2017 at 3:20am / SQL Server Blog

The Future of Managing Databases in a Hybrid IT World

When you work in information technology long enough, you get to see how people react when something new comes along. Some people embrace change, even to the point of being an early adopter. Others might use a wait-and-see approach. And then there is the...
94 0 /