So true. We haven't yet moved to having multiple AGs on a server so this supports one AG per SQL Server Instance.

We have it set to execute when SQL Server Agent starts and then every 1 minute. In reality the script is doing a while loop so it's always running

I've been using this stored procedure to trigger two jobs:

Job 1 is "Assumed Primary AG Role" and Job 2 is "Assumed Secondary AG Role"

Then in each of these...

I agree. I like the comments in the stored procedure. I work in a company where each department and group within the department have their own source control - most...

Great scripts and useful for so many purposes.:-)

May I have it as well?

If someone can forward me the info, I would appreciate it. Just switched jobs and love this tool.

As a person currently struggling with a new OBIEE deployment, keep in mind that sans experienced java application administrators, OBIEE is very challenging to work with.

Quite frankly the...

Thank you very much. All I needed to do was change this:

<TablixRowHierarchy>

<TablixMembers>

...

Thank you very much for taking the time to explain this out. This is my first 64 bit SQL2005 box. I have 32 gigs of memory so I'll try...

We're running SQL 2005 Standard Edition.

The server in general is very fast and we're happy with it's performance for all applications and processes except the Weblogic 8.1

Currently I have...

Is the server the database is setup on dedicated to SQL Server? - YES

Did you set the lock pages in memory option? - NO

Did you set the max memory...

We're using Config files for all our SSIS packages to improve their portability. Then if I need to switch between two accounts for an SSIS package, I can just...