(Jay Janssen) MySQL replication is cool. Almost everyone, when asked what they like best about MySQL, will mention replication. There can be no doubt that many web companies, Yahoo included, owes much to MySQL replication. How else can you scale the reading capacity of your database so easily?
Other News
FIX: The sp_droparticle stored procedure performs very slowly if the @immediate_sync property is set to TRUE in SQL Server 2000 Service Pack 4
In Microsoft SQL Server 2000 Service Pack 4 (SP4), the sp_droparticle transactional replication stored procedure performs very slowly if the @immediate_sync publication level property is set to TRUE.
Count Numbers, Upper-Lower Characters, and Symbols
(Ilya Petrenko) This query finds how many numbers, upper-lower characters, and symbols.
Protect ‘Data at Rest’ Using DB2 on Linux, UNIX or Windows
(Rebecca Bond) When we think about security, we often mention the term “security in depth.” Layer after layer, we build our security architecture attempting to achieve a robust defense mechanism. We put in firewalls, build access control lists, devise elaborate intrusion detection schemes, enforce
TechTip: Testing Stored Procedures
(Kevin Forsythe) If you’ve braved the intimidating unknowns of creating stored procedures, you’ve probably learned that support for them in IBM’s STRSQL command is limited. You can call a stored procedure only if it does not return a parameter or a result set.
Populate a Flex Accordion with XML
(Glenn Gervais) I’ve been spending a lot of time lately learning Flex. So far I think it’s fantastic. I’m amazed at how easy it is to put together a nice looking dynamic application with so little code.
CodeSnip: Changing the Color of a List Item’s Text at Run-Time with Visual Basic 2005
(Shaun Eutsey) Today has been one of “those” days. A co-worker asks for something that sounds easy, but in reality it becomes larger than it ever should have been. That, my friends, is a recipe for a migraine and a learning opportunity.
XLINQ Introduction Part 3 Of 3
(Sacha Barber) .NET 3.0 has now been released, so we should all know it by now shouldn’t we. Jeez, doesn’t seem like that long ago that .NET 2.0 came along. Well for those that dont realize .NET 3.0 actually contains quite a lot of new stuff, such as : –Windows Workflow Foundation (WWF) : Managi
An Introduction to Microsoft Silverlight
(Ziran Sun) What Is Microsoft Silverlight? Well that’s not really an easy question to answer. According to Microsoft: Microsoft Silverlight is a cross-browser, cross-platform plug-in for delivering the next generation of .NET based media experiences and rich interactive applications for the
Handling Messages in Console Apps
(Stephen Toub) I’m using a Win32 API through P/Invoke. The API supports asynchronous operations and provides a callback mechanism that notifies me when the operation has completed. However, unlike other APIs I’ve dealt with that provide similar functionality, this API doesn’t accept a function poin