Archive for the ‘SQL’ Category

MSDN Security Developer Center: The Trustworthy Computing Security Development Lifecycle

Sunday, April 17th, 2005

A look at Microsoft’s internal SDL with the new Trustworthy Computing initiative.

IIS 6 Peformance Paper

Thursday, March 24th, 2005

IIS 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, 2005

QueryCommander is a Open Source Query Analyzer that you can use to work with the following Databases.

  • Microsoft SQL Server 2000
  • Microsoft SQL Server 2005 (YUKON)
  • Microsoft SQL Server 6.5
  • MySQL 4.x
  • Oracle 9i (the “edit-in-grid” functionality is not yet implemented)
  • Automating build and deployment process to web servers

    Tuesday, January 18th, 2005

    I have found the following useful items for my project at work to automate our deployment process.

  • Deployment/Building of Web Applications - TSS.net
  • Nant FAQ
  • NantContrib
  • Continuous Database Integration
  • Using NAnt Build and Deploy .Net Applications
  • Managing Sourcecode with Nant
  • Managing .NET Development with NAnt
  • Continuous Integration
  • Red Gate releases SQL Packager, a SQL Server deployment tool
  • Mike Lorengo’s Weblog - Refrigerators, Unit Testing & NAnt
  • Keyboard shortcuts

    Thursday, November 20th, 2003

    1.   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, 2003

    I 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.