Shoot Louise

Posted by Sem Dendoncker on September 1st, 2010

This summer I had the pleasure of doing some new shoots.
One of them was with this great model Louise Sigalas.

The shoot took place on 3 locations in and around Kortrijk.

The first location was the park where the 4 windmills are located (at the highway E17 near Zwevegem).
(Click on the images to view the gallery)



The second location was at the “Libelle” located in “The Marionetten green area“.



The third and last location was the new hospital (Groeninghe) near the Kennedy Park.
This hospital has a very specific architecture which allowed us to play with the composition.



More info about the camera settings and strobe settings can be found on flickr.

Cheers,
Mayiko

How to retrieve the number of connections on your MS SQL Database.

Posted by Sem Dendoncker on August 31st, 2010

Hello,

To receive the number of connections on a database you can use the following query:

SELECT
    DB_NAME(dbid) as DBName,
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE
    dbid > 0
GROUP BY
    dbid, loginame

Cheers,
Sem (aka Mayiko)

Cookiemanager (C#)

Posted by Sem Dendoncker on June 11th, 2010

Hello,

In many of my applications I need to transfer the data from one page to another.
I used to do this by using a session but the thing with sessions is that they are unreliable.
You never know when they will disappear. There are several possibilities that a session can disappear (session timeout, application needs more memory, …).

The I thought about another way to do this. Then I thought why not using encrypted querystrings but that idea was countered real hard on stackoverflow.com (http://stackoverflow.com/questions/2989703/how-can-you-secure-encrypt-your-querystring-in-asp-net).

Finally I used one of the suggested solutions, why not putting your essential data into a cookie.
Therefore I’ve created an object called “CookieManager”.

Basically it works as a dictionary that contains all the properties you like/want.
You can add/remove properties (with their values) very easely.

This is the code to add a property

CookieManager manager = new CookieManager(cookieName, true);
manager.SetPropertyValue(property, value)

This is the code to get the value of a property

CookieManager manager = new CookieManager(cookieName, true);
manager.GetPropertyValue(property);

This is the code to remove a property

CookieManager manager = new CookieManager(cookieName, true);
manager.RemoveProperty(property);

Easy no?

I’m still working on a full manual for the manager, but the object is so easy to use anyone could use it.
For the ones who would like to have the sourcecode, just leave a comment and I’ll email it to you.

You can download the dll here

Cheers,
M.


Copyright © 2007 Sem Dendoncker. All rights reserved.