Mijn dochter is deze week 2 maand geworden.  Wat gaat de tijd toch snel.
Het is een echt schatje, wat een lievertje.

Om een en ander ook aan de wereld te tonen, heb ik wat van onze laatste foto's gepubliceerd. (zie album "Liesbeth's 2e maand".

In the never-ending quest for tools that make life easier, I was introduced to a new contenter: SQL Prompt.  This tool gives you intellisense for SQL Server!

• code completion
• keyword formatting
• code snippets
• uppercasing of keyworkds

And the best feature: it's free !

Hmm, at least it's free until it's officially released on Oct 3rd.  So try it out if you're interested.?

http://www.red-gate.com/products/SQL_Prompt/index....

My ex-colleague Diederik wrote an interesting query to easily find unused indexes and indexes that are not performing
Here's the article: http://www.realdn.net/msblog/PermaLink,guid,0f133d...

All credits to Diederik.

I've added a few missing spaces to the query to get it running:

    -- Used Indexes: Reads and Updates
    SELECT    object_name(s.object_id) AS ObjectName
            , ISNULL(i.name, '(Heap)') AS IndexName
            , user_seeks AS IndexSeeks
            , user_scans AS TableScans
            , user_lookups AS LookUps
            , user_seeks + user_scans + user_lookups AS TotalReads
            , user_updates AS Updates
            , CASE
                WHEN (user_seeks + user_scans - user_updates < 0) THEN'Updates > Reads'
                WHEN (user_seeks < user_scans) THEN'Scans > Seeks'
                ELSE' '
             END AS Warning
    FROM    sys.dm_db_index_usage_stats s
            INNER JOIN sys.indexes i
            ON  i.object_id = s.object_id
            AND i.index_id = s.index_id
    WHERE   database_id = DB_ID()
    AND     objectproperty(s.object_id,'IsUserTable') = 1
    
    UNION

    -- Unused Indexes
    SELECT    object_name(i.object_id)
            , ISNULL(i.name, '(Heap)')
            , 0, 0, 0, 0, 0
            , 'Not used'
    FROM    sys.indexes i
            LEFT JOIN sys.dm_db_index_usage_stats s
            ON  s.object_id = i.object_id
            AND i.index_id = s.index_id
            AND s.database_id = DB_ID()
    WHERE   objectproperty(i.object_id, 'IsIndexable') = 1
    AND     s.index_id is null

    ORDER BY 1 ASC, 6 DESC, 7 DESC

Cool new technology from Google: Google spreadsheets allows online collaboration on spreadsheets from anywhere (if you have an internet connection).

We're currently using it to share some specifications between team members in different locations and it works like a charm.

This is the URL if you want to try it out: spreadsheets.google.com

Apparently it's immensely difficult again to hire decent developers in the Belgian job market.  It starts to look like the situation before the year 2000.

If you're a (more or less) experienced J2EE/.Net developer, have a look at: http://www.pearlchain.net/jobs.html
http://job.monster.be/jobsearch.asp