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: Always On–When Is My Secondary Failover Ready?

    I keep running into the question: “When will my secondary allow automatic failover?”   Based on the question I did some extended research and I will try to summarize in is blog post.  I don’t want to turn this post into a novel so I am going to take some liberties and assume you have read...
  • Blog Post: The week that was PASS…

    I’m sitting in SEATAC Airport waiting for my flight, so I thought now would be a great time to write up some thoughts and share some experiences of my week at PASS.  There was a ton of great information this year and we also announced Denali – the next version of SQL Server!  From what I could...
  • Blog Post: SQL 2005 JDBC Driver and Database Mirroring

    We ran into some interesting situations with the SQL 2005 JDBC Driver (v1.2) and it's use with failover partners. Take the following connection string: jdbc:sqlserver://myserver1;databaseName=AdventureWorks;failoverPartner=myserver2; In this connection string, our Primary server will be myserver1 with...
  • Blog Post: How to configure Database mirroring for use with ODBC applications?

    If you have an ODBC application that is connecting to a mirrored database and if The application uses a connection string without a database name ( for e.g: dsn=ssistest;uid=ssistest;pwd=*********) The DSN is configured to use SQL authentication with a non-blank password. The default...
Page 1 of 1 (4 items)