2015 was a good year

I have been blogging from here for the past 8 years and I have a great audience. This year has been a very good year if I go by the number of posts.

The audience is world wide and I hope I have been able to help some. I feel good, if I can help someone who is beginning to do things from some corner of this earth which is further away from the hub of things.

December 2015 views curtsey of ClusterMaps.com

Technology changes very fast, to keep pace with changing technology is not always easy. Hardware, software, and platforms change very fast and it is impossible to track these changes easily. New languages and new paradims are created like almost everyday. Help of any kind is welcome. It is to provide this help this blog was created.

HodentekHelp wishes you all a very happy and productive New Year. May your wishes come true.

2014 was a mixed year

2014 was a mixed year. I lost my brother Dr. Vijaya Raghavan Krishnaswamy, a neuro-surgeon by profession. He left a void that cannot be filled.

I did not complete the book I was writing.

Regarding the blogs I did quite well with a record number of posts.
                                                 Year   Posts
Hodentek.blogspot.com           2013   94
                                                 2014   246

HodentekHelp.blogspot.com.  2013.  17
                                                 2014   56

HodentekMsss.blogspot.com   2013   34
                                                  2014  48
 
HoentekMobile.blogspot.com  2013   13
                                                  2014  

I started a new blog in 2014- http://hodentekPlus.blogspot.com.

I also found that a certain person was pilfering (http://hodentek.blogspot.in/2014/12/domain-name-service-dns-and-dns-changer.html) entire content from blog, my hardwork of about 10 years. I complained to Google without any success. I suppose this is not on Google's priority. Google wants every post that is stolen with proof of content stolen. There were over 900 posts in my blog and you can imagine the work involved.
 

Breaking News: Packt finished publishing its 1000th Book

Aloha,

Packt is celebrating and I have been a part of this success story. Particpate in the celebration and get a free eBook to mark this occasion.

Just go to Packt's web site and register yourself if you are not already registered. The rest is simple.

If you are looking for jump starting your SQL Server / Applications you search for eBook versions of my books shown here:

Good luck

Mahalo

How do I set up a Data Connection in Visual Studio 2008?

It depends on where the data comes from, SQL Server, IBM DB2, MS Access etc.

Here is what you do for SQL Server 2008.

Step 1: Open Visual Studio 2008
            Click View | Server Explorer
            Click on Connection as shown.

The Add Connection window shows up

Step 2: Click on the Change...button




The Change Data Source window gets displayed.

















Step 3: Highlight Microsoft SQL Server
            Click OK




Step 4: Click on the Refresh button
            Then click on the drop-down button
The SQL Servers on your machine should show up as in the figure
            Choose the SQL Server 2008 as shown by highlighting Hodentek2\SANGAM

Step 5: Assuming the SQL Server 2008 is to be Windows Authenticated
       Click on the drop-down handle for 'Select or enter a database name:"
       Select AdventureWorksDW2008 as shown

.

Step 6: Click on Test Connection button
You should get the following message

Step 7: Click OK to the message and close the Add Connection window.
You are done.

Now you will see your connection in the Data Connections folder in Server Explorer
Now you can access Tables, Views, Stored Procedures and Functions within the Visual Studio IDE

Well I have a number of other connections in my VS 2008 IDE.