(Ziran Sun) The first part of this article illustrated how to install and configure the MySQL Database Server, install and use the MySQL Administrator, create a new database, and create and populate a new sample table with some sample data.
Other News
You may receive a SqlException error message when your .NET Framework client application calls a stored procedure
When you use the SqlClient class in a Microsoft .NET Framework client application to work with Microsoft SQL Server 2000 hotfix build 2000.80.811 or a later version, you may receive an error message if the following conditions are true:• Your application tries to call a stored procedure. • The o
IBM demonstrates the true power of DB2 Universal Database with 64 Bit Intel Technology
IBM released a TPC-C result running DB2 Universal Database v8.2 that establishes records for both performance and price/performance on 4-way x86-64 hardware.
Program in DB2 UDB with Macromedia Coldfusion
(David Budreau) See how easy it is to connect Macromedia Coldfusion to IBM DB2 Universal Database (UDB) and create powerful Web applications with limited skills in DB2, Coldfusion, and HTML. Step through a basic Web application built with Coldfusion and DB2. Learn about setting up DB2 and Coldfusion
Inside the Firewall: Will Bigger Encryption Keys Keep Your BI Data Safe From Harm?
(Mark Leon) With a solid firewall, you may think your sensitive data is safe, but have you prepared for an attack from within? “Significant numbers of attacks are now coming from inside the firewall,” says Yankee Group analyst Jim Slaby.
Step-by-Step Guide: How to patch SQL Server, part 2
(Chip Andrews) Welcome to part two of our series on finding and patching SQL Servers in your organization. In part one we discussed how to find all of the SQL Server instances on your network. In this part, we’ll discuss patch deployment and the various options available to you. (R)
Recovering from ‘Compulsive Tuning Disorder’
(Sara Cushman) Performance tuning expert Gaja Krishna Vaidyanatha wants to help DBAs who suffer from what he calls “Compulsive Tuning Disorder” (CTD). Vaidyanatha, owner of consulting firm DBPerfMan.com and an author of several Oracle books, including “Oracle Performance Tuning 101,” coined the term
Executive Summary: Enterprise Metadata Framework
(R. Todd Stephens) Over the past few years, I’ve had the opportunity to discuss enterprise metadata to a wide variety of audiences and much of this conversation is captured in this “Best Practices” implementation framework. The model has evolved over the past few years as our program continues
CustomTypeDescriptor, Part 1
(Stephen Toub) I write a lot of one-off utilities for personal use, and since they don’t require any sophisticated user interfaces, I often use a System.Windows.Forms.PropertyGrid bound to a settings class in order to allow the user to configure a tool’s operations. Unfortunately, sometimes I do
Does EJB 3.0 really make application development easy ?
(Raghu Kodali) After reading through articles and posts regarding how EJB 3.0 is going to make application development simpler, I decided to give EJB 3.0 a spin and see if the claims are true.