Wednesday, August 10, 2005

What is Linked Server?

Linked Server is a feature in SQL Server that allows access to other databases, similar to accessing a SQL Server DB. As the name suggests it "links" to other servers, either other SQL Servers or other DBs on non-windows Servers (i.e. Oracle, DB2, etc.).

The easiest way to create a Linked Server is through Enterprise Manager.
  1. In the left pane, expand the objects down to the desired server, where the Linked Server will be created.
  2. Expand Databases of the desired server and click on the "Security" Folder
  3. Right Click on "Linked Servers" and select "New Linked Server". Specify all the parameters for the server to be linked to.
After a Linked Server has been created, it should be accessed using a four-part name syntax (see http://clevelanddotnet.blogspot.com/2005/07/what-is-four-part-name-in-sql-server.html for more information.)

Monday, August 8, 2005

What is DPM?

DMP (Data Protection Manager) is a new Microsoft product to aid with data backup and restore operations. The latest beta version for the 2006 version was recently released to the public. To read more about DPM and download the beta, go to http://www.microsoft.com/windowsserversystem/dpm/default.mspx.

Tuesday, August 2, 2005

Intel’s Early Access Program (EAP)

Intel’s Early Access Program (EAP) was designed to support independent software vendors (ISV’s). If you are not an ISV, the Intel Software Developer Network http://www.intel.com/cd/ids/developer/asmo-na/eng/index.htm will be a good resource for you.

Listed below are the benefits of EAP.

The Early Access Program www.intel.com/ids is Intel Developer Service's comprehensive web-based resource, helping developer’s take advantage of the processing power available from cutting-edge Intel processors. Some of the highlights include the use of a next generation development system, software optimization tools, training courses, technical support, business development, marketing and promotional activities. Please look over the website as it goes into greater detail about the opportunities, as well as the advantages of being in the program.

Costs associated with the Early Access Program: There is an annual membership fee of $500.00.

ISV’s can register for EAP by following these steps below:

These agreements require a Director or higher signature


Go to www.intel.com/ids/EAP.

Click on the Blue “Enroll Now” on the Right hand side of the screen. In the Members Options Box

You will be directed to the Intel Login page. Click on the blue “click here to register.”

Put your information in the appropriate fields (the password is case sensitive and requires at least one number and special character...Example: * / + etc.)

Fill in all the fields marked with a blue asterisk.

To gain access to the program, the contact person must have a job title of Director or higher. Examples of job titles are VP, President, CEO, CTO, CIO, etc. Due to sensitive information that will be traded, this requirement protects your company and Intel. Once your company is a member of the Early Access Program, a different contact person within your company can work with the Intel account manager.

When all three pages are completed, click on “Finished”.

Check the boxes of all the programs you are interested in participating and click "Continue".

This page will ask if you already have a CNDA and IPLA agreement with Intel. Please click “NO” for both, since these online agreements are newer and updated. It will ask you “How do you expect to perform your optimization/porting” put Unsure at this Point. Then click "Continue".

This next page gives you two options: Choose “Option 1 - Online click through” or “Option 2 - Download, Print, and Mail” by checking the box next to the desired option. Click the “Continue” button after choosing one of the options. Option 1 is preferred and will expedite your membership process. This is where the VP (or higher) title is required.

If you choose the click through membership agreements, you must check the “I accept” box located directly below the text.

After completing all membership agreement pages, you will find yourself on a “Membership Agreements” page thanking you and a bunch of other great stuff. At the bottom of this page you will have three options to choose from and a continue button. Choose the “Go to My Early Access Program Home Page” and click “Continue”. At this point it will give you the option to download the agreements that you just signed.

You have now completed the Registration process! Please email me so that I may inform our Administrator that your application has been submitted.

Please contact me with any questions/comments/concerns. I look forward to hearing from you.

Kindest regards,

Jared Gibbons
Intel Corporation
801.622.9615

Monday, August 1, 2005

Can SharePoint be used to authenticate users for a web app?

Q: I’m developing a web application for a client. I wanted to ask if it’s possible to integrate with SharePoint to authenticate users through the SharePoint site and then link to the web app with those credentials?


A: Yes, it's definitely possible. Usually SharePoint is setup with Integrated authentication in IIS. If your web app uses the same login/password to access the app, then these credentials can be "passed through" to the app from SharePoint. Just setup your app virtual directory to have integrated security.

Also, here are some things to consider:
1. Do you want the "application" to run within a SharePoint page? Maybe consider writing a .NET web part then.

2. Do you want the "application to run within the context of SharePoint (access to the SharePoint object model)? Then you have to put the app in a specific vdir location (_layouts folder) in order for it to work with SharePoint. This is documented in the SharePoint SDK.

3. Is the app running on the same server as SharePoint? If so, then you either need to exclude the virtual directory for the app from the managed paths or create a new web site and put it there.

Thanks to Nate B. for his help with this issue.

Thursday, July 28, 2005

Virtual CD/DVD-ROM Emulator

Daemon Tools offers a virtual CD/DVD-ROM emulator that is able to emulate nearly all known copy protections on the market today. The product can be downloaded from http://www.disc-tools.com/download/daemon

After installing the emulator, simply access the .ISO image of the CD/DVD, and you're done. This is especially useful when doing a remote software install. Although there are other similar products on the market, also free of charge, the advantages of Daemon tools are :

1. Small footprint on the HD
2. Easy to use
3. Less problematic than other products.

Tuesday, July 26, 2005

ComponentOne 10% Discount

ComponentOne is offering a special summer promotion for the C#/VB.Net SIG members. For those interested, a 10% discount is available off of any ComponentOne Development tools. The Promo code for this offer is "devten". This Promo is valid up until September 30, 2005. For more information, please feel free to e-mail Karen Dansak (karend@componentone.com).

Monday, July 25, 2005

What is Vista?

"Vista" is the official name for Microsoft's new client operating system, formerly known as Longhorn. Currently Beta 1 is scheduled for release on August 3, 2005, with the production release due in 2006. Why the name change? Microsoft has not yet officially stated the reason for the name change. However, some think it's a marketing strategy that will allow Microsoft to distance itself from the "Longhorn" name and the delays associated with it.

Although not much has been said by the software maker, 2 links can be found on Microsoft's web site.

http://www.microsoft.com/windowsvista/default.mspx
http://www.microsoft.com/presspass/press/2005/jul05/07-22LHMA.mspx

Friday, July 22, 2005

Visual Studio .NET IDE for Linux!

It's true...well sort of! A new product from Mainsoft allows applications to be built using Microsoft's Visual Studio.Net to run in the Linux environment. Listed below is the link with more information and a free 30-day evaluation download.

http://dev.mainsoft.com/Default.aspx?tabid=45

Friday, July 15, 2005

Debugging is not supported under current trust level settings.

If you're attempting to debug a web application/service and you encounter the following error:

Debugging is not supported under current trust level settings.

What can you do to resolve it? Simply increase the trust level by placing the following line (in XML format) in the web.config file of the application:

trust level="Full" originUrl=""

This line should be inserted inside the system.web tags. This will increase the trust level of the app and allow interactive debugging.

What is a Four-part name in SQL Server?

When accessing a linked server in SQL Server, a four-part name should be used. This naming convention requires the 4 fields (linkserver, catalog, schema, and table) to be specified in a hierarchal format, such as:

SELECT *
FROM LINKSERVER_NAME.CATALOG_NAME.SCHEMA_NAME.TABLE_NAME

Please note the field names should be specified in UPPERCASE, especially when accessing a DB2 Database, otherwise the following error will occur:

Server: Msg 7314, Level 16, State 1, Line 1OLE DB provider 'LINKSERVER_NAME' does not contain table '"CATALOG_NAME"."SCHEMA_NAME"."TABLE_NAME"'. The table either does not exist or the current user does not have permissions on that table.OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='LINKSERVER_NAME', TableName='"CATALOG_NAME"."SCHEMA_NAME"."TABLE_NAME"'].

