SQL on SWiK

What's New in FOR XML in Microsoft SQL Server 2005

Sat, 19 Jul 2008 13:46:33 -0700

MySQL :: Managing Hierarchical Data in MySQL

Sat, 19 Jul 2008 10:45:39 -0700

Sphinx - Free open-source SQL full-text search engine

Fri, 18 Jul 2008 18:51:14 -0700

SQLite Manager :: Firefox Add-ons

Fri, 18 Jul 2008 17:50:25 -0700

Beginning SQL Server 2005 XML Programming

Fri, 18 Jul 2008 13:54:16 -0700

Talend Open Profiler: Open Source Data Quality & Profiler

Fri, 18 Jul 2008 13:52:37 -0700

SQLite Manager :: Firefox Add-ons

Fri, 18 Jul 2008 12:55:59 -0700

Log Buffer #106: A Carnival of the Vanities for DBAs

Fri, 18 Jul 2008 08:51:58 -0700

Greetings from Wisconsin! Welcome to the 106th edition of the Log Buffer. Mr. Edwards is on a brief holiday and kindly asked me to fill in for him. So join me as we take a tour of some of this week’s database blogging activity.

I’d like to start by sharing the story of MySQL engineer Andrii Nikitin’s young son, Ivan. The short story is that Ivan is in need of a bone marrow transplant and that would also require travelling outside of their native Ukraine for the procedure. The family is asking for donations to cover the cost of the operation and trip, so please consider donating via the previous link.

Now, moving on to the database topics, we begin with my own area of (relative) expertise, Oracle. The big news this week is the July 2008 CPU, or Critical Patch Update, which Oracle releases quarterly. The Integrity blog has a nice summary of what’s included in this latest patchset. I’m sure plenty of you will be heading to Oracle OpenWorld 2008 as well, and OTN’s Justin Kestelyn announced a community preview page with some sneak peeks of what to expect (spoiler: beer!).

In a quick round-up of Oracle 11g topics, Amit Bansal at AskDBA.org has a nice guide for installing Oracle 11g on Solaris 10. Meanwhile, Oracle performance guru (and fellow Wisconsin native) Greg Rahn makes a great case for using incremental global statistics on partitioned tables. I see that Tim Hall has taken a break from reviewing summer blockbusters to write up a nice article on AWR baseline enhancements in Oracle 11gR1, and Alex Nuijten at AMIS has a nice presentation on using Oracle 11g’s virtual columns to clean up your data model.
(more…)

These icons link to social bookmarking sites where readers can share and discover new web pages.

Sphinx

Fri, 18 Jul 2008 07:56:45 -0700

Sphinx is a full-text search engine, designed to integrate with SQL databases or an XML pipe mechanism.

How to use Kerberos authentication in SQL Server

Thu, 17 Jul 2008 13:01:43 -0700

SQL Protocols : Understanding Kerberos and NTLM authentication in SQL Server Connections

Thu, 17 Jul 2008 13:01:41 -0700

Stupid XML SSMS Trick > Article Rating This might be HAWTALTA for some of you. > SQL Server Blog by Jason Massie Article Rating This might be HAWTALTA for some of you.

Thu, 17 Jul 2008 13:01:32 -0700

Make hyperlinks in your SQL results

[from rugi] Finding records in one table not present in another table

Thu, 17 Jul 2008 08:55:16 -0700

Ray's blog : Weblog

Thu, 17 Jul 2008 08:50:41 -0700

hibernate.org - A Short Primer On Fetching Strategies

Thu, 17 Jul 2008 07:49:46 -0700

HIBERNATE - Relational Persistence for Idiomatic Java

Thu, 17 Jul 2008 07:49:46 -0700

HSQLDB

Thu, 17 Jul 2008 05:51:25 -0700

Jailer

Thu, 17 Jul 2008 01:53:46 -0700

HeidiSQL - MySQL made easy

Thu, 17 Jul 2008 01:51:20 -0700

System.Xml.Serialization.XmlSerializer - Serialize Class to Xml in .NET - Bulk Load Data To SQL Server Faster

Wed, 16 Jul 2008 23:53:08 -0700

sqlite-manager - Google Code

Wed, 16 Jul 2008 23:51:15 -0700

Manage all your sqlite databases using this lightweight extension for firefox, thunderbird, sunbird, seamonkey, songbird, komodo, etc. (See the complete list of supported applications<sep/>

Are you sure you?re reading the second edition of High Performance MySQL?

Wed, 16 Jul 2008 22:49:23 -0700

I have been getting a lot of comments and errata from people who seem to be mistakenly buying the first edition and believing it’s the second edition. A lot of the blame for this probably rests with Amazon, who did not distinguish between the two editions at all until the editor and I (among others) leaned on them persistently for about 6 weeks. I think some people are buying the second edition and getting the first edition.

I’ve even spoken to people in person who said “yeah, I’ve been reading it” and I give them a copy of the second edition to hold in their hands, and they go “whoa, that is like twice the size. I don’t have this edition at all.”

If you have any question at all, just look at the front cover. If you have the second edition, you will see it clearly in the upper right-hand corner of the cover, as shown in this picture:

I feel like a Microsoft Anti-Piracy Minion “educating” you about how to verify that you are installing Genuine Spyware. Don’t worry, the feeling will pass and I’ll be okay *grin*

If you ordered the second edition and got the first edition, Amazon should send you a new book free of charge. If they’re really making the mistake that they seem to be, I predict they’ll fix it when it starts costing them money.

No Tags

phpMinAdmin

Wed, 16 Jul 2008 19:51:05 -0700

MediaWiki Database Schema

Wed, 16 Jul 2008 18:53:18 -0700

Slashdot | MySQL Readies Release Candidate For 5.1

Wed, 16 Jul 2008 17:50:33 -0700

How to use Kerberos authentication in SQL Server

Wed, 16 Jul 2008 16:52:09 -0700

I Am Not Myself - NHibernate: Testing The Performance Urban Legend

Wed, 16 Jul 2008 14:48:54 -0700

Source Code Highlighter

Wed, 16 Jul 2008 10:53:59 -0700

JavaScript++かも日記: 【JavaScript】iPhoneでSQLデータベースストレージが使える

Wed, 16 Jul 2008 09:58:08 -0700

XML Workshop XXI - Generating an ATOM 1.0 Feed with FOR XML EXPLICIT - SQL Server Central

Wed, 16 Jul 2008 09:54:31 -0700