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
Some gotchas when using ASP.NET MVC with Entity Framework Code First.
Posted
18 days ago
by
Michael Aspengren - MSFT
How to create a clock style line rotation in Silverlight.
Posted
1 month ago
by
Michael Aspengren - MSFT
.docx, .pptx, .xlsx open as compressed folder in IE8.
Posted
2 months ago
by
Michael Aspengren - MSFT
How to create a StackOverflowException. And how to figure out where it is happening.
Posted
3 months ago
by
Michael Aspengren - MSFT
How to exhaust the connectionpool from the Application_AuthenticateRequest method.
Posted
3 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
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)
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
Some gotchas when using ASP.NET MVC with Entity Framework Code First.
Posted
18 days 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
1 month 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
2 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
3 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
3 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
3 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
3 months ago
by
Michael Aspengren - MSFT
0
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
7 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
7 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
9 months 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
11 months 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
11 months ago
by
Michael Aspengren - MSFT
1
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
11 months 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
0
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...
Common tips and tricks from a SQL Developer Support perspective
Invalid object name 'MSysConf'. (State 42S02) (Code 208)
Posted
over 2 years ago
by
Michael Aspengren - MSFT
0
Comments
Sometimes customers call in wondering why they have the following Exception and User Error Message in their SQL Profiler log: Exception: Error: 208, Severity: 16, State: 1 User Error Message: Invalid object name 'MSysConf'. or, if they...
Common tips and tricks from a SQL Developer Support perspective
"Error Locating Server/Instance Specified [xFFFFFFFF]". SQLSRV32 to the rescue.
Posted
over 2 years ago
by
Michael Aspengren - MSFT
1
Comments
When connecting to SQL Server and when the connection fails the reason for the error may sometimes be a bit unclear. For this example I have a SQL Server 2008 instance called Spike2008 running on a machine called SpikeSrv2008 (running on Windows...
Common tips and tricks from a SQL Developer Support perspective
Registry keys for ODBC connections using sqlsrv32, sqlncli and sqlncli10
Posted
over 2 years ago
by
Michael Aspengren - MSFT
0
Comments
Here is the list of the registry keys used for ODBC connections when using SQLSRV32.dll / SQLNCLI.dll / SQLNCLI10.dll respectively. Obviously keys for sqlsrv32 exist for SQLNCLI.dll and SQLNCLI10.dll for backwards compatibility. And subsequently...
Common tips and tricks from a SQL Developer Support perspective
Simplified steps to create BID / ETW tracefiles.
Posted
over 2 years ago
by
Michael Aspengren - MSFT
0
Comments
Sometimes we in support need you to take a BID (Built In Diagnostics) or ETW (Event Tracing for Windows) trace in order to troubleshoot a problem. There are a few documents out there on how to create these, but they are somewhat verbose for the...
Common tips and tricks from a SQL Developer Support perspective
How to find the culprit and a blocking scenario.
Posted
over 2 years ago
by
Michael Aspengren - MSFT
0
Comments
A post on how to troubleshoot blocking clients. The scenario is that you have many users that complain that all of a sudden the applications hang and no data is returned. The setup for demoing this scenario: Machine 1: This is the SQL Server...
Common tips and tricks from a SQL Developer Support perspective
A simple Master Detail databinding example in WPF using the XmlDataProvider.
Posted
over 2 years ago
by
Michael Aspengren - MSFT
1
Comments
A post on Master Detail data binding with WPF and (in this case) the XmlDataProvider. In this example we will use a scenario that many are familiar with, namely football. We usually have countries, these have leagues and the leagues have teams...
Page 1 of 5 (112 items)
1
2
3
4
5
MSDN Blogs
>
Common tips and tricks from a SQL Developer Support perspective