The Curious Engineer

All blogs / Web development

Tips and tricks from a Developer Support perspective.

learn.microsoft.com/en-us/archive/blogs/spike

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

Web developmentC# / .NETWindows internalsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
124 from 14 Jul 2008 to 3 Mar 2015
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/spike/feed.xml

2015 2

  1. Microsoft SQL Server 2012 RS Add-In for SharePoint fails to install.
  2. SharePoint 2013. Excel Services. w3wp.exe fails with "Exception code: 0x80131623"

2013 7

  1. "Installation of one or more roles, role services, or features failed. Error: 0x800f0922" when installing IIS 8.0 Application Initialization.
  2. Repeated login dialogs ending with a 401 when using Basic Authentication in IIS.
  3. A network analysis of passive (EPSV or PASV) FTP connection.
  4. How to download multiple files concurrently using WebClient and the DownloadFileAsync method.
  5. How to deploy your Windows Store app to Surface RT for testing.
  6. IIS 7.5 - Unable to deploy second server to WFF farm, "Failed to upload assembly 'Microsoft.Web.PlatformInstaller, Version=3.0.3.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' on remote agent"
  7. Adding printer with "Internet Printing" gives "Windows couldn’t connect to the printer. Check the printer name and try again."

2012 12

  1. How to edit server information in response sent to client.
  2. Using MSDeploy to update and remove sections in web.config. A simple example
  3. One-to-one client certificate mapping. 401.1 with a sc-win32-status of 2148086018
  4. HTTP Error 500.19 0x8007000d Failed to decrypt attribute 'password' because the keyset does not exist
  5. "System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool."
  6. Windbg and managed code. What does, for example, a null value look like?
  7. How to setup UrlScan with DenyUrlSequence
  8. "SQL Server Configuration Manager" gives "Invalid class [0x80041010]” when starting.
  9. How to create a dump on x number of threads in a process.
  10. How to create a dump on an OutOfMemoryException.
  11. Some gotchas when using ASP.NET MVC with Entity Framework Code First.
  12. How to create a clock style line rotation in Silverlight.

2011 9

  1. .docx, .pptx, .xlsx open as compressed folder in IE8.
  2. How to create a StackOverflowException. And how to figure out where it is happening.
  3. How to publish a calendar from Outlook to IIS and WebDAV
  4. How to resolve "Cannot debug pid <pid>, NTSTATUS 0xC0000048" - "An attempt to set a process's DebugPort or ExceptionPort was made ..."
  5. How to use LogParser, SQL Server and ETW to find reasons for exceptions.
  6. No files in the “IIS Temporary Compressed Files” directory. Some possible reasons.
  7. WPF, DataBinding, DataGrid and simple conditional 'higher than' using IValueConverter
  8. Inserting a file into a FILESTREAM table from C#. And how to get it back as well.
  9. An unhandled exception of type 'System.StackOverflowException' occurred in System.Data.Entity.dll

2010 21

  1. Running a database mirror setup with the SQLBrowser service off may produce unexpected results.
  2. Clarification on the Failover Partner in the connectionstring in Database Mirror setup.
  3. How to consume a web service from within SQL Server using SQL CLR
  4. Error : The OutputPath property is not set for project 'xxxxx.dbproj'.
  5. Simplified steps for creating BID / ETW traces for ADO.Net and SQLNCLI
  6. Invalid object name 'MSysConf'. (State 42S02) (Code 208)
  7. "Error Locating Server/Instance Specified [xFFFFFFFF]". SQLSRV32 to the rescue.
  8. Registry keys for ODBC connections using sqlsrv32, sqlncli and sqlncli10
  9. Simplified steps to create BID / ETW tracefiles.
  10. Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
  11. Using User Instance with a .Net application
  12. Simple Databinding example with Entity Framework and Windows Presentation Foundation
  13. "No value given for one or more required parameters." / "Incorrect syntax near the keyword 'DEFAULT'."
  14. Must declare the scalar variable …
  15. Parent/Child DataRelation. The Basics.
  16. Compiling application gives : “Embedded statement cannot be a declaration or labeled statement”
  17. How to query for netstat info using PowerShell
  18. How to create a simple Extension method. A simple example.
  19. How to use the ObjectDataSource as a DataSource, simple example
  20. How to use LINQ to XML together with LINQ to SQL.
  21. How to use LINQ to SQL without using the designer generated classes

