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 ...

For those of you interested in what's new in SSIS in service pack 2, here are a couple of resources: New Features: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm#BKMK_IntegrationServices Bug fixes: http://support.microsoft.com/default.aspx/kb/921896 Note that in SP1 there were alot ...

In case you hadn't picked this up on the grapevine already, Microsoft and Bob Beauchemin SQL Skills have jointly released a whitepaper that talks about connectivity issues that you may come across in SSIS. Check it out here: http://ssis.wik.is/Connectivity_White_Paper   -Jamie