Welcome to MSDN Blogs Sign in | Join | Help

May 2008 - Posts

VSTS Database Edition having problem creating UnitTests
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.Shell.Interop.ISelectionContainer Read More...
Changing the Login / Authentication Mode programmtically via SMO
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. You Read More...
Obfuscation is not a security feature – Spoofing the APP_NAME
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 Read More...
Merge it your own way - Comparison of SQLAdapter vs. SQLCommand vs. MERGE
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 Read More...
Page view tracker