Inspire with Data

using Microsoft Data Platform

Skip to content
Menu

Category: SQL Server 2005

Posted on Jul 7, 2011SQL Server 2005

Performance dashboard in SQL Server Management Studio

Amazingly enough I have just learned for a new very convenient way of investigating bad performance. Usually when someone says “My SQL is running very…

Continue Reading
Posted on Jun 20, 2011SQL Server 2005

SQL Server performance and troubleshooting tools, tips and tricks

I’ve planned to write a series of post regarding different tools which you can use for performance analysis and troubleshooting but tonight I found that…

Continue Reading
Posted on May 28, 2011Jan 6, 2013Database administration

How to check what SQL Server network protocol is used by connections

In this post I would like to share a simple query showing currently running statements (using sys.dm_exec_requsts DMV) along with the connection type, address and…

Continue Reading
Posted on Mar 26, 2011SQL Server 2005

How to check who performed a SQL Server database backup

In this post I would like to share a simple way of extracting latest database backup including the user that has initiated it. Generally SQL…

Continue Reading
Posted on Mar 14, 2011SQL Server 2005

How to extract SQL Server non-default configuration settings

Have you ever wondered how easily to extract non-default SQL Server instance settings? Well recently I had to perform such task so I can apply…

Continue Reading
Posted on Mar 6, 2011SQL Server 2005

How to create Custom Reports for SQL Server Management Studio

In this article I will describe in details (including some examples) how you can build your own SQL Server Management Studio reports that are loaded…

Continue Reading
Posted on Mar 3, 2011Jan 2, 2018SQL Server 2005

SQL Server AS failed to start with message “SQL Server Analysis Services () service on Local Computer started and then stopped. Some services stop automatically if they are not used by other services or programs”

  This is a very strange issue I came across last week. We have a consolidation server with several 2005 SP3 instances, including couple of…

Continue Reading
Posted on Feb 18, 2011SQL Server 2005

SQL Server CMS – where are locally registered servers stored

In one of my previous posts I showed you how to register multiple instances in SQL Server Management Studio Registered Servers explorer. However registering them…

Continue Reading
Posted on Jan 29, 2011Jun 18, 2012SQL Server 2005

List all full-text search catalogues on an instance

With the following script you can easily find all FTS catalogues and their state on the SQL Server instance. This could come handy when you…

Continue Reading
Posted on Jan 21, 2011SQL Server 2005

Error: 30064, Severity: 17, State: 1 in SQL Server Error log

Recently I came across a strange message in SQL Server Error Log: “SQL Server failed to set security information on the full-text FilterData directory in…

Continue Reading

Posts navigation

Page 1 Page 2 Next Page

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 139 other subscribers

Learning

  • Microsoft Virtual Academy
  • PowerBI.com
  • SQL Master Academy
  • SQL Server Builds
  • SQL Skills

Archives

  • April 2018 (1)
  • March 2018 (1)
  • December 2017 (1)
  • November 2014 (1)
  • June 2014 (1)
  • May 2014 (1)
  • September 2013 (3)
  • June 2013 (1)
  • March 2013 (2)
  • February 2013 (3)
  • January 2013 (2)
  • December 2012 (2)
  • November 2012 (3)
  • October 2012 (2)
  • August 2012 (1)
  • July 2012 (1)
  • June 2012 (2)
  • January 2012 (1)
  • November 2011 (2)
  • October 2011 (3)
  • September 2011 (1)
  • July 2011 (6)
  • June 2011 (2)
  • May 2011 (1)
  • April 2011 (1)
  • March 2011 (4)
  • February 2011 (3)
  • January 2011 (6)
  • December 2010 (6)
  • November 2010 (7)
  • October 2010 (3)
  • September 2010 (3)
  • August 2010 (3)
  • July 2010 (1)
  • June 2010 (1)
  • May 2010 (2)
  • April 2010 (6)
  • March 2010 (3)
  • February 2010 (6)

Pages

  • About
  • Privacy Policy
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
© Copyright 2019 – Inspire with Data
Alkane Theme by WPAlkane ⋅ Powered by WordPress