Sign In
MSDN Blogs
Microsoft Blog Images
More ...
Common Tasks
Blog Home
About
RSS for comments
RSS for posts
Atom
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Recent Posts
"System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool."
Posted
5 days ago
by
Michael Aspengren - MSFT
Windbg and managed code. What does, for example, a null value look like?
Posted
15 days ago
by
Michael Aspengren - MSFT
How to setup UrlScan with DenyUrlSequence
Posted
1 month ago
by
Michael Aspengren - MSFT
"SQL Server Configuration Manager" gives "Invalid class [0x80041010]” when starting.
Posted
2 months ago
by
Michael Aspengren - MSFT
How to create a dump on x number of threads in a process.
Posted
2 months ago
by
Michael Aspengren - MSFT
Blogs I read
Fabulous Adventures In Coding
If broken it is, fix it you should
SQL in Stockholm
SQL Protocols
Tags
Access
ADO
ADO.Net
BID
CLR
Data Provider
Data Reader
Exception
Linked Server
LINQ to SQL
Login
ODBC
OleDb
Oracle
OracleClient
Remote Debugging
sqlcmd
SqlException
sqlncli
TCP
Timeout
t-sql
WCF
Windbg
Xml
Archives
Archives
May 2012
(2)
March 2012
(2)
February 2012
(2)
January 2012
(2)
December 2011
(1)
November 2011
(1)
October 2011
(3)
June 2011
(2)
May 2011
(1)
March 2011
(2)
February 2011
(1)
January 2011
(1)
December 2010
(2)
November 2010
(2)
October 2010
(2)
June 2010
(1)
May 2010
(3)
April 2010
(2)
March 2010
(4)
February 2010
(3)
January 2010
(4)
December 2009
(6)
November 2009
(3)
October 2009
(4)
September 2009
(7)
August 2009
(4)
July 2009
(3)
June 2009
(2)
May 2009
(3)
April 2009
(3)
March 2009
(4)
February 2009
(4)
January 2009
(2)
December 2008
(6)
November 2008
(3)
October 2008
(3)
September 2008
(6)
August 2008
(3)
July 2008
(9)
Blog - Title
Common tips and tricks from a SQL Developer Support perspective
While some cases may start of as complex, they sometimes turn out to be caused by something not that complex. As the case always is once you have the solution. So I thought I would share some of the things that I've come across, and hopefully tha
RSS for posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Common tips and tricks from a SQL Developer Support perspective
"System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool."
Posted
5 days ago
by
Michael Aspengren - MSFT
0
Comments
Another post on the following exception: System.InvalidOperationException : Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool...
Common tips and tricks from a SQL Developer Support perspective
Windbg and managed code. What does, for example, a null value look like?
Posted
15 days ago
by
Michael Aspengren - MSFT
0
Comments
Sometimes when debugging I realize I forget what different values (NULL, TRUE, FALSE, empty strings etc.) looks like when debugging managed code. If this happens for you as well, here is a quick reference. The application (simple C# console application...
Common tips and tricks from a SQL Developer Support perspective
How to setup UrlScan with DenyUrlSequence
Posted
1 month ago
by
Michael Aspengren - MSFT
0
Comments
I had a case where UrlScan and in particular [ DenyUrlSequences ] was needed to be setup. Doing research on this didn’t give many examples on how to do this. So here is a quick guide on how to. First we need a scenario. So let’s...
Common tips and tricks from a SQL Developer Support perspective
"SQL Server Configuration Manager" gives "Invalid class [0x80041010]” when starting.
Posted
2 months ago
by
Michael Aspengren - MSFT
1
Comments
Ok, so it happened to me again today. I simply wanted to open the SQL Server Configuration Manager. Start -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager and was greeted with the following error...
Common tips and tricks from a SQL Developer Support perspective
How to create a dump on x number of threads in a process.
Posted
2 months ago
by
Michael Aspengren - MSFT
0
Comments
So, you have an application that uses a lot of threads and you would like to know how to trigger a dump when the number of threads exceeds a particular limit. Well, look no further, this is how you can do it. Let’s do it by example. Start...
Common tips and tricks from a SQL Developer Support perspective
How to create a dump on an OutOfMemoryException.
Posted
3 months ago
by
Michael Aspengren - MSFT
0
Comments
So, you are running your web application in IIS and intermittently you get an OutOfMemoryException . Basically you get something like this in the browser and\or you see this in the event viewer: Exception of type ' System.OutOfMemoryException...
Common tips and tricks from a SQL Developer Support perspective
Some gotchas when using ASP.NET MVC with Entity Framework Code First.
Posted
4 months ago
by
Michael Aspengren - MSFT
0
Comments
A fairly short one today. I was playing around with ASP.NET MVC and Entity Framework Code First and discovered a few gotchas. Which I intend to share here. So this post is not about how EF code first or MVC works. For a really good tutorial on this...
Common tips and tricks from a SQL Developer Support perspective
How to create a clock style line rotation in Silverlight.
Posted
4 months ago
by
Michael Aspengren - MSFT
1
Comments
The other day I wanted a simple example on how to rotate a line from a center of an ellipse in a Windows Phone 7 Silverlight application. Much like a hand in a clock. So I went about to do this and found that there are some good material out there. For...
Common tips and tricks from a SQL Developer Support perspective
.docx, .pptx, .xlsx open as compressed folder in IE8.
Posted
5 months ago
by
Michael Aspengren - MSFT
0
Comments
A quick one today. I had a case where the customer reported that IIS 6.0 returned Office 2007 / 2010 documents (.docx, .pptx, .xlsx, etc.) as compressed (.zip) files. Checking the IIS metabase (C:\WINDOWS\system32\inetsrv\metabase.xml ) showed that...
Common tips and tricks from a SQL Developer Support perspective
How to create a StackOverflowException. And how to figure out where it is happening.
Posted
6 months ago
by
Michael Aspengren - MSFT
0
Comments
StackOverflowException . This usually means that you have a recursive call in your code. A recursion is simply a method that calls itself, causing the stack to overflow and throw the StackoverFlow exception. A simple example: namespace...
Common tips and tricks from a SQL Developer Support perspective
How to exhaust the connectionpool from the Application_AuthenticateRequest method.
Posted
6 months ago
by
Michael Aspengren - MSFT
2
Comments
The other day I had a case where the customer reported that their web application intermittently got stuck. And as usual there was no clear cut pattern for when this happened. Luckily I have worked in the SQL Developer team even if I now work for...
Common tips and tricks from a SQL Developer Support perspective
How to publish a calendar from Outlook to IIS and WebDAV
Posted
7 months ago
by
Michael Aspengren - MSFT
0
Comments
How do I publish a shared calendar using WebDav ? If you have ever asked this question then hopefully the answer will be below. The first thing you need to do is to make sure that WebDAV is installed on the IIS machine. This is discussed here...
Common tips and tricks from a SQL Developer Support perspective
How to resolve "Cannot debug pid <pid>, NTSTATUS 0xC0000048" - "An attempt to set a process's DebugPort or ExceptionPort was made ..."
Posted
7 months ago
by
Michael Aspengren - MSFT
2
Comments
Once I found out what was causing this error message it was pretty obvious what was going on. But when investigating there was not much information to be found so I thought I’d share this with you. The ones who are more seasoned debuggers...
Common tips and tricks from a SQL Developer Support perspective
How to use LogParser, SQL Server and ETW to find reasons for exceptions.
Posted
11 months ago
by
Michael Aspengren - MSFT
1
Comments
Today I’ll show you how to make life easier using ETW (or BID) tracing, Log Parser and a SQL Server. This will be a simplified example, but it should be enough to get you going and further troubleshoot your issues. So, the first thing we need...
Common tips and tricks from a SQL Developer Support perspective
How to figure out what exception is causing a high number in “# of Exceps Thrown / Sec” using ProcDump and WinDbg.
Posted
11 months ago
by
Michael Aspengren - MSFT
0
Comments
Today I’ll show you how to track/figure out what exceptions could cause a high number of .Net “# of Exceps Thrown / Sec” We’ll do this with WinDbg and ProcDump . Let us start with reviewing the documentation for this performance...
Common tips and tricks from a SQL Developer Support perspective
How to create a connection leak. And how to avoid it.
Posted
over 1 year ago
by
Michael Aspengren - MSFT
0
Comments
Ever dreamt off a .Net connection leak? If you have, then possibly you’ve rather dreamt about how to avoid it rather than how to create it. Below I will show how to create it, avoid it and why it may happen. First of all, why is a connection...
Common tips and tricks from a SQL Developer Support perspective
No files in the “IIS Temporary Compressed Files” directory. Some possible reasons.
Posted
over 1 year ago
by
Michael Aspengren - MSFT
0
Comments
I had a case were no files were stored (or missing) in the “IIS Temporary Compressed Files” directory. During research, I noticed that there were a few things to look for/think about when you see no compressed files in the ”IIS Temporary...
Common tips and tricks from a SQL Developer Support perspective
WPF, DataBinding, DataGrid and simple conditional 'higher than' using IValueConverter
Posted
over 1 year ago
by
Michael Aspengren - MSFT
2
Comments
The other day I wanted to highlight some rows in a datagrid in a WPF project. This is not hard to accomplish in a “normal” Win Form situation, but in in WPF it needed a bit more work (not much to be honest). So, the scenario in this...
Common tips and tricks from a SQL Developer Support perspective
Inserting a file into a FILESTREAM table from C#. And how to get it back as well.
Posted
over 1 year ago
by
Michael Aspengren - MSFT
0
Comments
Here is my take on how to insert files into a SQL Server 2008 FILESTREAM (in short, storing files on disk rather than in the database). From "FILESTREAM Overview" http://msdn.microsoft.com/en-us/library/bb933993(SQL.100).aspx “Much of the data...
Common tips and tricks from a SQL Developer Support perspective
An unhandled exception of type 'System.StackOverflowException' occurred in System.Data.Entity.dll
Posted
over 1 year ago
by
Michael Aspengren - MSFT
1
Comments
I have now had two cases where customers report that they hit the following exception when using .Net 3.5 and Entity Framework. An unhandled exception of type 'System.StackOverflowException' occurred in System.Data.Entity.dll or in the eventviewer...
Common tips and tricks from a SQL Developer Support perspective
Running a database mirror setup with the SQLBrowser service off may produce unexpected results.
Posted
over 2 years ago
by
Michael Aspengren - MSFT
0
Comments
I had an interesting case the other day which I thought I'd share some information on here. Basically the setup was a SQL Server 2008 Database Mirror setup and the connectionstring looked something like this: @"Data Source=SERVER_A\INSTANCE_A,12345;Failover...
Common tips and tricks from a SQL Developer Support perspective
Clarification on the Failover Partner in the connectionstring in Database Mirror setup.
Posted
over 2 years ago
by
Michael Aspengren - MSFT
3
Comments
There is a common misunderstanding on how the Failover Partner keyword in the connectionstring works in a database mirror setup. This is my attempt to clarify a bit on this. From the documentation we can see the following: “Failover Partner ...
Common tips and tricks from a SQL Developer Support perspective
How to consume a web service from within SQL Server using SQL CLR
Posted
over 2 years ago
by
Michael Aspengren - MSFT
2
Comments
Today I’ll show how you can consume a Web Service from within SQL Server using the SQL Server CLR. DISCLAIMER: This is just intended as proof of concept. I do feel that if you wish to consume web services from SQL Server, then you should...
Common tips and tricks from a SQL Developer Support perspective
Error : The OutputPath property is not set for project 'xxxxx.dbproj'.
Posted
over 2 years ago
by
Michael Aspengren - MSFT
0
Comments
I had an interesting case the other day and I thought I’d share how we managed to get around the problem. This post will not discuss why this happens or if this is the correct behavior. It will just show a way to build your project. So...
Common tips and tricks from a SQL Developer Support perspective
Simplified steps for creating BID / ETW traces for ADO.Net and SQLNCLI
Posted
over 2 years ago
by
Michael Aspengren - MSFT
0
Comments
In order to create BID traces for ADO.Net and/or SQLNCLI/10 follow these simplified steps: #1 On the machine where client code runs, create a new directory called C:\BID #2 Locate the appropriate diagnostic dll. ADO.Net: For .Net 2.0...
Page 1 of 5 (118 items)
1
2
3
4
5
MSDN Blogs
>
Common tips and tricks from a SQL Developer Support perspective