Quick Tip: Granting access to meta-data on MySQL

Ever seen this exception in your log files when working with MySQL as your database back-end? User does not have access to metadata required to determine...

0 replies - 214 views - 03/22/08 by Schalk Neethling in Tips and Tricks

Microsoft SSDS - Dumb Name, Brilliant Idea

A Google News search for Microsoft SSDS, the SQL Server Data Services it announced last week, yields just six articles – SIX! A random nonsense search term...

1 replies - 1069 views - 03/19/08 by Tim Negris in News

Querying the File System - From ColdFusion to SQL Server

While looking for a solution of a different problem, I realized that SQL Server has a feature called extended stored procedures. Extended stored procedures, at...

0 replies - 754 views - 03/17/08 by Boyan Kostadinov in News

RESTful representation of "sakila" using GlassFish and NetBeans IDE

"sakila" is the sample database shipped with MySQL (pronounced as my ess-kew-ell). In the context of Sun Microsystems announcing the agreement to...

0 replies - 555 views - 02/13/08 by Arun Gupta in News

Greenplum Revs Internet-Scale Database

Greenplum, the other (Postgres/Bizgres-based) open source database near and dear to Sun besides MySQL, this one capable of messaging a petabyte of data and...

0 replies - 467 views - 02/13/08 by Maureen O'Gara in News

Querying Active Directory Through SQL Server

Integrating your application with Active Directory (or another LDAP based directory) is a common requirement in many business applications. Almost every...

1 replies - 2726 views - 02/11/08 by Boyan Kostadinov in News

Get Business Days and Working Hours in a Month

In business applications, there often is a need to know the number of business days and/or hours in a month/year. There is a dozen ways to do this depending on...

0 replies - 1038 views - 02/07/08 by Boyan Kostadinov in News

Custom Date Formatting in SQL Server

Most people that use SQL Server are familiar with formatting dates inside SQL Server. The common approach is: convert(varchar, getdate(), 106) -- Displays a...

1 replies - 3526 views - 02/04/08 by Boyan Kostadinov in News

Why Microsoft Needs Yahoo: the Real Story

So one day, Scott McNealy, founder and chairman of Sun, read in his morning newspaper how the use of Java was rapidly diminishing, courtesy of something called...

0 replies - 9433 views - 02/03/08 by Ivo Jansch in News

Is LINQ leaving Java in the dust?

Interesting story today asking whether LINQ has given .NET an edge over Java. LINQ is best-known as a way to embed SQL-like statements directly in code. ...

16 replies - 4411 views - 01/30/08 by Alex Miller in News

LiquiBase 1.5.0 Released

LiquiBase Core 1.5.0 is now available for download from http://www.liquibase.org/download. LiquiBase is an open source database version control and...

0 replies - 1416 views - 01/29/08 by Nathan Voxland in News

If Microsoft Pushes It Out Much Further They Won’t Be Able To Call It SQL Server 2008

Something has happened – or maybe didn’t happened – that has caused Microsoft to delay the release of SQL Server 2008 to the calendar three quarter. It...

0 replies - 593 views - 01/28/08 by Maureen O'Gara in News

MySQL creator releases Maria, the new engine that will replace InnoDB

A blog posting from MySQL founder and original developer, Michael "Monty" Widenius, announces the release of a major new database engine called...

6 replies - 4883 views - 01/28/08 by Rick Ross in News

Oracle Essentials

The book's preface says it all: "We've tried to make this an ideal first Oracle book for a wide spectrum of Oracle users - but not the last!" They identify an important audience for the...

0 replies - 469 views - 01/23/08 by Meera Subbarao in Book Reviews

Sun Backs Postgres House on Heels of MySQL Acquisition

The ink was still drying on Sun’s billion-dollar deal to buy the webby, low-end open source database house MySQL when Sun turned around and put money...

0 replies - 2043 views - 01/22/08 by Maureen O'Gara in News