Browse by Tags

CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • Blog Post: How It Works: Failover Cluster/Availability Group XEL Logging Frequency

    I had a great question from my post on sp_server_diagnostics ( http://blogs.msdn.com/b/psssql/archive/2012/03/08/sql-server-2012-true-black-box-recorder.aspx ).  As ' luck ' would have it, Bob Ward, was working on some training and had a similar question.  As I investigated I uncovered a few...
  • Blog Post: AlwaysON - HADRON Learning Series: Maximum Failovers Within Specified Period

    I can't take the credit for all this content as much of the investigation was done by Curt Mathews (SQL Server Escalation Engineer). We are finding that folks want to test the failover abilities of AlwaysON but after a single failover it no longer seems to work.   This is because of the default...
  • Blog Post: Why is my SQL Clustered Instance changing authentication modes?

    We get our fair share of cases related to SQL Server running ( or not running) on a Windows Cluster.  I had one of them recently where the customer was seeing different authentication modes for SQL Server depending on which node of the 2-node cluster that it was online on. The Errorlogs document...
  • Blog Post: Reporting Services, Scale Out and Clusters…

    Every once in a while, I get asked the question about deploying Reporting Services on a Cluster. Usually it is tied to a scale out deployment, sometimes it is not. I just was asked the question again by an engineer in our group. So, I figured I should put this out there to have some reference. For starters...
  • Blog Post: What SPN do I use and how does it get there?

    This month has turned into another Kerberos Month for me.  I had an email discussion regarding SPN’s for SQL Server and what we can do to get them created and in a usable state.  I thought I would share my response to the questions as it will probably be helpful for someone.  Here was...
  • Blog Post: How To Test Drive SQL Server Clustering For Free

    I imagine that many of you are like me when it comes to purchasing software.   I want to take a test drive (evaluate) it before I buy it to make sure it really meets my needs.   You don't make a automobile purchase by just reading reviews you take it for a test drive.  Last week...
  • Blog Post: The 3 Things you Need to Know to Install SQL 2005 on Windows 2008 Cluster

    Today I was walking a counterpart through installing SQL Server 2005 cluster on a Windows Server 2008 cluster and realized there are three specific key things you need to know when installing SQL 2005 on Windows 2008 cluster.  I also saw that it was very helpful to have a few screen shots to quickly...
Page 1 of 1 (7 items)