How to configure SSIS in SQL Server AlwaysOn

March 30, 2016 Andy 0

Question I have AlwaysOn Availability Group setup for my SQL Server. Now I would like to configure SSIS. How do I do it? Below link provides some information but since I am not DBA it’s difficult to understand this article: AlwaysOn Availability Groups and SQL … [Read More]

Why is the MSDB database TRUSTWORTHY?

March 24, 2016 Andy 0

Question The TRUSTWORTHY setting can be rather dangerous if you aren’t careful and except for specific circumstances the recommendation is to keep it turned off. However by default the MSDB database has TRUSTWORHTY set ON by default. I’m curious why? I’ve read this entry in … [Read More]

How to pass SSRS params into a URL

October 10, 2015 Andy 0

Question I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the action URLs to dynamically pass in parameters when switching … [Read More]