Developer hearted / Relational minded

SQL Server 2005 introduced an interesting and long demanded feature, the LOGON triggers. First only defined via server event triggers, it has become more and more popular in same scenarios to prevent users with a certain machine environment accessing...

Here are some instructions how to change the Login / authentication mode via Code. It just uses plain SMO capabilites: After this you will have to make sure that the Service is restarted, if you want this to do via SMO look at the following sample...

As some of you might already encountered and found this blog entry while searching the internet, there can be a problem having certain installtion levels of the Data Dude installed on your machines. The error message is: The service Microsoft.VisualStudio...

The question which always comes up in my sessions about SQL Server 2008 is according to my most loved feature in SQL Server 2008, the MERGE command. People always ask me how the performance comparison with MERGE is compared to some standard / traditional...