(Peter Zaitsev) Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system.
Other News
Issues with running backup log with no_log or truncate_only
On my database server I have my databases set to the full recovery model, but the transaction logs get quite big, so I am issuing a BACKUP LOG with NO_LOG. I am not exactly sure if this causes any issues, but I know that I am able to free up space in my transaction log and shrink the file. Is […]
Are You A SQL Server Architect, Designer, Engineer, or … ?
Continuous Protection Have you ever wondered what happens to the information *between* backups of your database and the associated transaction logs? The short answer is that it depends. It depends on the solution you have in place – and one great approach is Double-Take – the software provides affordable recoverability, including continuous data replication and fail-over protection. Get more information […]
The Top 14 Things for SQL Server…
(A moment of silence in the U.S. – it’s tax day.) Responsible for SQL Server and/or SharePoint? If you’re the one that is managing the backup and recovery options for your servers, you need to make sure you have centralized management, status reporting and audit trails in place and giving you the information you need. The last thing you want […]
Remote Data Piping into DB2 for z/OS
(Ben Budiman, Joe Kidd and Johannes Schuetzner) With multi-tiered applications, there are often topologies with DB2 for z/OS as database backend and the application logic running on another platform like AIX, Linux or Windows. Using the DRDA protocol, the application remotely accesses DB2. An exampl
SpyComponents ValidatorBuddy Plug-In for XMLSpy
(Jerry Sheehan) XMLSpy currently supports DTD, & XML Schema schema languages out-of-the-box. However, there are others such as Relax NG which is also a grammar based schema language as DTD’s & XML Schemas. In addition, their is Schematron which is a rule based schema language. No current schema lang
Can an Apache XMLBeans Help Speed Java Devs on XML?
(Vance McCarthy) BEA wants to jump-start the Java community’s work on supporting XML standards and dev tools. Concerned that today’s Java efforts are moving too slowly, BEA has handed over its internally developed XMLBeans technologies to the Apache Software Foundation (ASF).
Up and Running with DB2 on Linux
(Whei-Jen Chen, Christian Hideaki Kondo, Helmut Riegler, Lifang LF Liu, Rahul Kitchlu, Rav Ahuja and Veiko Spranger) Linux is one of the fastest growing server operating platforms within the past few years. DB2 has long been known for its technology leadership. This IBM Redbooks publication is an in
Resetting Collation in SQL Server 2005
(dfbaskin) I accidentally installed a development version of SQL Server 2005 with a case-sensitive collation. This upset other SQL databases I was working with that were not expecting table names and etc. to be case sensitive. In SQL Server 2005, you can reset the collation by using setup with the R
Attribute Reporting on the Cube using SQL
(Bud Endress) In my last post, I noted that nearly reporting on the 11g cube occurs within SQL-based relational reporting tools such as Oracle Business Intelligence Enterprise Edition (OBI EE), Business Objects, etc. That’s no surprise given that these tools dominate the BI market and that the OLAP