Skip to content

Steve’s Blog

A place to find insight into SQL

Tag: SQL Server 2005

Posted on July 12, 2011

Determine Backup schedules across multiple SQL Servers

Today some architecture changes were scheduled to occur in the evening.  I wanted to adjust or disable backup jobs that could be affected.  I have some 50 SQL servers.  I needed to know when the backups were to start on each server.  I found a nice script at http://www.mssqltips.com/tip.asp?tip=1622to do that for a single server.  Continue reading “Determine Backup schedules across multiple SQL Servers”

Posted on February 1, 2010

» Get Alerted when your 2005 SQL cluster fails over

Today, I want to show how to be alerted any time one of your clustered SQL 2005 server fails over.  This will work whether some admin fails it over on purpose, or accidentally.

Continue reading “» Get Alerted when your 2005 SQL cluster fails over”

Posted on October 14, 2009

Ways to run SSIS packages (and their 64/32 bit impact):

What ARE the ways to run SSIS packages?  Actually, I can think of 5…

Continue reading “Ways to run SSIS packages (and their 64/32 bit impact):”

Recent Posts

  • Steve is presenting at PASS Data Community SUMMIT!
  • WordPress Resources at SiteGround
  • Import tab delimited data files directly into SQL Server via SSMS
  • Using SQL to read from a web service
  • SQL Saturday May 2016, Jacksonville, FL

Recent Comments

  • A WordPress Commenter on WordPress Resources at SiteGround
  • Julien on SSRS subscriptions not working
  • sql010 on DB mail Query parameter not working
  • aweinca on Backup Script to replace xp_sqlmaint
  • mike hill on ASSP.dll…super great functionality

Archives

  • November 2021
  • October 2017
  • June 2016
  • May 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • April 2015
  • June 2014
  • April 2014
  • August 2013
  • July 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • April 2011
  • February 2010
  • October 2009

Categories

  • Azure
  • Career
  • Machine Learning
  • Performance Tuning
  • PowerBI
  • SharePoint 2013
  • SQL 2000
  • SQL 2005
  • SQL 2008
  • SQL 2012
  • SQL Administration
  • SQL Clustering
  • SSAS
  • SSAS 2012
  • SSIS
  • SSRS
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress