Skip to content

Steve’s Blog

A place to find insight into SQL

Tag: SQL 2008

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 July 8, 2011

LinkedServer Failure — SPN not set

Recently, I tested a LinkedSErver and received the error: “The object invoked has disconnected from its clients.  (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (mscorlib)”

What does this mean?  Continue reading “LinkedServer Failure — SPN not set”

Posted on April 21, 2011

SQL PASS Rally

May 11, 12, 13. Steve is presenting on performance tuning in Orlando.

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