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

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 , p.permission_name, p.state_desc AS permission_state_desc from sys.database_permissions Read More...

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

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

I have just received an email from Donald Farmer , Group Program Manager for SSIS, who took great delight in telling me that his product has claimed the title of "Best ETL Software" in the Techweb Readers' Choice Awards . I don't usually Read More...

Many people like to use stored procedures as the source of data for the SSIS pipeline. In theory there is nothing wrong with that however it does have its complications. Depending on the way the stored procedure is written, it may or may not be suitable Read More...

By now you probably know that the first Community Technology Preview (CTP) of SQL Server 2005 Service Pack 2 is available. I wanted to highlight what I see as the most important addition: "Generate Script Wizard . You can now specify that the scripted Read More...