(Michael Kimsal) I’ve seen this on and off for years, but never have it handy.
Other News
Book Review: DB2 9 Fundamentals
(Joe Cropper) Whether you want to obtain an IBM certified DB2 professional certification or simply become well-rounded in the fundamental concepts of DB2 and general database theory, this is your book.
Windows Presentation Foundation: Another piece of the .NET puzzle
(Tony Patton) The .NET Framework is growing so much that I’m unable to be proficient in all areas, but I still need to be aware of all of its features. For that reason, I am examining .NET 3.0’s Windows Presentation Foundation (WPF) for its application and usage.
Partitioning a Non-Partitioned Oracle system
(Alexander Yanushkevich and Bryan Hinds) Find out how to bring back manageability and responsiveness using Database Partitioning on your current ”Non-Partitioned” system.
Best practices for SQL Server backup maintenance
(Denny Cherry) Part of your regular backup procedures should include removing old database backup history from the msdb database. That reduces the size of the msdb database and improves performance of the Enterprise Manager or Management Studio applications when you use them to restore. (R)
Automatic Login with MySQL
(Sirgey) When running non-interactive MySQL commands one may submit MySQL credentials on the command line (we’ll share with you a better option after the break), e.g.: mysql –password=secret –user=username database_name < query.sql [membership level="0"] [pmpro_button level="14" text="Read More - Register for Free Membership"][/membership] [membership][standout-css3-button href="http://www.linuxjournal.com/node/1001956" opennewwindow=true]Read More[/standout-css3-button] (Community content) [/membership]
DB2 on Mac
(Antonio Cangiano) We now have a working Python driver for DB2 which is currently undergoing internal testing. The driver is similar to the Ruby and PHP ones, which means that you get an advanced and very easy to use API. It also means that if you are confident with the Ruby driver, you will be able
Working with AlwaysVisibleControl
(Nidal Arabi) If you ever wanted to fix a specific message on your web page, then you are reading the right article on how to do this using the AJAX Control Toolkit. Being able to convey your message in an elegant manner should always be one of your targets. In this article I will explain the Always
Testing AJAX Applications with VSTS 2008
(Jeff Levinson) Many Visual Studio Team System 2008 improvements are focused on testers: Most of the improvements are in the Tester and Developer editions, and focus around code metrics, Web testing, load testing and performance profiling.
EVENTDATA() function in SQL Server 2005
Normally the EVENTDATA() function is called when an event notification is fired. It returns information about the server or database events. In Transact-SQL, it has limited but very important usage. As far as Transact-SQL goes, it can be used only in DDL triggers or logon triggers which was introduc