blogs.conchango.com

I don't care what any of you say, by far the most exciting announcement from today's MIX08 keynote was SQL Server Data Services (SSDS). [OK, I admit I may be in a minority on this one and I strongly suspect my colleagues in Conchango's Interactive Media team will disagree but hey, this is my blog and I'll say what I like :)] I won't go into ...

Two days ago I posted a blog entry here that showed how the following SQL statement:   select dp.NAME AS principal_name,           dp.type_desc AS principal_type_desc,           o.NAME AS object_name,           ...

SQL Server Books Online (BOL) has improved dramatically in SQL Server 2005. I'm not necassarily talking about the content (though that IS better I feel), I'm talking about the ability to provide feedback about the articles. What's great is that if you use the 'Send Feedback' link in BOL your comments get emailed ...

Today I was asked how one can query the server to list out all permissions that a principal has on all the securables in a SQL Server database. After 10 mins of searching through BOL I came up with the following that seems to work quite well:    1 select dp.NAME AS ...