URmy.Net

My Tips, Tricks and References

Grant Alter Trace Permission SQL Server Profiler

Published on December 31, 2010January 21, 2015 by Zachary Lyons

SQL Server Profiler requires you to have ALTER TRACE permission. There are two ways to grant that permission. Properties: Object Explorer -> Security -> Logins -> your_login -> Securables -> Search button -> “The server” radio button -> “Grant” checkbox on “Alter Trace” SQL: GRANT ALTER TRACE TO myuser

Entity Framework Count Related Entities Without Loading

Published on December 31, 2010January 21, 2015 by matt

I ran across this post on Stack Overflow. Here is the code I ended up using: Dim count = (From x In db.Orders Where x.OrderID = orderID From y In x.OrderDetails Select y).Count

How to Hash Passwords for XML Files

Published on December 10, 2010January 21, 2015 by Zachary Lyons

To save a password hash to an XML file, you can call this function: FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text & "|" & txtUsername.Text, "SHA1") You can see my attempt at a password salt by simply apppending the Username.