Expert Blogs - Toad World

Expert Blogs


Nakul Vachhrajani
Follow /26 Sep 2016 at 4:30am / SQL Server Blog

#0387 – SQL Server – Script to find source backups used in a database restore

Often, in development and test environments, one needs to trace the backups used to restore a particular database. Here is a script to easily get this information.
21 0 /
Pinal Dave
Follow /26 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – Patch Installation Error: The version of SQL Server instance does not match the version

Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error. The version of SQL Server instance <InstanceName> does not match the version expected...
27 0 /
Pinal Dave
Follow /25 Sep 2016 at 2:30am / SQL Server Blog

Identify Used Space in Log File- Interview Question of the Week #090

Question: How to identify Used Space in Log File? Answer: Use following command to display used log file size and total used space in the logfile. DBCC SQLPERF('LOGSPACE') After running above DBCC command it will give the following results...
30 0 /
Follow /24 Sep 2016 at 5:29pm / SQL Server Blog

PowerShell, Pester and Ola Hallengrens Maintenance Solution

If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way to ensure that all of your essential database maintenance is performed. You can also watch a video...
22 0 /
Pinal Dave
Follow /24 Sep 2016 at 2:30am / SQL Server Blog

PowerShell – Reading Tables Data Using Script

Earlier in this blog, I have written a number of posts by using PowerShell. The more you play around with this scripting language more are the hidden gems that come out. Personally for me, everyday is like a new learning that needs to be discovered working...
62 0 /
Denny Cherry
Follow /23 Sep 2016 at 7:31pm / SQL Server Blog

Recommended reading from mrdenny for September 23, 2016

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. SQLSweet16!, Episode 7: Install Option for Instant File Initialization SQL Server on Xeon Phi? VMware Announces Alliances and Strategies...
22 0 /
Michael J. Swart
Follow /23 Sep 2016 at 1:37pm / SQL Server Blog

Build Your Own Tools

There are so many ways to look inside SQL Server. New extended events and dynamic management views are introduced every version. But if you want to collect something that’s unavailable, with a little bit of creativity, you can create your own tools...
122 0 /
Jen Stirrup
Follow /23 Sep 2016 at 9:34am / SQL Server Blog

Are you a data Thought Leader? Call for speakers for Thought Leadership podcast series

Credit: MPI Group As part of the Business Analytics Portfolio, I am spearheading a series of Thought Leadership podcasts and I am looking for people to be interviewed in a ‘fireside chat’ format. I am bringing together experts from our...
60 0 /
Pinal Dave
Follow /23 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – How to Join a Table Valued Function with a Database Table

Just another day I received following question and I find it very interesting. I decided to try it out on SQL Server 2016’s new WideWorldImporters database. The question was – “How to Join a Table Valued Function with a Database Table...
71 0 /
Sten Vesterli
Follow /22 Sep 2016 at 3:35pm / Oracle Blog

Oracle Cloud: Gone Without Warning

I was using a trial of an Oracle Cloud service to demonstrate the capability for a customer. He just called me to say that the sample I built for him was gone. Indeed it was, because it was 30 days since I requested the trial. It turns out you don't...
245 3 /
Follow /22 Sep 2016 at 12:24pm / SQL Server Blog

Changing connection colours in SQL Server Management Studio

A simple but effective setting in SQL Server Management Studio is using custom colours to identify which server you are about to execute a query on. It’s simple to setup but not everyone who uses SSMS is aware of it so I thought I’d quickly...
65 0 /
Pinal Dave
Follow /22 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

As many of you know, I am an indecent SQL Server Consultant , who purely focus on SQL Server Performance. Every single day, I keep two slots each hour long available for users who need my help urgently. I never ever pre-book them because, I believe it...
71 0 /
Clarisa Maman Orfali
Follow /21 Sep 2016 at 7:12pm / Oracle Blog

Usando Font-Awesome en nuestros Reportes en Oracle APEX 5

Desde que salió la versión 5 de APEX, los iconos de Font-Awesome están incluidos para ser usados en nuestras aplicaciones, especialmente en los botones. También tenemos la posibilidad de usar estos iconos en nuestros reportes...
71 0 /
Sten Vesterli
Follow /21 Sep 2016 at 6:43pm / Oracle Blog

