(George J. Trujillo Jr.) The MySQL Migration Toolkit is a nice easy to use Wizard GUI tool for migrating databases to MySQL. The following site http://www.mysql.com/products/tools/migration-toolkit/ has some really nice tutorials for how to migrate the following databases to MySQL: –SQL Server
Other News
Simplify queries with SQL Server 2005 common table expressions (CTEs)
(Robert Sheldon) SQL Server 2005 introduced a valuable new Transact-SQL language component – a common table expression (CTE) — that can be a handy alternative to derived tables and views. By using CTEs, you can create named result sets to reference from within your SELECT, INSERT, UPDATE, and DELET
The SQL Server Information Divide
Latest SQL Server Show, SelectViews, Posted Today’s show is a sample session from the virtual conference – TSQL101 – this session is an intro primer into using TSQL. Find out about the basics, see a sample session from the conference and, while you’re at it, pencil in that third week in June… > Watch Here Also Available [Watch] SQLonCall – […]
(95) SelectViews: TSQL101 – Today’s Show Is A Sample Session From The Virtual Conference – Intro to TSQL.
Video Programming for IT Professionals
SQL Server Fly on the Wall
Catch the Latest Shows [Watch] SQLonCall – all about conferences [Watch] SelectViews – a new idea, tips, tricks and SQL Server goodies Featured Article(s) Tips for Improving ASP.NET Application Performance The performance of web applications has always been a major concern for application developers. It is one of the most important factors that we need to take care of. When […]
Book Review: Understanding DB2
(Troy Coleman) If you’re looking for a book that presents a well-rounded overview of DB2 for LUW and you’d like to know what’s new in version 9 and 9.5, look no further. “Understanding DB2: Learning Visually with Examples” can serve as a training guide for a beginner, a DB2 certification preparation
Create your own information space with Ajax and Del.icio.us
(Tyler Anderson) Del.icio.us is a social bookmarking Web site that allows users to create and share browser-independent bookmarks, accessible directly over the Internet, in ways your browser won’t allow. The traditional hierarchical organization of browser bookmarks is overhauled, allowing users to
A Quick Overview of the XML DOM Extension in PHP 5
(Alejandro Gervasio) To be frank, how many times in your life as a PHP developer have you had to deal with XML documents? Probably dozens of times, particularly if you use it to develop PHP applications that implement some kind of web service, or possibly when creating RSS feeds and template files f
Automatic markup and XML pipelines
(Jeni Tennison) The project I’m working on at the moment aims to use RDFa (in XHTML) to expose some of the semantics in some natural-language text. We’re aiming moderately low — marking up dates, addresses, people’s names, and various other more domain-specific things — at least at the moment.
Working with ADO.NET Schema APIs
(Bipin Joshi) In majority of data driven applications developers deal with SQL queries that select, insert, update or delete data from the database. However, at times you need to retrieve schema information from the database. Suppose you are building applications that performs data import and export