Inspire with Data

using Microsoft Data Platform

Skip to content
Menu

Month: January 2011

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

Step-by-step setup of Always ON (HADR ON) feature in SQL 11 (video)

Following is a video of a step-by-step setup of SQL Server 11 AlwaysOn availability group feature from Gopal Ashoc (Product manager for SQL Server High…

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
Posted on Jan 12, 2011Feb 6, 2012Database administration

How check for active trace flags in SQL Server

Have you ever tried to figure out what traces are currently active on your SQL Server? Well recently I had to do it and it…

Continue Reading
Posted on Jan 9, 2011SQL Server 2005

Extracting query plans and statements with execution details

In this article I will share with you a script extracting longest running and most CPU using query statements and their plans. As a starting…

Continue Reading
Posted on Jan 5, 2011Uncategorized

Automating Administration Across an Enterprise

The goal of automating administration across a large organization is aiming at simplifying the day-to-day job  of the DBA and also ease some dataflow tasks…

Continue Reading

Subscribe to Blog via Email

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

Join 189 other subscribers

Learning

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

Archives

  • January 2020 (1)
  • December 2019 (3)
  • 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 2021 – Inspire with Data
Alkane Theme by WPAlkane ⋅ Powered by WordPress