(Ian Semmel) This program reads the MySql informational_schema database and, after the user has selected the target database, creates a C# source file containing typed dataset and TableAdapter classes for the contained tables.
Author: SSWUG Research
Memory Management with PHP
(Sara Golemon) Memory management is critical to long-running programs like server daemons, so understanding how to allocate and free memory in PHP is crucial to creating these programs. This chapter covers memory management in PHP.
Strategic Initiatives: Evolving Microsoft Access Applications to Microsoft SQL Server
(Dan Haught) This whitepaper explores the issues related to upsizing Microsoft Access applications to take advantage of the performance, security, and reliability of Microsoft SQL Server. (pdf)
Build once, deploy everywhere
(Marichu Scanlon) Historically, customers who wanted to develop and deploy SQL and Java stored procedures could do so by using the Stored Procedure Builder delivered in DB2 for Universal Database (UDB) V7, or its successor, the Development Center. The process involves a “full build” of the stored pr
How to bind a XML file to a GridView
(fstrahberger) Sometimes you want to use a XML-File rather than a database to store your information. Maybe you don’t have a database at your hosting account or you have mostly static data. This article explains how to bind an XML-File to a GridView in four lines of code.
Easily roll out ASP.NET applications
(Tony Patton) Moving a Web application from one server to another can be time consuming, but Microsoft makes it easy with ASP.NET applications. See how you can utilize a Web setup project or copy a project option in Visual Studio .NET or copy the files directly.
Partitioned outer join
(Jaromir D.B. Nemec) I first read about this feature from Jonathan Gennicks newsletter. The syntax used there was a “beta version”; instead of ANSI approved “PARTITION BY” a “WITHIN GROUP” clause was used. But on the first view it was clear: this is a great “gap filling” feature.
Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users
(Kevin Ferguson) So, you’re a Microsoft SQL Server administrator flirting with open source, but you’re not sure how far you should go on the first migration? Don’t worry, there won’t be much peer pressure to go “all the way.” Look around and you’ll find that most businesses making the switch are goi
SQL Server performance tips
(Simon Harriyott) A colleague of mine has been looking at SQL Server performance, and come up with a great set of tips.
All About Enums
(Dino Esposito) Among the many benefits of writing magazine articles, I particularly enjoy reader feedback, especially when readers are inspired to try new things and report back with useful development tips. Recently I’ve had some interesting mail about enumeration types, so I’ve decided to talk ab