SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.

SQL or MDX query trace in SSRS - trick of imagination or a real thing?

by aedna-843346

SQLServerCentral.com

Blogs

I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...

SQL Saturday #50 - East Iowa

by Press Release

SQLServerCentral.com

SQL Saturday

Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.

Check Twice, Update Once

by Steve Jones

SQLServerCentral.com

Editorial

An update to the Microsoft Best Practices Analyzer tool intrigues Steve Jones as it seems to have been enhanced to better help DBAs manage SQL Server.

Restricting SecurityAdmin on SQL Server 2005/2008

by Brian Kelley

SQLServerCentral.com

Security

Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.

DMVs for Query Plan Metadata

by Additional Articles

SimpleTalk

Query plans

Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits.

How Old Are Your Database Statistics?

by GlennBerry

SQLServerCentral.com

Blogs

Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...

Parsing an ADO result set into a comma separated string in SSIS

by Garima Sharma

SQLServerCentral.com

Integration Services (SSIS)

This article describes a way to parse a result set in SSIS using For each loop container, variables and SQL task.

Where Are the Programmers?

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones has a little fun with titles in technology, and what we might start to call ourselves instead of DBAs.

What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)

by Additional Articles

Database Journal

cursors

Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.

Automatic Restart of SSIS packages after Failover or Failure

SQL or MDX query trace in SSRS - trick of imagination or a real thing?

SQL Saturday #50 - East Iowa

Check Twice, Update Once

Restricting SecurityAdmin on SQL Server 2005/2008

DMVs for Query Plan Metadata

How Old Are Your Database Statistics?

Parsing an ADO result set into a comma separated string in SSIS

Where Are the Programmers?

What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)

Blogs

Introducing the SQL Server on Kubernetes Operator

Advice I Like: Rewards from Work

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Analysis Services Model w/ Direct Query and (Default Veritpaq)

Don't Panic

Question of the Day

Identities and Sequences IV