DatabaseJournal.com Staff

Being able to retrieve the data you need sometimes is a challenge for Data Analysts, especially, if you do not have the right expertise to query databases efficiently.  When project teams lack expertise in querying the database they turn to the DBA to help with writing the SQL statements necessary to retrieve the information they […]

While Oracle, with the purchase of Sun Microsystems, has been catapulted into server, storage, processor, networking, and even switch markets it would seem that the biggest debate revolves around the database markets. Who would have thought that an open-source database would cause such debate from all corners of the world and create such division within […]

by Jeffrey R. Garbus In-memory database (IMDB) is a technique used to place an entire database – data, logs, and all – in cache. This capability enables you to treat memory-resident data the same way you treat any other ASE data. Plus, it’s quick, easy, and integrated. Read on to learn more. Introduction “Why can’t […]

Internet.com has created a new newsletter, Database Daily, to deliver the latest enterprise database technology information and trends directly to you everyday. Like the other 15 million technical professionals in the Internet.com network-including 8 million interested in development-you need information in order to make smart decisions, and we have that information. In addition to the […]

For three years Microsoft has worked on Azure and for the last year beta testers have been putting it through the motions. But today, developers and customers can use the Windows Azure operating system and make use of the SQL Azure hosted database. Currently, some properties hosted on Azure are Live Mesh, Microsoft’s HealthVault, and […]

Starting tomorrow (Feb. 2, 2010) in St. Louis MO and running through Mar. 11, 2010, Microsoft will be hosting a 15-city tour of Windows Azure events for developers and IT Pros. At least in my area, this event has been split into morning and afternoon sessions. The morning is dedicated to Windows Azure for IT […]

As part of the slew of Oracle announcements last week around the acquisition of Sun, Oracle said that they would in essence cut out VARs for hardware sales, where it makes sense, and go direct—gaining back a good 10 percent profit margin that Sun was paying/losing to VARs. As CNET’s Stephen Shankland wrote, “Oracle is […]

>>Script Language and Platform: VBScript This script tests connectivity to SQL Server box from a client machine when there is no SQL Client installed. Usage: testconnectivity.vbs Servername dbname Loginname Password Author: MAK Download Script: testconnectivity.vbs_ Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained […]

Now is the chance to test and develop the cloud applications of Windows Azure – including a base level of compute hours, storage, data transfers, a SQL Azure database, Access Control transactions and Service Bus connections – all without cost. Three offers are available, one Open to Everyone, one for Microsoft Partners, and also for […]

Raima, a company that offers state-of-the-art embedded database technologies recently (January 26th) presented their new dataflow technology at the RTECC show in Santa Clara, CA. Scott Meder and John Pai of Raima gave a presentation that included a live demo on Raima’s RDMe dataFlow engine that can be used to move data from one device […]

Devart, a company specializing in native connectivity solutions and development tools for the popular databases has just announced the public availability of dbForge Studio for MySQL 4.00—giving developers and administrators extended capabilities to visually design databases as well as manage structures and objects, administer user accounts, debug code, and synchronize schemas and data. Some of […]

myLittleTools, a private company with the goal to “provide the best web-based tools in the SQL Server area,” has now released myLittleAdmin v3.6. This web-based application was specifically designed to manage MS SQL Server 2005 and 2008 reliably, efficiently, and securely from anywhere you desire. Some characteristics of myLittleAdmin are: Full integration with hosting control […]