(Sanjit Sil) We can add any number of files and folders within the application without recompiling each and every time a new file is added to the overall solution. ASP.NET2.0 has the capability to automatically precompile ASP.NET application dynamically. In case of ASP.NET 1.0 or ASP.NET 1.1 everyth
Other News
Restricting Data Access Using the Virtual Private Database
The goal of this tutorial is to show the power of using the Virtual Private Database capability to restrict access to certain data to certain users.
Reevaluating XSLT 2.0
(Kurt Cagle) I recently wrote a blog about the directions that I saw with XML, and while it has proved to be fairly popular, it has also generated a fair number of comments that really need their own more detailed examination. One of these, and one that I’ve been planning to write for a while anyway
Record Locking in SQL Server
(Kalpesh Bakotiya) In a multi-user environment, there are two models for updating data in a database: optimistic concurrency and pessimistic concurrency.
An algorithm to find and resolve data differences between MySQL tables
(Xaprb) I’ve been designing an algorithm to resolve data differences between MySQL tables, specifically so I can ‘patch’ a replication slave that has gotten slightly out of sync without completely re-initializing it. I intend to create a tool that can identify which rows are different and bring them
Designing Forms for Microsoft Office InfoPath and Forms Services 2007 (Part 1)
(Scott Roberts and Hagen Green) At this point in the book, you not only know how to design form templates that look nice but you can also take advantage of most of the basic (and some not so basic) features available when using InfoPath in design mode. Now you can create professional-looking forms i
Create Excel-files with a simple class
(e-DJ) When I wrote my latest application, I had to find a way to print data from a CListCtrl. Since I am not very familiar with printing in MFC, I thought about exporting the data to Excel and leaving all the formating and printing to Excel.
SQL Server Security – Encrypting Connections
(Buck Woody) The best security method for a database system is to limit its exposure, removing it completely from the network. Of course, for most of the applications you need to run this isn’t an option. Most database server systems are connected directly to the corporate network, if not the networ
DB2 Error, UTIL_HEAP_SZ value is too small
This is a DB2 configuration problem where there is not enough storage available in the heap UTIL_HEAP_SZ to process the statement.
Advanced Queuing Working Example – (PL/SQL)
(Jeff Hunter) This article provides a brief overview on configuring and using Oracle’s Advanced Queuing features using PL/SQL. This will demonstrate the basic functionality of Oracle Advanced Queuing (AQ). AQ was first introduced in Oracle8 and has been extended and improved on into future versions.