DatabaseJournal.com Staff

[From ZDNet Blog] Microsoft is having a re-think about its SQL Server strategy and in particular about what it wants to do with SQL Data Services. Part of the company’s Azure services platform, SQL Data Services, it appeared was going to produce a fairly straightforward, if not even perhaps cut-down databases services platform. The article […]

[From Webreference] In this tutorial we will build an online bookmark system. This will be used to create a database for storing all our URL’s and their descriptions. There are many commercial and non-commercial applications that offer almost the exact functionality that we will create in our application; the difference is that we have full […]

[From PremiumSoft CyberTech Ltd.] PremiumSoft CyberTech Limited today released new software updates for Navicat. These releases include: Navicat for MySQL (Mac OS X) version 8.0.1. Navicat for PostgreSQL (Windows) version 8.1.9 Navicat for Oracle (Windows) versions 8.1.8 The article continues at http://www.navicat.com

[From SQL Server Magazine] CreateIntegersTable is a multistatement table-valued function written for Microsoft SQL Server 2005. You can use this custom tool to create a numbers table that works around nearly all the limitations that traditional techniques for building these tables usually involve. For example, traditional techniques might themselves involve cursors, loops, or identity columns. […]

[From Geekzone] Web-based Data Storage in a Cloud This document is for developers with at least a basic idea of what “Cloud Computing” is and are familiar with Microsoft developer tools (e.g. Microsoft Visual Studio 2008). You must have experience designing and/or implementing systems deployed in “traditional” hosted environments. The article continues at http://www.geekzone.co.nz/vs2008/6275

[From Softpedia] Microsoft is offering two releases of its database platform as free downloads. Both SQL Server 2008 Express and SQL Server 2008 Express with Tools went live on the Microsoft Download Center in February 2009 and are now up for grabs at no charge. According to the software giant, the Express edition of SQL […]

[From OTN] I just moved over from the Java world to PL/SQL. One thing I really miss from Java is the FINALLY section of a method. How can I get the same behavior out of PL/SQL? Unlike Java, PL/SQL does not support a FINALLY section. You can, however, emulate much of what this section does, […]

[From Mentat Technologies] Mentat Technologies is happy to announce the new version of DreamCoder for Oracle 2009 version 4.0, a powerful solution for Oracle administration development. Its flexibility and compatibility, in addition to a low price, make it a must have tool for developers who are increasingly working with oracle. You can download DreamCoder for […]

[From InternetNews] Last week was sure an interesting one for MySQL. First, we learned that found Monty Widenius was leaving Sun. A day later, the other shoe dropped as former CEO Marten Mickos decided he’d had enough fun in the Sun, too. With $1 billion dollars of Sun’s money invested in MySQL, is this a […]

[From SQL Server Performance] SQL Server Management Studio (SSMS) is a graphical tool which can be used by Database Developers and Database Administrators to perform development and administrative tasks on SQL Server 2008. SQL Server Management Studio (SSMS) tool was first introduced by Microsoft in SQL Server 2005. SSMS is a replacement for Query Analyzer, […]

[From Quest Software, Inc.] ALISO VIEJO, Calif., Feb. 4, 2009 – Quest Software, Inc. (Nasdaq: QSFT) today announced the newest edition of Spotlight on Oracle, a desktop-based monitoring and diagnostics tool that provides unique visibility into database processes and performance. Spotlight exposes current and future performance problems, ensuring that database administrators (DBAs) remain a step […]

[From PHP Builder] If you want to store binary data like images and html files directly in your MySQL database, this column is for you! I will show how you can store the data via the HTML forms “File” feature in your database and how you can access and use this data in your webproject. […]