(Paul Moen) Filesorts and temp tables are a necessary evil in MySQL, used when MySQL must sort the data before returning the output to the user. They are the most common issue with slow queries in MySQL, the main reason being that if the output is too large, you can kiss goodbye in-memory performanc
Other News
Markup Compatibility
(Wouter van Vugt) The year is 2012. Open XML revision 2.0 has just made it through standardization by ECMA and of course ISO, despite heavy protests of Big Blue (and the still raging battles between the Autobots and Decepticons, since late 2005). Even though the new standard has been well received b
AJAX Test Automation
(James McCaffrey) The popularity of Web applications that use AJAX (Asynchronous JavaScript And XML) technology has increased steadily over the past year. When written correctly, AJAX can yield significant improvements in performance and user experience compared with non-AJAX Web applications. Howev
SQL Server integration with Microsoft Office 2007
(Serdar Yegulalp) Previous editions of Microsoft Office have provided some degree of connectivity between Office applications and third-party data sources. There has also been a fair degree of integration with SQL Server — which, I guess, counts as a first-party data source. But Office 2007 introduc
Improving the performance of queries using SQL Server Part 1
(Pete O’Hanlon) Lately, I’ve been answering a lot of questions about tuning queries in SQL Server and checking that the developer is making the best use of the database features. As a result of this, I have decided to put together a series of articles on how to get the best out of your database deve
Cast a BindingSource’s Current Object to a Strongly Typed DataRow Using the Visual Basic 2005 ‘dtBindingSourceCurrent’ Code Snippet
(Mike McIntyre) When you use a BindingSource, for example by dragging it on to a page to bind data to a DataGrid or BindingNavigator, you will eventually need to cast the object that is current in the BindingSource into a type you can use to read or edit it.
Preventing A Brute Force Or Dictionary Attack
(Bryan Sullivan) To understand and then combat a brute force attack, also known as a dictionary attack, we must start by understanding why it might be an appealing tool for a hacker.
Saving InfoPath Forms to SQL Server 2005 as XML
(S.Y.M. Wong-A-Ton) Microsoft SQL Server 2005 introduced a new data type, the XML data type. Now you can associate an XML schema with XML table columns to force them to adhere to constraints defined within the specified schema. Such XML table columns are ideal to save InfoPath forms in, since InfoPa
Regular Expression Based Token Replacement in ASP.NET
(Damon Armstrong) In my last article, I covered a technique for Token Replacement in ASP.NET, which works from anywhere in your application. Simply put, token replacement is a matter of searching through a string for a token and replacing it with a value of your choice. All of the code for making th
Customer support pet peeve, scale-out can create holes in security, book recommendation and much more.
Pro-Center Video Programming for IT Professionals