Sign In
MSDN Blogs
Microsoft Blog Images
More ...
September, 2008
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 of the new stuff in .Net 3.x simply/examplyfied.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
“Deferred vs. Immediate Loading” or “Lazy vs. Eager Loading”, simplyfied, I hope....
Posted
over 4 years ago
by
Michael Aspengren - MSFT
Dude, where did my ODBC System DSN go?!
Posted
over 4 years ago
by
Michael Aspengren - MSFT
Nested RecordSet and the port/socket in TIME_WAIT problem by example.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
XmlDocument and the removal of the indentations. It is good.
Posted
over 4 years 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
February 2012
(1)
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)
September, 2008
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 of the new stuff in .Net 3.x simply/examplyfied.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
1
Comments
Just thought I put together a small class that shows some of the new features in .Net 3.x I have no intention of trying to explain how it works in detail (there is good documentation out there), you should see this more as a reference. Also,...
Common tips and tricks from a SQL Developer Support perspective
“Deferred vs. Immediate Loading” or “Lazy vs. Eager Loading”, simplyfied, I hope....
Posted
over 4 years ago
by
Michael Aspengren - MSFT
0
Comments
Have you ever been thinking “When using LINQ to SQL, when does the data get loaded? Is it one huge query, or do I get a lot of database round tripping?”. If you have thought about it once or twice, fine. If you think about it all the time, you may...
Common tips and tricks from a SQL Developer Support perspective
Dude, where did my ODBC System DSN go?!
Posted
over 4 years ago
by
Michael Aspengren - MSFT
1
Comments
When creating ODBC DSN’s, sometimes it all seems to go well. You open the ODBC Data Source Administrator. You enter the connection details for a new User DSN, test the connection and all is well. BTW: instead of going: Control Panel ->...
Common tips and tricks from a SQL Developer Support perspective
Nested RecordSet and the port/socket in TIME_WAIT problem by example.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
0
Comments
This is basically a continuation of the post on ports ending up in TIME_WAIT, here In short, what happens is that when you are not using connection pooling, a connection that is closed indeed closed. However, the port that the connection used...
Common tips and tricks from a SQL Developer Support perspective
XmlDocument and the removal of the indentations. It is good.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
0
Comments
Imagine that you have a program that creates XML documents using the XmlDocument class. See: ".NET Framework Class Library - XmlDocument Class" http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.aspx You do this by creating and...
Common tips and tricks from a SQL Developer Support perspective
System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
0
Comments
The problem: You getting are getting the following error (depending on what SQL Server Version you are running). If you are running against Sql Server 2000: System.Data.SqlClient.SqlException: A severe error occurred on the current command...
Page 1 of 1 (6 items)
MSDN Blogs
>
Common tips and tricks from a SQL Developer Support perspective
>
September, 2008