|
|
ADO.NET Picks Up SQL Provider Support
IBM, MySQL, and other SQL database providers plan to support the ADO.NET Entity Framework, currently available as version Beta 3. Microsoft has touted ADO.NET as an easier mechanism for constructing data-centric services without regard to the underlying data source. A number of SQL vendors plan to support this with their products.
Date: 2007-12-07
New SQL Server Backup Solution Developed By Cortex I.T. Labs
A new SQL Server backup solution has been developed by Cortex I.T. Labs (developers of BackupAssist) and it is said to be unique. The product apparently provides not only disaster recovery of critical data, but complete protection from the start.
Date: 2007-11-01
Single Quotes In A Query Issue
Alex had a problem with his SQL. This is actually a frequently asked question and I've covered it here before (I think so anyway), but I thought I'd mention it again.
Date: 2007-10-08
Oracle SQL Developer 1.2
Oracle released the latest version of its SQL Devleoper the other day, version 1.2. This version features new capabilities to ease the migration and consolidation of third-party databases onto Oracle Database 11g according to the company.
Date: 2007-09-21
SQL Server Express & Remote Access
What a pain this has been! I've never dealt with Microsoft SQL Server before but now that Vista runs acceptably on VMware Fusion, I figured that it would be a good opportunity to install SQL Server Express as a test database.
Date: 2007-08-14
How Much Does MySQL Make?
Reading Dave's post on MySQL's IPO range of $600M - $1B, I started to wonder what type of revenue we're talking about. If you have access to IDC's massive pivot table with Software Vendor revenues (license & support only - services are excluded) split...
Date: 2007-07-03
Getting The Autonumber Insert ID
I love this. So I assume most folks knew about the result attribute added to cfquery in ColdFusion 7. If not - you are missing out. It returns quite a bit of good information about your query. But best of all - it was updated in ColdFusion 8.
Date: 2007-06-19
SQL Tuning
Companies that rely upon database information obtained by SQL queries commonly encounter performance issues as their databases grow to contain mass amounts of information. Over time, the same processes that have historically proven successful...
Date: 2007-06-08
Sql Server Interview Questions: Store Procedures
A Store Procedure is a Sql Query that is stores in database in Sql Server. One thing is that there is no need to query to be write on front end code. Using store procedure improves performance now the question arise how its improve performance.
Date: 2007-05-22
Dot Net Questions: System Tables and Sql Server 2000 Query
System tables are the groups of table that helps sql server to track the information regarding users, databases, tables, replications tasks and so many task and also helps in sql query just like insert query, delete sql query, update sql query.
Date: 2007-05-08
MySQL Conference 2007, Santa Clara, CA
This is my first trip to Silicon Valley and the first thing that struck me as I approached the hotel was that I am certainly in one of the foremost tech havens on the planet.
Date: 2007-04-24
Removing Nulls From A DataTable
The individual cells in a DataTable can have a null value in the form of System.DbNull.Value. If the DataTable is created by querying a database through ADO.NET, you can write the SQL statement in a way eliminates nulls.
Date: 2007-03-27
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-03-13
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-03-01
TechCrunch, Others Love Linux, MySQL
A survey by Pingdom of seven heavily visited websites found plenty of Apache web servers and PHP coding on their platforms, where Linux carries the platform and MySQL handles the database needs.
Date: 2007-02-27
Installing A MySQL Database Using A MySQL Injection Script
Whenever you purchase or acquire a MySQL database (such as from a website like WebContents.org), chances are it will come as a MySQL injection script.
Date: 2007-02-20
MySQL IPO, Oracle Unbreakable Support For MySQL?
Matt Aslett writes that Oracle may be considering Unbreakable Support for MySQL and that MySQL Co. is likely to IPO later this year.
When MySQL files for IPO, we'll get to view their financials.
Date: 2007-02-06
Convert A MySQL Injection Script For Use In Microsoft SQL Server
MySQL Server is the most widely used database management system in the world, primarily because it is open source and free. Hence, most databases you may get from outside sources will probably be in the form of a MySQL injection script.
Date: 2007-01-23
Developing Countries Breeding Grounds For Open Source
Red Herring's Falguni Bhuta predicts "More (Open Source) momentum in developing countries":"Open-source software's transparent nature and low-cost will make it more popular among developing countries such as China and India...
Date: 2007-01-05
|
|
