-
Performance of .Net Code in SQL Server 2005
-
Some interesting numbers from Novick. A good read too. Read the article.
-
Detecting and Resolving Stalled and Stuck I/O Issues in SQL Server 2000 SP 4
-
Guest columnist Robert Dorr explores how the reporting tool in SQL Server 2000 Service Pack 4 significantly reduces the time it takes to identify and determine the underlying causes of stalled and stuck I/O operations. Read it here.
I have had an opportunity to listen to Dorr in a recent conference. All I have to say is, he has been really exceptional and toooo good.
-
Importing XML Data to Word 2003 Using Visual Studio Tools for Office
-
Learn about importing XML data from a database into Word documents using Visual Studio Tools for Office, Version 2003. Learn to create a document programmatically that contains a button control allowing the user to access a database. Catch it on MSDN.
-
TechEd in Paradise
-
Whew !!! What a location to have TechEd !!! I just got back from the TechEd Sri Lanka tour and am really excited to say it was amazing. Even though I had a tough lineup of back to back sessions with about 5 Sessions in the database track, I really loved each and every topic myself. Having said that I was running cold and fever for most part of the stay. But, SODA, XML & CLR Best Practices, SQL Server 2005 Tools, SSIS, Security in SQL Server 2005 were the topics I had to take. (Personally) except SODA which I did as per the plan of using the PPT way of talk, I resorted to the free flow mode for rest of the topics. Because I could sense that most of the attendees were not fluent / exposed to SQL Server 2005 very much. So I used this as opportunity to talk about the basics, architecture and the details of the topics in discussion.
Overall, I presume the ratings were also good :) !!! More importantly I was satisfied talking to people in general after every session. Nevertheless the TechEd Party on Thursday evening was a blast with many gifts for the participants including XBox series, bags and even a trip to Bangkok. The organizers were really professional in their approach and my hats off to their efforts.
Hoping to meet the people in future TechEd's too.
-
SriLanka TechEd 2005
-
Will you be there !!! Dont forget to meet me at the database track ...
-
MVP Summit PR Work
-
Here is the PR work done for the MVP Summit held two weeks back. A good read for people who would like to become MVP like us.
BTW, on a slightly different note I become SQL Server MVP for the third year !!! I am happy to share the same with you folks.
-
The MSDN Subscription Evolution
-
In conjunction with the release of Microsoft Visual Studio 2005, Microsoft is launching a new line of MSDN Subscription levels, as well as revising several existing subscription levels and enhancing the subscription benefit and administration tools. In this webcast, learn what each of the new subscription levels has to offer, as well as the transition paths for existing subscribers.
Catch the webcast here.
-
Regenerate the package ID in SSIS
-
In Microsoft SQL Server 2005 Integration Services (SSIS), a 16-byte GUID is generated and stored as the PackageID property of a SSIS package when the SSIS package is created. After you run the package, you can write the package ID to a log file by using the SSIS log provider. This package ID differentiates log entries for different packages
Read this KB article that explains this process.
-
Communicating with Analysis Services
-
Do ADO MD.NET and XMLA clients communicate differently with a SQL Server 2000 Analysis Services instance than with a SQL Server 2005 Analysis Services instance?
A good explanation on the WinITPro Site.