Oracle Tracing SQL Scripts

With the following code, you can enable ouput in Oracle, in order to debug your SQL scripts;

SET SERVEROUTPUT ON
DBMS_OUTPUT.ENABLE(1000000);

Then you can debug your trigger, procedure or functions by adding the following line, wherever you need an output in your code;

...
DBMS_OUTPUT.PUT_LINE('A test string.. ' | | 'another string..');

[ | | means concatenating the strings]

When you need to measure how much time is consumed between steps of your code, following may help further;

v_time := dbms_utility.get_time;
...

DBMS_OUTPUT.PUT_LINE('Time used: ' | | (dbms_utility.get_time - v_time) / 100 | | ' secs');

whereas v_time declared as number in Oracle;

declare
v_time number;

Debugging Windows Services in C# and .NET with Visual Studio 2005

You cannot debug or run a service application by pressing F5 or F11; you cannot immediately run a service or step into its code. Instead, you must install and start your service, and then attach a debugger to the service's process as follows;

1. Install your service and start the service.



2. Open the project in Visual Studio 2005.



3. Place your breakpoints at appropriate places in your code.



4. Choose "Attach to process" from the Debug menu.



5. From the available processes, look for the process created by your service. The process name will be same as the executable file of the service. (If not, choose both options "Show processes from all users" and "Show processes in all sessions")



6. After clicking on "Attach" you should be able to debug your service application.

Microsoft Certified Professionals Worldwide

Have you ever wondered how many people around the world already hold a Microsoft Certification? Just check this site.

Debugging Oracle PL/SQL from Visual Studio 2005

The new, integrated PL/SQL debugger in ODT 10.2.0.2 allows you to remain inside of Visual Studio for end-to-end debugging of your .NET and Oracle solution. You can now debug PL/SQL code such as procedures and functions (both stand-alone and packaged), object methods, and triggers from within the Visual Studio environment in the same way as you would debug your C# or VB.NET code. With the ODT integrated PL/SQL debugger, you can use traditional debugging features such as setting break points, viewing and modifying variable values, and examining the call stack.
Check this site for more information and step-by-step tutorial.

Keyboard Shortcuts for Visual Studio 2005

Have ever wanted to go to the "Last position" in your huge code just like you do in Visual Basic 6 editor?

Just click CTRL + MINUS SIGN for backward navigation, and

click CTRL + SHIFT + MINUS SIGN for forward navigation.

For the whole list of keyboard shortcuts refer to Visual C# 2005 Keyboard Shortcut Reference Poster

IIS Error and Skype

I was trying to start my IIS server recently but it could not start because of an unknown error with some number.
I've seen an entry in eventvwr.msc and searched for that in internet:
I should check whether any other process on the system uses one of http-ports (80 and 443) or better close Skype.

And really, I closed Skype and IIS worked!

My recommendation would be to check the system with TCPView from SysInternals for these ports and close the appropriate process before starting the IIS-Server.

Who started the fire?

Great Video from TeacherTube;
We didn't start the fire...