Application Builder Cloud Service

I just had the opportunity to participate in an Application Builder Cloud Service Hands-On Lab here at Oracle OpenWorld, and this is a very promising product. The development experience is somewhat similar to Application Express (APEX) in that you...
325 0 /
Dan Hotka
Follow /21 Sep 2016 at 4:45pm / Oracle Blog

Agile Methodology/Team Programming

Hi, I’m at Oracle Open World this week. Will be blogging on the things I can chat about from the ACE Briefing. Of course, anything mentioned during Open Week is fair game to discuss…and I will! This blog will discuss Agile, a newer...
101 0 /
Dan Hotka
Follow /21 Sep 2016 at 4:43pm / Oracle Blog

Oracle Block Internals - Part 4

Hi! This series of articles have been focused on Oracle RDBMS data block internals. I’ve discussed how Oracle manages space in the blocks, how row level locking works (how more than one user can be making changes to rows in the same blocks),...
79 0 /
James Serra
Follow /21 Sep 2016 at 4:00pm / SQL Server Blog

Making sense of Microsoft technology

In my role as a Data Platform Solution Architect (DPSA) at Microsoft, part of my responsibility is to keep up with all the Microsoft on-prem and cloud data-related technology and trends, as well as non-Microsoft technology and trends in areas such as...
57 0 /
Follow /21 Sep 2016 at 3:00pm / SQL Server Blog

Failover Cluster Manager Connection Error Fix

A few days ago I encountered a new error with Failover Cluster Manager.  A couple of servers had been rebuilt to upgrade them from Windows Server 2008 to 2012. They were added back to the cluster successfully. However, one of the servers would not open...
59 0 /
Kenneth Fisher
Follow /21 Sep 2016 at 2:00pm / SQL Server Blog

A quick fix for a full identity column.

A while back I wrote a post on everything I knew about identity columns . In it I mentioned the following: Negative increments can be handy if your identity column has reached the max value of the data type. Reseed to 0 (assuming that is where you...
94 0 /
Pinal Dave
Follow /21 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – How to Hide Number of Rows Affected Message? – SET NOCOUNT

This blog post be ideally titled as back to basics as it is going to talk about one of the very old topics of SQL Server. Though this may look very simple for many, this blog post conveys the message which many experts would like to revisit in their code...
82 0 /
Fernando Garcia
Follow /21 Sep 2016 at 1:11am / NoSQL Blog

Ejecutando consultas en MongoDB

En MongoDB, la operación de lectura nos permite recuperar documentos de una colección. Siendo MongoDB una base NoSQL, no podemos contar con el famoso y poderoso comando SELECT. Pues bien, ¿cómo implementa MongoDB la operación...
84 0 /
Jen Stirrup
Follow /21 Sep 2016 at 1:03am / SQL Server Blog

Is the MVP Program becoming less technical?

Alt Title: how did you get to be an MVP, Jen Stirrup? The skinny answer: no idea, it’s Microsoft’s Award to give or take away at any point. I am going to have some fun here, and I’d like you to join me. Full fat: Something I’ve...
78 0 /
Steven Feuerstein
Follow /20 Sep 2016 at 2:54pm / Oracle Blog

PL/SQL 101: Three ways to get error message/stack in PL/SQL

The PL/SQL Challenge quiz for 10 September - 16 September 2016 explored the different ways you can obtain the error message / stack in PL/SQL. Note: an error stack is a sequence of multiple error messages that can occur when an exception is propagated...
110 0 /
Arun Sirpal
Follow /20 Sep 2016 at 10:34am / SQL Server Blog

SSMS Keeps Crashing

It is quite frustrating when SSMS (SQL Server Management Studio) randomly crashes, all too often for my liking. If you have the following screen shot then read on. Digging into the event logs I noticed the following error: Faulting application name...
22 0 /
Ed Elliott
Follow /20 Sep 2016 at 7:16am / SQL Server Blog

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we would be told to work on something, write the code + tests, deploy to a test environment, prove it works and deploy - this is the cycle time and the faster...
98 0 /