(Scott Mitchell) When storing user-supplied text data into a database, it is essential that the length of the user’s input does not exceed the size of the corresponding database table field. For example, imagine that you have defined a table with a field named Comments of type varchar(50). In a web
Other News
ASP.NET Crash: System.Security.Cryptography.CryptographicException
(Tess Fernandez) We have seen a few cases lately where ASP.NET apps die due to an unhandled CryptographicException when finalizing a SafeHandle. Here is the explanation of why this happens and what you can do to avoid it.
How to Publish Content from Another URL in a ContentPlaceHolder Control
(Chris Love) It seems like every week I see a person asking a question about either placing content in the ContentPlaceHolder control dynamically or from another URL in the www.asp.net forums. By URL they typically mean another page from another site. I think many of these folks are somewhat misguid
SSAS small/big query interaction
(Eric Jacobsen) Default SSAS behavior can sometimes result in small queries being slowed down by concurrently running big queries.
Read-Only Data
(Buck Woody) All databases store and retrieve data. But some applications only require that the storage work one time — that data is entered once, but read multiple times. In fact, for some tracking applications, it’s a requirement that data is only written one time, but can be read multiple times a
Scripting Tables, Views and Data using SMO (part 3)
(Ben Miller) Below is the final code that I used to script off my Tables, Views and the data using sp_generate_inserts from Vyas. This is something that I have needed to do, and I found that using SMO for this is a great tool. Mind you, that the data file that gets output to me is 22 MB from this
DevConnections (and SQLConnections)… Day 2
Featured Article(s) Troubleshooting SQL Server 2005 Merge Replication (Part 1) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 merge replication. He also tells how you can resolve these problems. Don’t Throw Away Your Reporting Services Masterpieces… Once you’re done creating the reports your users need, you know you’re almost […]
From DevConnections… Day 1
Featured Article(s) Understanding Software Testing (Part II) This is the second part in the series of three part articles on Software Testing. In this part we will explore the common types of software testing. Software Testing can be classified into several types based on treating the subject from various angles. Let us look into some common classifications for Software Testing. […]
Index XML Documents with VTD-XML
(Jimmy Zhang) This article combines various examples and the latest benchmark reports to show you how to get started with this indexing. This article also discusses various scenarios and use cases where you may find VTD+XML useful.
Querying RSS feeds in SQL – contortionism with Oracle XML DB in 10 lines of SQL
(Lucas Jellema) There are times when a challenge presents itself. Often for no logical reason and without any direct benefit. Like doing a crosswords. I have this unconscious part of me that keeps sending me inane challenges, that I cannot seem to shake myself free of. Yesterday morning – very early