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: MS11-028 may cause issues with SQL, Exchange and PowerShell

    A .NET Security Update (MS11-028) may end up causing issues with applications that make use of the .NET Framework, mostly resulting in applications being unable to launch, or loss of functionality within Native Applications that make use of .NET. In some cases, it could lead to an application crash....
  • Blog Post: Conversion issues moving from VS 2005 to VS 2008

    I was asked to look at a case yesterday where the customer was hitting the following error after converting a VS 2005 Project to VS 2008. Error 3 Custom tool error: Failed to generate code. Failed to generate code. Exception of type 'System.Data.Design.InternalException' was thrown. Exception of type...
  • Blog Post: How It Works: SqlDataReader::RecordsAffected and Why it Returns -1

    I encountered another interesting research issue to share with you. The documentation states RecordsAffected are for INSERT, UPDATE and DELETE but it might fool you. ------------------------------------------------------------------------------------ Sent: Monday, June 07, 2010 9:06 PM Subject: "set...
  • Blog Post: SSIS 2005 and the .NET Garbage Collector

    I was troubleshooting an SSIS Out of Memory issue the other day which led us into how the .NET Garbage Collector (GC) works.  When debugging it, I found that we were using the Workstation GC with Concurrent GC On (this is the default for .NET applications).  The following blog discusses the...
  • Blog Post: How to troubleshoot leaked SqlConnection Objects (.NET 2.0) - Part 2

    In the last post in this series, we looked at how we can determine that our Connection pool was exhausted. In this post I'm going to go a little deeper into the Internal connection itself and how we can verify if this is a closed or active connection. Dumping out the internal connection objects ...
  • Blog Post: How to troubleshoot leaked SqlConnection objects (.NET 2.0) - Part 1

    One of my colleagues, Kamil Sykora, compiled a document that goes through how to troubleshoot leaked SqlConnection objects (from a .NET 2.0 perspective).  It was a fairly large document, so I’m not going to post the whole thing.  I’m going to split it out over several posts and...
Page 1 of 1 (6 items)