(Sergey Petrunia) TL;DR: Priority queue optimization for filesort with small LIMIT is now visible in MariaDB: there is a status variable and you can also see it in the slow query log (KB page link).
Other News
Management of Windows Azure SQL Databases via PowerShell with REST APIs
(Marcin Policht) Management of Azure SQL Databases has been greatly simplified by introduction of the Azure PowerShell module, which includes a collection of cmdlets that handle the most common administrative tasks targeting cloud-resident SQL Server instances and their databases.
SchemaBinding – What & Why
(Kenneth Fisher) When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables or views. So what does that mean?
SQL SERVER – SSMS: Top Object and Batch Execution Statistics Reports
(Pinal Dave) The month of June till mid of July has been the fever of sports. First, it was Wimbledon Tennis and then the Soccer fever was all over. There is a huge number of fan followers and it is great to see the level at which people sometimes worship these sports.
WPF Media Controls – MediaElement – Media Events
(Richard Carr) The eighty-sixth part of the Windows Presentation Foundation Fundamentals tutorial continues the examination of the MediaElement control. This article adds events to the example player to detect media opening, ending and failing.
Normalizing HTTP Header Values Using CFHttp And ColdFusion
(Ben Nadel) Last week, Saravana Muthu point out that my Sticky CDN project (a content delivery network for local development environments) couldn’t handle complex values in HTTP request header responses.
Grid/CRS AddNode or runInstaller fails with NullPointerException
(Jeremy Schneider) Posting this here mostly to archive it, so I can find it later if I ever see this problem again.
Loading XML documents into an Oracle database (1)
(Marco Gralike) Very often people want to load XML documents into an Oracle database so, for example, they can shred the needed values from those XML documents into relational tables.
Leveraging User Mental Models To Create Effective User Interfaces
(Peter Vogel) The principles of great UI design start from a different place than the principles that lead to great application design. They both end up in exactly the same place, though.
Master Data Confusion
Maurice has been a regular contributor to my column with insightful responses and helpful tips. Today Maurice responds to the topic of Master Data Management. He writes: Duplicate Data is expensive in development costs. If the data would have the same structure everywhere replication mechanism would reduce costs, but often you see duplicate data attributes associated in several ways with […]