(Peter Zaitsev) One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults to HASH index type by default, instead of BTREE which makes indexes unusable for prefix matches or range lookups. This is however not performance gotc
Other News
Index Only Values Of Interest: (Little Wonder)
(Richard Foote) Thought I might expand a little on the discussion and comments on how NULLs can be indexed and address point #6 on my list of those things you may not have known about indexes
SQL Server 2008: First Impressions
At our organization we have had limited exposure to SQL Server 2005 because SQL Server 2000 just works. We have worked with SQL Server 2005 in some particular areas, but we do not have the enterprise experience we need to move forward. We know support will be lifted for SQL Server 2000 and know we
The Convergence of Web 2.0 Mashups and SOA
(Rakesh Saha) Enterprise mashups – the convergence of Web 2.0 mashups and service-oriented architecture (SOA) – can create a world of opportunities for enterprises to come up with internal and customer-facing self-service, composite and “situational” applications. These applications can be created j
.NET Debugging Demos Lab 1: Hang – Review
(Tess Fernandez) Earlier this week I published the first .NET Debugging Demos Lab. If you haven’t downloaded and tried it out you can get it here.
SOA data services for workers’ comp rehabs mainframe
(Rich Seeley) Like the COBOL programmers who coded their original applications decades ago, mainframes are showing their age but still do useful tasks in the service-oriented architecture (SOA) implementation at the Ohio Bureau of Workers’ Compensation (BWC). (R)
Using MS Access with PostgreSQL
(Leo Hsu and Regina Obe) Many in the PostgreSQL community use Microsoft Access as a front-end to their PostgreSQL databases. Although MS Access is strictly a windows application and PostgreSQL has its roots in Unix, the two go well together. A large part of that reason is because the PostgreSQL ODBC
Did You Know: You can define your own Hotkeys!
(Kalen Delaney) One feature of SQL Server 2005 Management Studio that I have been known to complain about is the mechanism behind customizing your own hotkeys. Oh, yes, there is an interface for it, but once you’ve defined a key sequence, it doesn’t work like I wanted it to.
Oracle BI EE 10.1.3.3/2 – Report Comments in Dashboards and Chat Options – Using Writebacks
(Venkatakrishnan J) I was asked by an end user the other day about the possibility of having an option in BI EE wherein users can enter comments about the reports and the report layouts. The user mentioned that this would be very useful during the initial project roll outs wherein end-users might ne
SQL Server 2008… Some Possibilities
Featured Article(s) Upload employee picture into a table (Vadivel Mohanakrishnan) This article explains one of the ways to upload an image into a table. The target audience of this article are ‘beginners to intermediate’ level of readers. SQL Server, The OS, Counters… It All Matters Keep track of the different key vital signs for your SQL Servers, from the various […]