(Brad M. McGehee) One of the main benefits of using a stored procedure to execute Transact-SQL code is that once a stored procedure is compiled and executed the first time, the query plan is cached by SQL Server. So the next time the same stored procedure is run (assuming the same connection paramet
Other News
DLL Hell and Version Policy
(Anuj Sahu) The heading of this article reflects that there are two topics and DLL hell is the problem and Version Policy is the solution to problem. Below is stated the problem with DLL hell is and how a developer can overcome this problem by defining his or her own Version policy.
Server Side Paging using SQL Server 2005
(graz) A common activity in applications is to page results or record sets from a database. This is usually done on the client using the client’s paging functionality or on the server through a variety of methods. In SQL Server 2000 those server side methods typically used dynamic SQL or nested TOP
ASP.NET: Is it really this easy? Yes!
(Alex Homer and Dave Sussman) In the previous chapter, you saw how ASP.NET 2.0 contains a raft of new features that reduce the code you need to write and save you time and effort when building dynamic and interactive Web pages and applications. To further illustrate this, and so that you get a bette
XForms tip: Use XForms to upload a file to PHP
(Tyler Anderson) Uploading files is a fairly common task using HTML forms, but how do you do it in XForms, where the data gets stored as part of an XML document? This tip explains how to create an XForms form that enables the user to upload a file, and it explains how to create a PHP script that sav
D.I.Y. MySQL 5.1 monitoring
(Guy Harrison) I wrote recently about using events and the new processlist table in MySQL 5.1 to keep track of the number of connected processes. Although having the PROCESSLIST available as an INFORMATION SCHEMA table is usefull, it seemed to me that having SHOW GLOBAL STATUS exposed in a similar
Nornalization with Entity Relationship Diagramming
(Rajeev Kuala) Entity relationship diagram (ERD) is one of the most widely used technique for data modeling. An ERD developed during the conceptual data modeling phase of the database development process is generally transformed and enhanced through normalization principles during the logical databa
SelectViews: What does collaboration mean for your databases? BI everywhere, being a tool…and more.
Video Programming for IT Professionals
The Database Shuffle
(Jim Utsler) Emulation-screen apps are “so yesterday,” to use the parlance of my youngest son. Sure, they still have their place – especially for internal company use. They’re sometimes faster to navigate, with long-time users, guided by years of habit, simply tabbing and entering information. No mu
ColdFusion / XML Query Style
(Ben Cortese) At one point or another, whether it’s an enterprise level website, or one of your own, you’re going to have the burning desire to see how you can take advantage of what XML can do for your applications.