Saturday, July 9, 2005

Visual Studio Keyboard Shortcuts

[SHIFT ]+ [ALT] + [ENTER] = Toggle Full Screen Mode; I'm sure this works in all versions, but I haven't tested it, as I'm running the 1.1 framework. I'm told it also continues to work in Whidbey.

[CTRL]+[i] = Incremental Search. I've stopped using [CTRL]+[F] to find. Incremental search works without a dialog box, and searches as you type. So you're in a class, and you want to find the word public.

[CTRL]+[i] puts you into Incremental Search Mode, now just start typing. When you've found what you're looking for press [ESC] to get out of incremental search mode. Remember the famous [F3] is find again, and works with this incremental search also.

[CTRL] + [-] = Move cursor back to it's last position. This works great when working with large pages. I commonly will [CTRL]+[Home] to enter a Using statement, then [CTRL]+[-] brings me rights back to my previous edit point.

[CTRL] + [}] = Toggle to Open/Close { }. This is great. If you're working with nested code (who doesn't) then you'll use this constantly. Place your cursor on any { or } and press [CTRL] + [}] and your cursor will jump to the opposite end of your code block.

[CTRL] + [C] = Copy.[CTRL] + [V] = Paste. Of course we all know that combination, but here's the trick. Copy two items in succession. You might know that these items are placed on a "Clipboard Ring" You can access them from the UI but that entails thinking, and clicking and dragging. [CTRL]+[SHIFT]+[V] = Paste whatever is on top of the "Clipboard Ring". If you press [CTRL]+[SHIFT]+[V] again, since your pasted code is still highlighted, it will be replaced with the second item, and again, will be the third, etc. How many times do you have to copy two or three items from one page to another (none if you're refactoring; right)?

