(Kaj Arnö) A while ago, I had a discussion with Stewart Smith, Vinay Joosery, Monty Taylor and a number of other MySQLers who know much more about MySQL Cluster than I do. The result is a model for using MySQL Proxy to offload MySQL Cluster from doing Table Scans, without touching the application.
Other News
A few bonus stored procedures for DB2 Version 8
(Willie Favero) It appears that a few interesting looking stored procedures have been added to DB2 via APAR PK46562 (see link below). They will allow you to bring administrative information back to an application program.
Data Web Services: Build Web services the new way to access IBM database servers
(Vijay Bommireddipalli) IBM Data Studio is a unified tooling platform that contains a comprehensive set of features to develop, administer, and manage your database servers. The development IDE of Data Studio packs in a number of features to assist in all your data related development needs. An inte
Altering Without Privileges
(Coskan Gundogar) There was a mail in Turkish Oracle Users group mailing list about “why a users can still alter a table despite all privileges has been revoked (only connect privilege is left). My answer was to double check if there is any privilege was left by selecting DBA_TAB_PRIVS for that user
Find Records That Cannot Be Converted to NUMBER
(Galina Petrenko) The following shows how to find table records where the value of a column cannot be easily converted into number.
Oracle BI EE 10.1.3.3/2 – One Dimension – Multiple Hierarchies
(Venkatakrishnan J) There was a question yesterday on the forums regarding the usage/availability of Multiple Hierarchies for a single dimension. I thought i would blog about it since there is very little documentation on this. Now let us take an example and try to understand what multiple hierarchi
Snapshot Reports II: SQL Server Management Studio Perspective
(William Pearson) As we noted in Snapshot Reports I: Report Manager Perspective, Snapshot caching is turned off by default. A significant difference between both Report Session and Report Execution caching (the subjects of earlier articles in this subseries) and Snapshot caching is that the first tw
Tricks to increase SQL Server query performance
(Denny Cherry) Thanks to the natural language roots of the SQL language, writing queries has become extremely easy for just about anyone to pick up. But its simplicity also makes it easy to write poorly performing queries. Here are some simple changes you can make to improve not only query performan
TSQL Regular Expression Workbench
(Robyn Page and Phil Factor) This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn’t even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to
Microsoft Moving Forward for Virtual Environments
New Show Posted (Live After 2:30a MST) Today’s show has a LOT of information. Interviews with some tools makers, information about protecting your holiday time, 60 second tip of the day, our SQL Server discussion list watch and a whole lot more. > Watch Now Featured Article(s) Find the list of SQL objects which got modified – SQL Server 2005 […]