As you may know by now, the Toad Extension for Visual Studio makes it possible to integrate your database schema changes into a continuous integration or continuous build deployment scenario. But when it comes to *actually* configuring it in Team Foundation Server, what's needed? Take a look in this post at a quick walkthru of the process.

A few years ago I wrote a blog titled “Run Toad off a USB Flash Drive”. It’s been a fairly popular blog, but it’s also quite out dated now – so I thought I’d update it.

The original blog had several shortcomings – mainly that it was specific to (i.e. only tested against) the current version of Toad at...

Toad is a powerful tool. It can do a lot of work in a short amount of time. This work can be destructive. I maintain both a development and production instance. How bad would it be if I accidently dropped or truncated a table mistakenly in the wrong database?

Of course I can only perform the tasks in the database which my login privileges allow. Even with all the safeguards, we can, and often do, still make mistakes.

...

I really enjoy when I get to present to an audience that asks questions and interacts with me during the presentation.  The interaction does two things for me:  1.  validates that what I’m presenting is helpful to the audience and 2.  forces me to continually understand the underlying technology and how our products interact with said technology.  Sometimes point #2 is the result of a pause-inducing “huh?” moment spawned by...

Database developers and DBAs often play the role of gunslinger, or a hired gunman. Someone brought in to ‘kill’ the bad guy, in this case, an under-performing database. Our tools of the trade are not as dramatic as firearms, but we can do just as much damage.

Every heard of Angry Birds? In this mobile game, users get various weapons (in the form of Angry Birds) to launch at the naughty piggies.

What are your favorite weapons?

...

I discovered something curious today. Check out the following block; it runs without any compilation or runtime error:

DECLARE   l_char   CHAR (1);   CURSOR x   IS      SELECT dummy INTO l_char FROM DUAL;BEGIN   OPEN x;   FETCH x INTO l_char;   CLOSE x;END;  

Can anyone see why I find it odd and curious? I have sent a note to the PL/SQL Product Manager asking what he thinks. What do you think?

 

...

（原文： “BATCH OPTIMIZER PART 6 - USING BATCH OPTIMIZATION WITH RULE BASED OPTIMIZER” 原文投稿日期：2008年 8月12日 星期二）

（原文： “BATCH OPTIMIZER PART 5 – VIEWING THE SQL ALTERNATIVES AND EXECUTION RUN TIME STATISTICS” 原文投稿日期：2008年5月23日 星期五）

（原文： “BATCH OPTIMIZER PART 4 – OPTIONS SETTINGS FOR THE BATCH OPTIMIZER” 原文投稿日期：2008年5月9日 星期五）

（原文： “BATCH OPTIMIZER PART 3 – OPTIONS SETTINGS FOR THE BATCH OPTIMIZER” 原文投稿日期：2008年4月25日 星期五）

（原文： “BATCH OPTIMIZER PART 2 – OPTIONS SETTINGS FOR THE BATCH OPTIMIZER” 原文投稿日期：2008年4月10日 星期四）

（原文： “BATCH OPTIMIZER PART 1 – HOW THE BATCH OPTIMIZER WORKS?” 原文投稿日期：2008年3月28日 星期五）

（原文： “HOW TO USE THE QUEST SQL OPTIMIZER” 原文投稿日期：2008年3月18日 星期二）

I’ve always thought that the open source community were somewhat masochistic, or at least borderline workaholics. It seems “like doing a lot of hard work for no pay” to me. Why do it at all? Don’t you have a life…?! (Sure, some are probably the proverbial "basement dwellers," I know!) This was an interesting snippet from an anthropological study conducted on the RedHat Fedora community between the Fedora 12 and Fedora 13 releases...

For all you Oracle DBAs out there, have you often wished there was a better way to manage your Oracle RMAN backups? Have you often asked yourself - is there some way to have a single, consolidated report of which backups executed successfully, which failed, what type they were, how much space they consumed, whether there were policy violations, some sort of health check?

For Part I, please visit:  How to Use Quest SQL Optimizer to Tune Data Warehouse SQL – Part I

 

A Data Warehouse (DW) is a database system used in an organization to collect data from one or more data sources and is typically used to generate reports or...

（原文： “WHAT ABOUT A SELF-LEARNING SQL OPTIMIZER?” 作者：虹天软件(珠海)有限公司 杜伟业(Richard To） 原文投稿日期：2007年10月9日 星期二）

（原文： “A SQL PERFORMANCE HISTORY FROM AWR” 作者：虹天软件(珠海)有限公司 杜伟业(Richard To） 原文投稿日期：2007年9月13日 星期四）