Skip to content
Steve's Blog

Steve’s Blog

A place to find insight into SQL

Scroll down to content

Posts

Posted on July 13, 2011

Multiple SQL Server Error log search

In Yesterday’s post I mentioned creating “registered servers” in groups in your “Registered Servers” Window.  Today, i present a short script, which, if applied to the SQL 2005 (and up) groups  will allow you to in real-time query all the SQL servers error logs…searching for suspicious things of your choice… just change the ‘where’ clause below… Continue reading “Multiple SQL Server Error log search”

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 22, 2011

Performance counter types

Learning about Performance Counters

How do you interpret the value you get back for any particular performance counter?

Continue reading “Performance counter types”

Posted on April 21, 2011

SQL PASS Rally

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

Posted on February 3, 2010

Get Alerted when your 2000 SQL cluster fails over

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.  Continue reading “Get Alerted when your 2000 SQL cluster fails over”

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):”

Posts navigation

Previous page Page 1 … Page 5 Page 6

Recent Posts

  • 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
  • PowerBI

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

  • 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
  • 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