1. Notes about temporary tables support in MSSQL

    MSSQL provides wide abilities to use it’s temporary tables. I. Visible locally.

    declare @SomeTableName table ( Id int, Title nvarchar(50) ); create table #SomeTableName ( Id int, Title nvarchar(50) )
    Note that the first table will be in memory (in most cases), but second will be stored in tempDB II. Visible to everyone:
    create table ##SomeTableName ( Id int, Title nvarchar(50) )

  2. Excel 2007 Automation under Windows Server 2008 x64

    Today I’ve run into the strange problem. I developing a windows service which should generate an Excel files. I’ve tested it’s logic using unit tests and all worked fine. But then I started testing for the windows service, I saw the following strange error: …

  3. Mysql Performance Tips

    Some MySql perfomance tips from greate “How to Kill Mysql Performance” presentation

    • Use Explain
    • Use the smallest data type possible
    • Store IP addresses as INT UNSIGNED (The INET_ATON & INET_NTOA functions will help you)
    • Persistent connection is evil
    • Heavy abstraction layer is evil
    • Learn both the benefits and drawbacks of each table engine (slide 21)
    • Clustered layout is faster for lookup by primary key operations (than Non-clustered layout) (slide 26)
    • If you don't pick a primary key, one will be created for you automatically
    • Understand query cache (slide 32)
    • Don't use stored procedures (slide 34)
    • Be aware of deep scan slowdowns
    • Be aware of COUNT(*) in InnoDB table
    How to Kill Mysql Performance

  4. Using Data Contracts: be aware!

    Just another “have to know” thing. …

  5. About Me

    Hey there! My name is Michael Ayvazyan. I’m a Software Architect who works at Vayner Systems to help customers to build creative software solutions with real business impact. I’m really passionate about technology and love my family. Trying to stay fit and make some music.

    Open Source

    Way back in 2009 I created a tiny open source Database Access library Ndb Library. It was developed with Test First Development approach in mind and it implements code-centric approach to work with databases. I don’t work on it anymore since Entity Framework team shipped EF Code First as a part of the Entity Framework 4 release. Ndb Library was designed to work with different database engines (MySQL, PostgreSQL, SqLite, MSSQL Server were supported and it was not hard to add other enginses). There is another small open source project MSBuild.Scaffolding I published on Dec 8 2012. It allows to prepare solution for CI build (msbuild) using single Enable-Versioning command. …

  6. GhostDoc

    GhostDoc is an amazing tool for everyone who is using Microsoft Visual Studio. I think what it’s a “must have” extension. …

  7. Mailing Lists (on Windows)

    Recently I needed to setup several mailing lists to use in my current project. And I’ve found great solution for this - MailEnable. …