|
|
Google Updates Analytics
Google have introduced the new Analytics and urges the use of the new ga.js page instead of the old urchin.js. This will allow webmasters and site owners to take advantage of the most up-to-date tracking functionality of Google Analytics.
Date: 2007-12-26
CFDBINFO & CFZIP For Quick Database Backups
All major database products have tools to let you backup their databases. MySQL makes it super simple with their command line tools. But what if you want to do it with ColdFusion? Doesn't everyone want to do everything with ColdFusion? I know I do! So let's look at a quick example.
Date: 2007-12-12
Google Sued Over Alleged Use Of Distributed Database Technology
Northeastern University has sued Google in the patent-friendly federal court for the Eastern District of Texas, accusing the search giant of infringing upon its work.
Date: 2007-11-14
Oracle Database 11g For Windows
Oracle has announced the general availability of Oracle Database 11g for Windows. This version is supposed to be optimized for Windows and .NET.
Date: 2007-10-24
Zoho DB Debuts
All that money must be weighing Google and Microsoft down - Zoho has stayed (at least) one step ahead by releasing a unique new online database product, Zoho DB, and initial impressions have been very positive.
Date: 2007-10-03
Oracle Accelerate For Small & Medium Businesses
In October 2006 Oracle launched their Oracle Accelerate Program, according to their Accelerate page... Oracle Accelerate delivers a complete set of applications, rapid implementation tools, and an industry-leading partner ecosystem, allowing companies to maximize their limited budgets and achieve unlimited possibilities.
Date: 2007-09-19
Database Explorer - ColdFusion 8 Sample App
The Database Explorer is a simple application that allows you to browse databases and write SQL. You can select a datasource, browse the tables (and columns), and then write simple SQL statements and see what they return.
Date: 2007-08-27
Why SQL Gets It
There has been some discussion about MySQL's recent moves to clarify the targeting between MySQL Community Server & MySQL Enterprise Server.
Date: 2007-08-15
Understanding Live Data Backups With SBAdmin
As the need for system availability increases, especially in 24 hour operations, the backup "window" must decrease to prevent data from changing while being backed up.
Date: 2007-07-11
Building A Bug Tracking Database
Whenever you're working with new software, and especially if you're working in development, you're bound to encounter bugs. A good bug tracking system is essential.
Date: 2007-06-25
MySQL FULLTEXT Indexing & Searching
MySQL has supported FULLTEXT indexes since version 3.23.23. VARCHAR and TEXT Columns that have been indexed with FULLTEXT can be used with special SQL statements that perform the full text search in MySQL.
Date: 2007-06-13
Review: Refactoring Databases
Scott Ambler and Pramod Sadalage wrote Refactoring Databases, they say, "to share their experiences and techniques at evolving database schemas via refactoring".
Date: 2007-06-06
Sql Server Interview Questions on File Server and Client Server Database
One of major things in two of this approach is of working with data but both of these works in different manner. In File Server Database approach the data is stored in the file and user have to take data directly from the file.
Date: 2007-05-23
CfObjective - Mark Mandel & Transfer ORM
(As before please pardon the writing.) The problem that we need to solve is writing all the objects that model your database. This is a long and painful process. The basic creation by itself is bad - but it gets worse when you make updates to your database.
Date: 2007-05-09
Google Selects MySQL Goodies For Open Source
Some of Google applications use the MySQL database, and internal performance enhancements made by Google engineers have been publicly released. Database professionals who prefer to work with MySQL may be interested in how Googlers use the open source database.
Date: 2007-04-25
What Employers Seek In Oracle Candidates
There are hundreds, if not thousands, of high tech computer jobs open for those with Oracle expertise. The highly reputable and popular Oracle products are used by firms in every part of the globe.
Date: 2007-04-04
Important Issues Regarding Database Tools
The sql server primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Sql server express and Sybase.
Date: 2007-03-21
DevWeek: Day 2 Recap
Niels Berglund's "ADO.Net v.Next and the Entity Framework" was the first lecture of the day, I decided to skip Dino Espistos lecture after I read his slides and decided to go for something that I had not even looked at.
Date: 2007-03-01
Free Performance Dashboard for SQL Server
Idera SQLcheck is a free SQL Server performance dashboard that gives you real-time stats
about your database, hardware & operating system - all from an easy-to-read & use console.
Date: 2007-02-28
Record Locking In SQL Server
Pessimistic and Optimistic Concurrency. In a multi-user environment, there are two models for updating data in a database: optimistic concurrency and pessimistic concurrency.
Date: 2007-02-21
Installing Fusebox
A quick editorial note. I mentioned last week that I would be playing with Fusebox and trying to learn the basics. In case anyone comes in via Google I wanted to be clear that these are my experiences as I learn.
Date: 2007-02-07
MySQL Administration Via ColdFusion
A user asked me if it was possible to backup and restore a MySQL database from ColdFusion. There are multiple ways of doing this, but the basic answer is that you can do this very easily.
Date: 2007-01-24
MySQL Optimization Tips
Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.
Date: 2007-01-03
|
|
