The stopping/restarting could pontentially be done in T-SQL as well (Sp_start_job, sp_stop_job).

However be sure that if you re-run packages that they can restart themselves without issue and not do the...

I agree with bt if you can rewrite all code to use stored procs.

If you want to be 100% sure, or can't change code, use a trigger. Be sure you...

CirquedeSQLeil (7/19/2010)

---

Jack Corbett (7/19/2010)

---

If you mean volunteer for the Summit, there is...

CirquedeSQLeil (7/19/2010)

---

This is my official announcement on my candidacy for the PASS Board. I WILL be supporting the community through my endeavors as a volunteer as an unelected unofficial...

Sore.

A long weekend

If you have a list of servers, I believe the Microsoft Baseline Security Analyzer will help

http://technet.microsoft.com/en-us/security/cc184924.aspx

Likely there is some 2008 task that will not run on 2005. You probably cannot do this as you are going downlevel and sending something to the 2005 server that...

Look in these areas:

- logins

- agent jobs

- packages

- linked servers

Everything will have some downtime for connected sessions. Clustering, mirroring, logs, all would require a disconnect, reconnect for users.

I would lean towards mirroring as a way to minimize this.

I don't believe there is in 2005. In 2008 there is the management data warehouse, which should capture this.

I like Roy's advice. However if you are going to cache writes, you need to be sure you have battery backed controllers as an issue could cause you problems here....

I believe this is a place where you'd need a tally table the calculates the 15 minute increments and then outer join with that.

Essentially build a table of 15 minute...

Grant Fritchey (7/19/2010)

---

Jack Corbett (7/19/2010)

---

Thanks all for your confidence, but don't commit your votes until I make it past the nominating committee AND you find out what I think PASS...

I'd say the thing to become is valuable. Show that you are contributing to the business and worth keeping around for the things you do.

That is correct, but backup commands for SQL Server are issued in T-SQL, not through Windows.