eBusiness Help
Rackspace managed Hosting: Fanatical Support™ and Guaranteed 100% network uptime.
1 hour hardware fix and many more business critical support features.
Sweet deals for iEntry members! Out with the old, in with the new...
if you have equipment that qualifies for trade-in, get a discount of up to $720* off the Web price on featured IBM ® ThinkPad ® notebooks.

WebProWorld Dev Forum

What keeps the best stats?
Can someone tell me what is the most accurate way to keep website statistics? I don't want a million different parameters just basic stats.

ASP resource question
I learned of the wonderful concept called "include files". And as soon as I figured out that they could encapsulate code and layout, I became a religious user of at least one per project.

Live Stats/Raw Logs/FF question
I just made a rather strange discovery and I'm not sure what it means. I'm using Live Stats.XSP for my clients, and I have access to my raw logs



Recent Articles

MySQL De-Wormed
The MySQL bot worm that was attacking Windows was stopped dead in its tracks late Friday according to a report by Cnet.

Worm Variant Targets Microsoft Servers Running MySQL
Security companies have identified a variant of the Forbot worm that targets Windows servers with MySQL, an open database software package, installed.

Oracle Releases Critical Patch Update
Oracle has released a group of critical security patches for a number of the company's products.

Improving SQL Performance
How do you know how much hardware is really needed by your applications? And what do you do when your applications are overloading your system?

Where Will You Store Your Data?
Over on SiliconBeat, I ran across their How big is Bloglines? story. Before I get into what I really wanted to say. I feel compelled to say that I think they (SiliconBeat) are doing a very good job of not only reporting what they learn, but also internalizing it.

03.15.05


Report Casts Doubt on SQL Server 2005 Scalability
SQL Server 2005 will likely be a dud at delivering high-performance computing, according to a new report from Forrester Research Inc.

This major upgrade of Microsoft Corp.'s enterprise relational DBMS is due in the summer. Summer being only a few months away, it's "surprising" that no TPC-C results have yet been published, according to Noel Yuhanna, author of the report, titled "SQL Server 2005 Likely to Fall Short in High-End Performance Delivery." ADVERTISEMENT
Read The Whole Article


Mimer SQL Mobile now available on Nokia Series 60 Platform
Mimer Information Technology AB today released Mimer SQL Mobile for smart phones running Nokia’s Series 60 Platform, built on the Symbian OS™, the open global industry standard operating system for advanced mobile phones. With the availability of Mimer SQL Mobile for the Series 60 Platform, developers of applications for smart phones from leading mobile phone manufacturers including Nokia, Panasonic, Samsung, and Siemens can benefit from the Mimer SQL Mobile database server. A development and evaluation version of Mimer SQL Mobile for the Series 60 Platform is available for free downloads from the Mimer SQL web site (http://www.mimer.com/).

Sweet deals for iEntry members! Out with the old... if you have equipment that qualifies for trade-in,
in with the new. Get a discount of up to $720* off the Web price on featured IBM(r) ThinkPad(r) notebooks.
And ask about our battery offer. See full details of offer.
Hurry! Offer valid from IBM in the US only through 3/28/05 or while supplies last.

By extending its Mimer SQL Mobile database technology to Nokia’s Series 60 Platform, Mimer Information Technology makes it possible for software developers to build advanced mobile database solutions for Symbian OS-based mobile phones from LG Electronics, Lenovo, Nokia, Panasonic, Samsung, Sendo and Siemens. Mimer SQL Mobile for the Series 60 Platform on Symbian OS is a full-fledged DBMS server with support for data compression, multimedia data and standard interface connectivity. The product also includes features like multi-user database access and 100% industry standard SQL -- full transactional support, stored procedures and triggers -- features otherwise only found in high-end DBMSs. Mimer SQL Mobile also includes support for efficient and economical mobile client access to database servers using GPRS and 3G, making it possible to offer database services to large numbers of mobile clients simultaneously communicating with server databases.
Read The Whole Article


Moving A SQL Server Database
A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server. The database will be offline during the move but it is better to have it offline than to miss transactions when backing up and then restoring the database on the new server.

A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server. The database will be offline during the move but it is better to have it offline than to miss transactions when backing up and then restoring the database on the new server.
Read The Whole Article




Get better SQL Server performance before you improve the queries
When looking at SQL performance there's an immediate desire to jump into the queries that the SQL Server is being forced to process and see what can be done to improve them. Unfortunately, it's not always that simple. Sometimes the queries are coming from packaged software that cannot be changed. Other times the queries come from report writing tools and there's just no way to make the queries any better.

It's those times when it's critical to take a look at the server you have and figure out if it's really running as fast as it can.
Read The Whole Article

About SQLproNews
SQLproNews is a collection of up to date tutorials and insightful articles designed to help SQL users of any skill level implement successful SQL systems and practices. SQL Strategies and Tactics for Business

SQLproNews is brought to you by:

SecurityConfig.com NetworkingFiles.com
NetworkNewz.com WebProASP.com
DatabaseProNews.com SQLProNews.com
ITcertificationNews.com SysAdminNews.com
SQLproNews.com WirelessProNews.com
CProgrammingTrends.com SysAdminNews.com


-- SQLProNews is an iEntry, Inc. publication --
iEntry, Inc. 880 Corporate Drive, Lexington, KY 40503
2005 iEntry, Inc.  All Rights Reserved  Privacy Policy  Legal

advertising info | news headlines | free newsletters | comments/feedback | submit article

SQL Strategies and Tactics for Business SQLproNews News Archives About Us Feedback SQLproNews Home Page About Article Archive News Downloads WebProWorld Forums Jayde iEntry Advertise Contact