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: NOT (LinkedServertoSQLAzure) where Provider=’MSDASQL’ and DSN=’SQL Server Native Client’

    I recently had two different people suggest the same (unfortunately unsupported) solution to the fact that there is no supported way of doing a linked server to SQL Azure directly from inside of SQL Server.  Since the reason the proposed solution is unsupported are subtle in the sense that it is...
  • 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: Distributed Queries – Remote Login Permissions and Execution Plans

    Recently I troubleshooted an issue where a distributed query was randomly getting a poor plan and slow performance where the join would not be remoted.  However, based on the actual data distribution and the join condition, you would expect the join to be remoted.  All of the remote servers...
  • Blog Post: When in doubt, Reboot!

    I tend to get quite a bit of Kerberos related cases.  These are related across the box, from the Engine, to Reporting Services to just straight connectivity with custom applications.  I had one given to me yesterday because the engineer had gone through everything we normally go through and...
  • Blog Post: How It Works: Linked Servers and Collation Compatibility

    Customer Question:   "Why I am getting different results when is change collation compatibility from true to false?" This actually turned out to be an interesting issue because no error was raised but the results are different. The query looked like the following: select * from   ...
  • Blog Post: SQL Server 2005 Service Pack 2 has released! Linked Server GUI is back!

    SQL Server 2005 Service Pack 2 (SP2) released on Monday to the web. If you want to start downloading it while reading the rest of the post, go right to http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx . Over the next several weeks, several of us in PSS will be...
Page 1 of 1 (6 items)