2009 45

  1. DataSet, DataTable, DataRelation, PrimaryKey template.
  2. How to examine memory dump for SqlCommand.CommandText using WinDbg and SOS
  3. How to create memory dump for SqlException using DebugDiag
  4. Very short and simple example of using SqlMetal
  5. How to see the SQL executing when updating a DataSet via DataAdapter.Update()
  6. Getting AutoNumber from Access via "SELECT @@IDENTITY" needs to be done in same connection as the INSERT.
  7. How to create a DNS less linked server in Access to SQL Server.
  8. Getting metadata about dataset using lambda. Some examples.
  9. How a proper physical TCP/IP connection to SQL Server works. Network Monitor
  10. Format of the initialization string does not conform to specification starting at index
  11. Why is autogenerated UPDATE and DELETE statements complex?
  12. My take on @@IDENTITY vs SCOPE_IDENTITY()
  13. DataTable.GetChanges(DataRowState.Modified) returns NULL
  14. XQuery in SQL Server, some examples
  15. MemberwiseClone by example
  16. SGEN gives "Error: The top XML element 'class' from namespace '' references distinct types UserDefinedFunctions.Class and UserDefinedFunctions.Class1."
  17. SGEN gives "Assembly ... does not contain any types that can be serialized using XmlSerializer.
  18. How to save information about DataSet into the XML when serializing it with WriteXML()
  19. "System.Data.Linq.ChangeConflictException: Row not found or changed" Finding the culprit
  20. Why massive inserts using SubmitChanges lack in performance.
  21. How to store performance monitor data into SQL Server using Reliability and Performance Monitor
  22. How to read a SQL Server trace file using .Net code, TraceFile and TraceServer.
  23. "There is already an open DataReader associated with this Command which must be closed first" explained
  24. IsolationLevel is carried over to connections in connectionpool
  25. SQL CLR stored procedure called via JDBC using setAutoCommit(false) does not update database.
  26. System.Data.SqlClient.SqlException: Cannot open database "database name" requested by the login. The login failed.
  27. Improving XslCompiledTransform performance.
  28. Oracle, Stored Procedures with ref cursor from .Net code and BID tracing.
  29. How to create a .Net SqlTransaction deadlock with SQL Server
  30. How use Convert in a DataTable select?
  31. Msg 7399 - The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "<linked server>" reported an error. Authentication failed.
  32. A simple example on how to get Return and Out parameter values using Ado.Net
  33. Using a subset of columns in a datatable as a DataSource for Windows controls.
  34. A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
  35. Catch a Sql Server RAISERROR at client side using SqlDataReader.
  36. Table-Value parameter used in .Net. Simple sample
  37. TechDays - Link to downloadable tools
  38. Pivot tables in SQL Server. A simple sample.
  39. DataAdapter.Update returns 0 and doesn't update the table in SQL Server.
  40. (working) TCP network monitor trace explained.
  41. System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
  42. Getting "Query is too complex" or "Expression is too complex” when using Access
  43. Typed DataSet from xsd using LINQ. Trial by fire
  44. SqlCommand.ExecuteNonQuery() returns -1 when doing Insert / Update / Delete
  45. How to prepare for a SQL Developer / Connectivity case

2008 28

  1. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
  2. Unable to find the requested .Net Framework Data Provider. It may not be installed.
  3. Create a LINQ/WCF/Silverlight application in 10 simple steps.
  4. What version of a particular dll is my application running? Find out using code.
  5. The importance of selecting the correct Sql provider for the job. Sqlncli vs. Sqlncli10
  6. SMO Transfer.TransferData() gives: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
  7. Connectionstrings, mixing usernames and windows authentication. Who goes first?
  8. SQL Server Error: 10060 SQL Server Error: 10061
  9. Connecting to an Oracle server you know is there. But connection still fails. What gives.
  10. How to update an Excel worksheet using DataSet and the OleDbDataAdapter
  11. Command prompt utilities, some resources in one place.
  12. Some of the new stuff in .Net 3.x simply/examplyfied.
  13. “Deferred vs. Immediate Loading” or “Lazy vs. Eager Loading”, simplyfied, I hope....
  14. Dude, where did my ODBC System DSN go?!
  15. Nested RecordSet and the port/socket in TIME_WAIT problem by example.
  16. XmlDocument and the removal of the indentations. It is good.
  17. System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect.
  18. (provider: TCP Provider, error: 0 - Only one usage of each socket address (protocol/network address/port) is normally permitted.)
  19. Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.
  20. How to use a FileDsn in .Net
  21. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  22. Invalid attempt to read when no data is present.
  23. OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
  24. The simplification of JOIN. Simple example of how T-SQL JOIN work
  25. Failed to find or load the registered .Net Framework Data Provider
  26. {"Syntax error in FROM clause."} when using text based datasources
  27. Creating a new system DSN: "Faulting application odbcad32.exe, version 3.526.3959.0, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de"
  28. Error/Event 18456 explained