T-SQL Tuesday #80 – SQL Birthday Present

It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and happens to fall on the hosts birthday. First order of business is to wish our host, Chris Yates (blog|@YatesSQL), a very happy birthday! The next order of business is to hand out presents. As per Chris’s request, my present is for myself and for the community at large. For my contribution to this month’s T-SQL Tuesday, I am going to
read more

T-SQL Tuesday #50: Doing More With Less

It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is hosted this month by Hemanth.D (Blog|@SQLChow). You are invited to visit his blog to join the blog party. You are also welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: Automation! For my part in this month’s blogfest, I want to talk about a tricky data transfer
read more

T-SQL Tuesday #45 – Who's Auditing My SSIS Packages?

It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #45 is hosted this month by Mickey Stuewe (Blog|@SQLMickey). You are invited to visit her blog to join the blog party. You are also welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: Auditing! Rather than talk about SQL Audit or setting up your own auditing, I want to
read more

Presentation Files: 10 Things All BI Administrators Should Know

Presentation Files: 10 Things All BI Administrators Should Know I was very excited to get to present to the Pensacola SQL Server User Group tonight. I lived in Pensacola for a few years when I was a kid. I have a lot of memories from Pensacola like dancing to disco music on the dance floor at the Big Bang 4th of July celebration at Pensacola Beach. I wrote my first and only fan letter to a celebrity (Valerie Bertinelli) and
read more

You Got Your Integration Services in My Database Engine

You Got Your Integration Services in My Database Engine When I first looked at Object Explorer in SSMS (SQL Server Management Studio) after installing SQL Server Denali CTP1, something looked out of place. I compared Object Explorer in Denali’s SSMS to the same in SQL Server 2008 R2, and it was immediately noticeable. There is a new node called Integration Services between the Management node and the SQL Server Agent node. Click on the images to enlarge them and get
read more

How Do I Configure SSIS to Work With a Named Instance

How Do I Configure SSIS to Work With a Named Instance By default, SSIS (SQL Server Integration Services) uses the msdb database of the default instance on the server for storing packages. SSIS can still manage packages stored as files in the file system without any changes to the current setup. To be able to use the msdb database of a named instance, you have to manually edit the SSIS configuration file. Here are the steps for that: Shut down
read more

How do I …. grant access permissions for SSIS to users?

SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to follow: Run Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer Right click on MSDTSServer Click properties Click on the Security tab Select Customize and add the users/groups to the Launch/Activation and Access tabs accordingly Add the user to the local Distributed COM Users group Restart the SSIS service
read more