(Scott Mitchell) One of the many factors that contributed to the phenomenal success of ASP was the ease with which developers could create data-driven Web pages. A very common data-driven Web page, especially in an intranet setting, is one that generates reports. Such a page often pulls figures from
Author: SSWUG Research
Google Maps and ASP.NET
(Jeevan Murkoth) I am sure that most of you have heard about or have had a chance to use Google Maps. It’s a great service and I was really impressed by the responsiveness of the application and the ease with which users could drag and zoom maps from a Web browser. It has in many ways heralded the a
Understanding the pros and cons of the Waterfall Model of software development
(Melonfire) Waterfall development is a software development model involving a phased progression of activities, marked by feedback loops, leading to the release of a software product. This article provides a quick and dirty introduction to the model, explaining what it is, how it’s supposed to work,
Special: MySpace – Lessons learned about SQL Server growth, capacity management and much more.
Pro-Center Video Programming for IT Professionals
Debugging sleeping connections with MySQL
(Peter Zaitsev) Have you ever seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why this would happen?
Multiple-Valued Parameters
(Peter DeBetta) So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited list of values and I knew I cou
The .Net Developer And SQL Server: Working On Locks
(George P. Alexander Jr.) We’ve been looking at what we needed to know about the finer details of SQL Server Locks so far. After getting our basics right over here, we continued later by taking a look at the different types of Locks that SQL Server uses to manage data consistency. Assuming your pret
XForms tip: Reacting to the refreshing of the form
(Tyler Anderson) As data changes in your XForms form it can be essential to know right away and do something with the new data, especially when your XForms get more advanced. This tip shows you how to hook such events right into JavaScript methods, thus allowing you to then use the data in many diff
Getting a Handle on Indexes
(Steve Callan) So much has been written about indexes that you practically need an index to keep track of things. Performance is the number one reason why indexes are needed. However, there are situations where indexes are not needed, so how do you know when and where to index? To index or not to in
T-SQL identifiers
All databases, servers, and database objects in SQL Server (such as tables, constraints, stored procedures, views, columns, and data types) must have unique names, or identifiers. They are assigned when an object is created, and used thereafter to identify the object. The identifier for the object m