(Rob Gravelle) One nice feature added to the EXPLAIN statement in MySQL 4.1 is the EXTENDED keyword which provides you with some helpful additional information on query optimization.
Other News
SQL SERVER – IO_COMPLETION – Wait Type – Day 10 of 28
(Pinal Dave) For any good system three things are vital: CPU, Memory and IO (disk). Among these three, IO is the most crucial factor of SQL Server.
What Do You Look For in a DBA?
Have you seen the most recent video shows?! So much data, so many databases…to the moon! Cloud exit strategies, cloud security considerations, wireless access to data… Jeopardy!(tm) ….and the SSWUG Virtual Conference, Bus. Intelligence Upgrade hesitations and much more. [Watch the Show] Open source projects and SQL Server, FrontPage Lives?!, Business Intelligence is profiling…. or is it? SQL Server tools […]
Using ASP.NET, Membership, and jQuery to Determine Username Availability
(Scott Mitchell) Chances are, at some point you’ve tried creating a new user account on a website and were told that the username you selected was already taken. This is especially common on very large websites with millions of members, but can happen on smaller websites with common usernames, such
How to download a file in ASP.Net
(Andrew Fenster) Here is perhaps the simplest, shortest way to download a file in an ASP.Net application:
Embedding Images in XML
One of the really cool and oft-requested new features in XMLSpy 2011r2 is the ability to embed external files – such as images – directly in an XML document as encoded text. This gives you the option to package all required data from various external files together in one large XML document.
Styling ASP.NET GridView using jQuery Theme Switcher Widget 9retweet
(Suprotim Agarwal) In this article, we will see how to style the ASP.NET GridView using the jQuery Theme Switcher Widget.
Advanced replication for the masses – Part I – Getting started with Tungsten Replicator
(Giuseppe Maxia) MySQL DBAs and developers: oil your fingers and get ready to experience a new dimension of data replication. I am pleased to announce that Continuent has just released Tungsten Replicator 2.0, an open source data replication engine that can replace MySQL native replication with a se
Using Smart Content in the Enterprise
(Bill Ives) Here is a useful Gilbane research report on Smart Content in the Enterprise by Geoff Bock, Dale Waldt, and Mary LaPlante. It covers XML applications.
The semantic Web gets down to business
(Elisabeth Horwitt) It’s still early going, but e-commerce and other sites are finding the investment well worth their time, money and effort.