Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • Steve Schneider
  • Page 6

Author: Steve Schneider

Determine Backup schedules across multiple SQL Servers

July 12, 2011 Steve Schneider

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…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL AdministrationBackups, SQL 2008, SQL Server 2005Leave a Comment on Determine Backup schedules across multiple SQL Servers

LinkedServer Failure — SPN not set

July 8, 2011 Steve Schneider

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? 

SQL 2005, SQL 2008Linked Server, SQL 2008Leave a Comment on LinkedServer Failure — SPN not set

Performance counter types

April 22, 2011 Steve Schneider

Learning about Performance Counters How do you interpret the value you get back for any particular performance counter?

Performance Tuning, SQL 2005, SQL 2008PerformanceLeave a Comment on Performance counter types

SQL PASS Rally

April 21, 2011 Steve Schneider

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

Performance TuningPerfmon, Performance Counters, Performance Tuning, SQL 2005, SQL 2008Leave a Comment on SQL PASS Rally

Get Alerted when your 2000 SQL cluster fails over

February 3, 2010 Steve Schneider

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

SQL 2000, SQL ClusteringSql 2000, Sql Alerts, Sql ClusterLeave a Comment on Get Alerted when your 2000 SQL cluster fails over

» Get Alerted when your 2005 SQL cluster fails over

February 1, 2010 Steve Schneider

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.

SQL 2005, SQL Clusteringcluster, Sql Alerts, SQL Server 2005, SQL Server AgentLeave a Comment on » Get Alerted when your 2005 SQL cluster fails over

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

October 14, 2009 Steve Schneider

There are many ways and twists and turns on how to get an SSIS to run and 64/32 makes even more…

SSISSQL Server 2005, SSIS packagesLeave a Comment on Ways to run SSIS packages (and their 64/32 bit impact):

Posts navigation

Previous 1 … 5 6
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes