(Jonathan) While everyone tries to improve speed and performance in MySQL, other databases have realized that adding features that cut down on development time and improving time-to-market is what some people are looking for. MySQL is well known for great performance and it might be time to discover
Other News
Index Compression Part I (Low)
(Richard Foote) Index compression is perhaps one of the most under used and neglected index options available. It has the potential to substantially reduce the overall size of Non-Unique indexes and multi-column Unique indexes, in some scenarios dramatically so. A smaller index, especially if it sta
Centralized vs. Decentralized Datasources in Reporting Services
(Rob Fisch) The Reporting Services datasource is a programming object that holds the configuration information on how to access data for reporting. This includes the server name, database name, the type of data source (i.e. SQL Server, Oracle, text file, etc.) and the credentials of the user accessi
The SQL Server Information Divide
Latest SQL Server Show, SelectViews, Posted Today’s show is a sample session from the virtual conference – TSQL101 – this session is an intro primer into using TSQL. Find out about the basics, see a sample session from the conference and, while you’re at it, pencil in that third week in June… > Watch Here Also Available [Watch] SQLonCall – […]
Wow – one-time charge for DB2 for z/OS!
(Peggy Zagelow) Announced today: New pricing options for DB2 for z/OS running new workloads! All you data center folks who lament to us that pricing for “other” databases can’t be compared to DB2 for z/OS – rejoice!!
SQL Server 2008 February CTP Installed: New XSD Features for XML Data
(Stephen Forte) The SQL Server 2008 February CTP is now installed. I did it on my daily machine to force me to use it in a more realistic environment. It installed a-ok with my default SQL 2005 instance. As you can see below you can use the SQL 2008 IDE to manage and work with both SQL Server instan
Web Services: RPC, REST and Messaging
(Paul Done) For the implementation of Web Services in the enterprise environment, I’ve seen many different technologies used. Recently, in my spare moments, I’ve reflected on this and have come to the conclusion that all these technologies tend to fit one of three models (or hybrids of these models)
SQL Tips & Techniques- String Aggregation
(Radhesh Kumar) In my experience, application or database developers will have to deal with writing SQL queries more than a DBA (specially a System DBA). However, many a times DBAs are expected to help with writing complex queries. Keeping that in mind, I have decided to post SQL tips and techniques
Setting the execution order of Triggers in Oracle 11g
We are all aware that we can write multiple triggers on a single table based on the business requirement(s). One can have ‘BEFORE INSERT’ trigger on the table to generate a running number and on the same table there can be an ‘AFTER UPDATE’ trigger to calculate new value for another column. We can e
XML in SQL Server Part 1
(Vijaya Kadiyala) XML was developed by the World Wide Web Consortium (W3C). All companies using XML and related technologies try to follow the XML standard that is in place.