Connecting Windows 7 Workgroup to Windows 2008 Server

We recently upgraded our machines. The old ones were Windows XP running on 32-bit dual core processors. The new ones are with Core-i7 processors and had Windows 7 Professional (64 bit) preinstalled.

In our existing setup, we have one windows 2008 machine and many windows XP machines.  The PCs are connected in a Workgroup, and the server is used mainly as a DHCP server, internet access and for common file sharing. There were no issues till now accessing the Windows 2008 Server from the existing Windows XP machines.

Now, in the new Windows 7 machines we found a peculiar problem. Everything worked as expected, except that we are not able to access the shared folders on windows 2008 server … Read the full article »

Simple Text-Only WebBrowser

This is a continuation of my previous article:
Add Undo/Redo or Back/Forward functionality to your application

In the last article we constructed a class that would help us add Undo/Redo or Back/Forward functionality to our application. We read about the capabilities of the class, but a working example was missing.
In this article we will see how to create a text-only web browser for ourselves. These kinds of browsers are useful in various situations. However I won’t go into details about that at present.
The link to source code as well as executable file is given at the end of this article.
So, first we will create the basics of the web-browser, and then later on we will see how to add the Back/Forward capabilities to it. … Read the full article »

Executing a set of SQL Script Files (*.sql) on a Group of SQL Server Databases

This post is a continuation of my pervious articles:

In the last part, I showed how to extract attachments from the emails. In this part, we will see how to execute them in a batch on a number of SQL Server databases. … Read the full article »

Extracting Attachments from Selected Emails

This is a continuation of the article “Automating the Process of Extracting *.sql Attachments from Emails and Executing them on a set of SQL Server Databases”. If you have not read that article, I recommend you do that before proceeding further.

The Problem

Find a way to extract all attachments from selected emails into a selected folder on hard-drive.

The Solution

  1. Open Microsoft Outlook.
  2. Click Tools > Macro > Visual Basic Editor (or press Alt+F11) to open the VBA Editor. … Read the full article »

Automating the Process of Extracting *.sql Attachments from Emails and Executing them on a set of SQL Server Databases

Recently I was off on a long leave from my work. After returning to office, I found that there are so many emails accumulated in my inbox, and many of them contained SQL script files to be executed on my local SQL Server test databases. Extracting each file into a folder and then executing each of these files (*.sql files) on each database was just like the task I always hate. There were some hundred of these attachments, and each file had to be executed on about 6 databases. So if I do everything manually, it will take me days to finish this.

So I set off for making a script that will automate this. … Read the full article »

To my Blog Readers

First things first. My apologies for not updating the blog for quite sometime now.

The past few months have been pretty difficult for me. I lost my wife and the only son in a train accident. After months of severe depression, I managed to pull myself back into reality. You can now expect to see some new entries in the blog pretty soon  🙂

Pradeep

Microsoft MVP again!

I got awarded Microsoft MVP (Visual Basic) again today.

I want to say a huge THANK YOU to Microsoft, my MVP Lead Abhishek Kant, the Visual Basic Team and anyone else who contributed in getting me the MVP award again. It is a recognition of contributions to the Technical Communities worldwide and I’m quite proud of it. 🙂

Posted in MVP. 6 Comments »