(Guy Harrison and Steven Feuerstein) Over the past decade, MySQL has become the dominant open source database, and along with Linux and PHP, is at the heart of millions of applications. Now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power
Author: SSWUG Research
Navigating Oracle’s public online documentation
(Bob Watkins) In June 2006, Oracle took the unprecedented step of opening all its online documentation to public viewing without requiring an Oracle Technology Network (OTN) login. Although the documentation is still not searchable by Google’s “googlebots,” entries on the OTN blog promise that this
DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 data
(Roman Melnyk) This tutorial introduces you to Structured Query Language (SQL) and helps to give you a good understanding of how DB2 9 uses SQL to manipulate data in a relational database. This tutorial is the fourth series of seven tutorials that you can use to help prepare for DB2 9 Fundamentals C
Tuning .NET, part one: Performance monitors appear
(Colleen Frye) As server-side .NET development becomes more prevalent, Application Performance Management tools are becoming available to fine-tune .NET applications. And, as in the past, it seems that the ability to build new and more sophisticated applications always stays ahead of the ability to
How do I… Install SQL Server 2005 Express Edition and SQL Server Management Studio Express?
(Scott Lowe) With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own Microsoft SQL Desktop Edition. SQL Server Management Studio Express — a full-featured management
Installation viewlets: IBM DB2 Content Manager V8.3 installation examples
(Michael Ahern) These downloadable files are screen captures of IBM DB2 Content Manager version 8.3 installations presented as Shockwave Viewlets. You may download the appropriate viewlet and graphically walk through each process step-by-step.
The bcp utility does not return the correct value of the %ERRORLEVEL% variable on some errors in SQL Server 2000
When you use the bcp utility to copy data between an instance of Microsoft SQL Server 2000 and a data file in a user-specified format, you may notice that the bcp utility does not return the correct value of the %ERRORLEVEL% variable on some errors.
Visual Studio 2005 Web Application Projects and Web Deployment Projects
(Rick Strahl) In May, Microsoft released version 1.0 of Web Application Projects, a much needed add-in for Visual Studio 2005. This article sets out why I strongly recommend you check them out if you’re building and deploying VS 2005 / ASP.NET 2.0 web applications.
ASP.NET Tip: Control the Layout of Your Input Forms
(Eric Smith) Although many of your input forms will have a fixed number of fields, in some cases you’ll need to vary the number and configuration of your controls. This article demonstrates how to control the layout of your form using a Repeater control and the ItemDataBound event to set various att
.NET random number generators and distributions
(Stefan Troschütz) The idea for this article was already born 2004 when I was working on my bachelor thesis which included the implementation of a simulation and test environment for a flow control algorithm. Due to various reasons I chose to implement it as a managed application developed with C#.