Expert Blogs - Toad World

Expert Blogs

Blogs

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...
25 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...
5 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...
47 0 /
Henrik Loeser
Follow /20 Feb 2017 at 12:50pm / IBM DB2 Blog

Write Your Own CLI Plugins for Bluemix Cloud Foundry

15 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 →
47 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...
41 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...
57 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...
65 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...
74 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...
104 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...
85 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...
86 0 /
Henrik Loeser
Follow /17 Feb 2017 at 8:35am / IBM DB2 Blog

Carnival: Even DB2 Wears a Mask (Database Security)

37 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...
74 0 /
Pinal Dave
Follow /17 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage

Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109 . In this blog post we will see a powershell script for Removing Old SQL Database...
64 0 /
Arun Sirpal
Follow /16 Feb 2017 at 10:00am / SQL Server Blog

True story: Encryption in progress stuck

Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the following: (source: https://msdn.microsoft.com/en-us/library...
77 0 /
Pinal Dave
Follow /16 Feb 2017 at 2:07am / SQL Server Blog

SQL SERVER – FIX: Msg 15281- SQL Server Blocked Access to Procedure ‘sys.xp_cmdshell’ of Component ‘xp_cmdshell’

One of my blog readers pinged me on Skype and asked a simple question. I always thought I had a blog written about this error, but I was wrong. So, this blog is the outcome of a short interaction with my blog reader. Let us learn about how to fix blocked...
91 0 /
Steven Feuerstein
Follow /15 Feb 2017 at 7:07pm / Oracle Blog

Enhanced Whitelist Management in 12.2

Way back in Oracle Database 12c Release 1, the PL/SQL team added whitelisting to the language. This means you can use the ACCESSIBLE BY clause to specify the "white list" of program units that are allowed to invoke another program unit (schema...
127 0 /
Clarisa Maman Orfali
Follow /15 Feb 2017 at 4:32pm / Oracle Blog

Cómo crear una Instancia de la Base de Datos Oracle en Amazon RDS - Parte 2

En la primera parte de este artículo hemos visto cómo crear una cuenta en Amazon AWS para poder tener acceso al servicio RDS además de haber creado el usuario IAM. Para ingresar a la consola de administrador de AWS, accedemos a...
178 0 /
Clarisa Maman Orfali
Follow /15 Feb 2017 at 4:00pm / Oracle Blog

Cómo crear una instancia de la Base de Datos Oracle en Amazon RDS - Parte 1

En los tiempos en que vivimos, conocer los avances de la tecnología y cómo todo está orientado a la nube, me hizo pensar que es momento de empezar a incursionar en este tema y por ello he tenido la oportunidad de aprender un poco...
215 0 /
Arun Sirpal
Follow /15 Feb 2017 at 6:00am / SQL Server Blog

Azure Advisor Recommendations

Logging into the Azure portal is a daily task of mine and my eyes light up when I see features in preview mode. With that being said Azure Advisor Recommendations is what I will be writing about today. What is … Continue reading →
79 0 /
Pinal Dave
Follow /15 Feb 2017 at 1:30am / SQL Server Blog

SQL SERVER – FIX: Msg 7356, Level 16 – The OLE DB provider “ASEOLEDB” for linked server “SYBASESERVER” supplied inconsistent metadata for a column

In SQL Server, we can create linked server to many other RDBMS. The providers to connect would generally publish by destination RBMS. In this client scenario, they were dealing with linked server to Sybase. Let us learn about the error The OLE DB provider...
89 0 /
John Dorlon
Follow /14 Feb 2017 at 5:38pm / Toad for Oracle Blog

Compare and Sync Multiple Tables with Toad

Available starting in Toad 12.11.0.40. Toad Expert Edition or DB Admin Module is required For a long time, Toad has had a window that lets you compare table/view/mview data, and Sync it if you have the Toad Professional Edition or DB Admin Module....
134 0 /
Thomas LaRock
Follow /14 Feb 2017 at 8:26am / SQL Server Blog

What Does a DBA Do All Day?

It is clear to me that no one, except for database administrators, has any idea what a DBA does all day long: The post What Does a DBA Do All Day? appeared first on Thomas LaRock . If you liked this post then consider subscribing to the IS [NOT] NULL...
155 0 /
o.mustafaoracle
Follow /13 Feb 2017 at 10:44pm / Oracle Blog

Oracle 12.2 is Now Available on E-delivery

We was waiting Oracle database 12cR2 and now dream come true You can download oracle Enterprise edition 12cR2 from Oracle Edelivery Here Follow the steps :- Enjoy Osama
185 0 /