Archive for the ‘SQL’ Category
IIS 6 Peformance Paper
Thursday, March 24th, 2005IIS 6 Peformance Paper - Worth the read
By Brett ‘brett’ Hill on IISFAQ Front Page
Papers from Microsoft are often hit and miss. Some are stellar and some are overbroad overviews filled with marketing jargon. This one, however, is well worth the read. He’s an excerpt from Web and Application Server Infrastructure - Performance and Scalability
COM General
With the new IIS 6.0 architecture, it is important to question some of the existing guidelines where COM is concerned. A major consideration is that, before Windows Server 2003, COM application components were configured (by default) to run out-of-processes from the caller. The default for COM applications is for them to run as Server Applications, executing in a DLLHost.exe process called into from the object instantiate, or over DCOM.
The performance downside of doing this for every method call, is that there are extra threads running on the system, and every call to a method must be marshaled across process boundaries. This is not noticeable on a small implementation with low request/transaction rates, but on a high volume, large multiprocessor, this kind of overhead can greatly decrease the overall scalability of the system.
Therefore, on Windows Server 2003, it is best to change the default configuration for a COM Server Application to Library Application to aid scalability of the calling per use of that application
interesting Query Analyzer for Windows users
Tuesday, February 8th, 2005QueryCommander is a Open Source Query Analyzer that you can use to work with the following Databases.
Automating build and deployment process to web servers
Tuesday, January 18th, 2005I have found the following useful items for my project at work to automate our deployment process.
Keyboard shortcuts
Thursday, November 20th, 20031. Learn the basics of all Microsoft products’ keyboard shortcuts.
2. Become expert in Visual Studio .NET keyboard shortcuts.
3. Serve some speed with SQL Server shortcuts.
4. Mozilla browsers go here, IE browsers go here and select your IE version.
5. Do you use Google? Of course you do. Check out Google Labs’ experimental Keyboard Shortcuts searching.
Free SQL tools
Friday, October 24th, 2003I saw SQLspy on Mike Gunderloy’s blog today. It looks like a good quick and dirty tool to monitor MSSQL. HybridX has some other intresting tools on his site including Addon’s to SQLspy and SQLinsider.
Which brings me to another point, why must some web developers feel the need to restrict the ability to right click just to “prevent” someone stealing their images. Anyone with half a brain will realize the image is in their browser cache or can use an alternative browser such as Opera or my favorite MozillaFirebird. Are you still stuck in IE with no tabs and advanced features. You might as well be using AOL then.
Sorry for the rant.