[CTRL]+[ALT]+[P] = Show Processes. This is a great, fast way to open the processes window. Why do that? Use it daily to attach to the ASP.net worker process. This let's you dive 15 pages deep into a web application, and attach to the process, so you don't have to run through the 15 pages every time you debug.

[CTRL]+[ALT]+[R] = Launch MSDN Home Page

The full article can be found at http://scottcate.mykb.com/Article_9BB34.aspx

Wednesday, July 6, 2005

Tuesday, July 5, 2005

Future of VB.Net

For some reason VB.Net seems to be surrounded by many myths. The latest rumor is that its days are numbered and will soon be gone after VS.Net 2.0 is released. Nothing could be further from the truth! For years Microsoft has been supporting VB as a RAD (Rapid Application Development) Tool, and this is still true.

My experience from attending Microsoft training seminars and talking to other professionals in the field is that VB is here to stay and will not be replaced by C#. The only speculations I have heard were on blogs, but nothing official from Microsoft. Besides, both C# and VB.Net are very similar in most aspects with very few differences. In Whidbey, these differences are even less. It is true that more companies are looking for C# experience over VB by 60/40 margin. This is not to say that VB is dying. To further make my case, I went straight to the source for confirmation. Listed below is an email from Rick Brewis, a Microsoft employee, and previous speaker at the last SIG meeting.


Sam,

I had a chance to speak with one of our Developer Evangelists about VB.NET. He emphasized that VB.Net is here for the long haul and Microsoft continues to invest in enhancing the product. In fact, Microsoft is 100% committed to VB.NET going forward. To emphasize the fact that VB.NET has a strong future, please see the article referenced below discussing the great language enhancements for VB.NET in VS2005.

http://msdn.microsoft.com/vbasic/default.aspx?pull=/library/en-us/dnvs05/html/LanguageEnhancements.asp

Also, here’s a link to 2 free MS Press books on VB.NET development in VS2005 that you can share with the SIG:

http://msdn.microsoft.com/vbasic/whidbey/introto2005/
http://msdn.microsoft.com/vbrun/staythepath/additionalresources/upgradingvb6/

I hope you find this information helpful. Let me know if you need anything else.

Regards,

Rick
Rick Brewis
Microsoft


Like I always say: when in doubt, go straight to the source!