|
Understanding SQL Web Hosting
Before
understanding the concept of SQL web hosting, it's necessary to have a basic grasp
on what SQL is, and also how web hosting works. SQL is the acronym
for Structured Query Language, which is a computer language that is used to manipulate
data...
http://www.sqlpronews.com/2005/1206.html
|
12.06.05 |
|
Programmer Overkill (MySQL)
I have a peeve about MySQL. Oh, not about MySQL directly: it's great. I love it, it's wonderful, no complaints. It's the people who use it when they don't need to that get me shaking my head and talking to myself.
http://www.sqlpronews.com/2005/1115.html
|
11.15.05 |
|
Oracle Picks Up Open Source Company Innobase
Big-time
tech company Oracle announced on Friday the acquisition of the Finnish Innobase.
The Innobase is an open source software company, known for its product, InnoDB.
http://www.sqlpronews.com/2005/1011.html
|
10.11.05 |
|
Microsoft
Showing Off SQL Server 2005 At Gitex
The
world's largest software company let the middle-eastern market take a gander
at the SQL Server 2005 and their development tool, Visual Studio 2005, at the
September edition of the Gitex conference in Dubai, UAE.
http://www.sqlpronews.com/2005/0927.html
|
09.27.05 |
|
Think
Outside the Data Center. Think SQL Anywhere.
Chances
are most of your customers run applications on off-the-shelf hardware, and don't
have on-site systems administrator support. But more and more, your applications
require enterprise-level data management capabilities.
http://www.sqlpronews.com/2005/0922.html
|
09.22.05 |
|
How
To Use SQLXML To Retrieve Data From SQL Server Database?
Using
SQL Server 2000 and above versions you can retrieve data from SQL Server in XML
format directly from the database. Many XML related features were incorporated
in the SQL Server database. This enables the development...
http://www.sqlpronews.com/2005/0920.html
|
09.20.05 |
|
Performance
Tuning Of A Daffodil DB
This article
illustrates the best practices to improve the performance of Daffodil DB / One$DB
JDBC Driver. This article focuses on how to improve the performance of a Daffodil
DB / One$DB JDBC application using Statement, PreparedStatemnt, CallableStatement
and ResultSet interfaces.
http://www.sqlpronews.com/2005/0824.html
|
08.24.05 |
|
Training
Underway For Microsoft SQL Server 2005
|
How
To Save An Image In A SQL Server Database?
Most web
applications have a lot of images used in them. These images are usually stored
in a web server folder and they are accessed by giving the relative path to the
file with respect to the root folder of the website.
http://www.sqlpronews.com/2005/0809.html
|
08.09.05 |
|
Synchronize
Multiple MySQL Databases With PHP
This article
could be very usefull for the owers of web service businesses. If you are offering
e-commerce, hosting, live support or ticketing web based services you have probably
met the discussed problem many times in your work.
http://www.sqlpronews.com/2005/0729.html
|
07.27.05 |
|
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.
http://www.sqlpronews.com/2005/0719.html
|
07.19.05 |
|
Think
Outside the Data Center. Think SQL Anywhere.
Chances
are most of your customers run applications on off-the-shelf hardware, and don't
have on-site systems administrator support. But more and more, your applications
require enterprise-level data management capabilities.
http://www.sqlpronews.com/2005/0622.html
|
06.22.05 |
|
Querying
System Tables
You might
have come across situations where it was necessary to copy all the details in
your database into another. To make the situation more complex, consider it between
different servers. Think, think and think very hard. Ultimately you end-up with
the solution which is inefficient and time-consuming.
http://www.sqlpronews.com/2005/0615.html
|
06.15.05 |
|
Creating
Dynamic Website Content With PHP - MySQL
Fresh
website content for your visitors can be of real benefit when attempting to generate
repeat traffic. Most webmasters, however, just don't have enough spare time to
frequently update or rebuild their pages manually.
http://www.sqlpronews.com/2005/0614.html
|
06.14.05 |
|
Now
is the time to change hosting providers
Imagine
a managed hosting provider that's as concerned with your uptime as you are. Rackspace
Managed Hosting offers a low-cost, rapidly-deployable, scalable hosting solution...
and these people are absolutely crazy about customer service!
http://www.sqlpronews.com/2005/0601.html
|
06.01.05 |
|
Error
/ Exception Handling in SQL Server
Many
programming languages have a fairly consistent behavior when there is a run-time
error / exception. Normally execution simply terminates in case of an error /
exception, unless you have set up an error / exception handler that takes care
of the error / exception
http://www.sqlpronews.com/2005/0524.html
|
05.24.05 |
|
SQL
Injections
Since
learning how to manipulate a database is usually the first thing programmers
learn it makes sense that learning about SQL injections should also be one of
the first things they learn. SQL Injections happen when a malicious user extends
your SQL query by writing a bit of code into the input box.
http://www.sqlpronews.com/2005/0510.html
|
05.10.05 |
|
Executing
SQL Server Stored Procedure from Perl
This
article illustrates how to setup a development environment using Perl and SQL
Server on the following platforms: Microsoft Windows, Red Hat Linux, and Sun
Solaris. Step by step, you can learn, and may choose, the best way that fits
into your own requirements.
http://www.sqlpronews.com/2005/0426.html
|
04.26.05 |
|
Microsoft
Great Plains SQL Reporting And Data Fixing
Our
and Microsoft Business Solutions' goal here is to educate the database administrator,
programmer, and software developer to enable them Microsoft Great Plains support
for their companies. In our opinion self support is the goal of Microsoft to
facilitate implementation of its products
http://www.sqlpronews.com/2005/0405.html
|
04.05.05 |
|
Report
Casts Doubt on SQL Server 2005 Scalability
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."
http://www.sqlpronews.com/2005/0315.html
|
03.15.05 |
|
Developers
release apps for MS SQL Server 2005
As
Microsoft puts the final touches to its SQL Server 2005 database a handful of
third-party developers have announced applications that will run on the product.
http://www.sqlpronews.com/2005/0222.html
|
02.22.05 |
|
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? The answer lies
with improving your SQL performance. You have to tune your hardware SQL server
and monitor performance, all of which will be explained as clearly as possible
on this page.
http://www.sqlpronews.com/2005/0120.html
|
01.20.05 |
|
Using
Profiler To Identify Poorly Performing Queries
Identifying
Long Running Queries is First Step. At this step in the SQL Server performance
audit, you should have identified all the "easy" performance fixes.
http://www.sqlpronews.com/2005/0114.html
|
01.14.05 |
|
SQL
Server Application And Transact-SQL Performance
Of
all the areas that can negatively affect the performance of SQL Server, the application
code used to access SQL Server data, including Transact-SQL code, has the biggest
potential of hurting performance. Unfortunately though, this is an area that
a lot of DBAs don't directly control. And because of this, this area if often
neglected when performance tuning SQL Server-based application.
http://www.sqlpronews.com/2005/0107.html
|
01.07.05 |
|
