|
FREE
Java™ Developer Resource Kit!  |
06.22.04
Mixed
Emotions About .NET Managed Code in SQL Server
Microsoft's impending release of the new capability to write stored
procedures in SQL Server is a big advance and technologically admirable,
but it raises serious questions about whether such a capability
is appropriate. In short, do managed stored procedures increase
or solve some of the management problems associated with writing
database-driven applications?
Many to One From a .NET developer's point of view, the new capability
is convenient, because it lets you avoid learning and using T-SQL.
With today's supersized frameworks, having one less language to
learn and keep up with is a definite advantage. In addition, because
you have full access to the framework's power, writing .NET code
for SQL Server is the equivalent of giving T-SQL modern object-oriented
powers, but without having to learn any new syntax.
Read
The Whole Article |
Displaying
Multiple Records Per Row in a MySQL Query Result Set
Ever wonder how you can query a database and display the result
set in something other than a one record per row layout? Keeping
in mind that the simple answer is always the best one, I found a
solution that keeps to that premise and solves an issue that seemed
impossible not long ago. In a word, the answer, lies in the loop.
An additional one, that is. But first, lets define and explain the
general look and functionality of our project.
The project I was working on for a client dealt with a photo database
that involved four related tables, the schema for which follows
in a dump from the popular open source mysql manager phpMyAdmin:
I've added a bit of extra comment to each table to give you an idea
what each table is designed to do.
Read
The Whole Article
Using
MySQL for Exchange Rate Updates
I am an American living in Germany, and I export German stamps to
English-speaking markets, mainly to the US, UK and Australia. Once
a quarter, I mail the new stamps to my customers with a statement
priced in their local currency. This means that I have to keep track
of the exchange rates for the Euro, US dollar, UK pound and Australian
dollar.
Many years ago, when I started my stamp business, I solved this
problem by listening to the radio every day at 6pm, when the daily
US dollar fix was issued. I wrote the exchange rate on some scrap
paper. It was a mess to keep all these little notes together. The
rates for the Australian dollar and the British pound I had to guess
when I made my quarterly price list. Today, by using the Internet,
MySQL, PHP, KMail, and SuSE 8.2 Linux, all the tracking and conversions
are done automatically.
Read
The Whole Article
WWW-SQL
Include Command Buffer Overflow Vulnerability
Ulf Härnhammar has reported a vulnerability in WWW-SQL, which can
be exploited by malicious, local users to gain escalated privileges.
The vulnerability is caused due to a boundary error within the functionality
for including files. This can be exploited to cause a stack-based
buffer overflow by constructing a malicious web page, which passes
an overly long path to the include command, and process it with
WWW-SQL.
Read
The Whole Article
| Convert
your keywords to sales! Try Urchin for free - Download
Now |
Microsoft
Hopes To Push SQL Sales With Value Adds
Microsoft’s latest strategy of offering SQL Server backup licenses
for free has heated up the market once again, making database heavyweights
Oracle and DB2 sit up and take notice.
Speaking to CXOtoday, Tarun Malik, product marketing manager, Microsoft
India, said, "We came up with this innovative idea, keeping in mind
the fact that data farms typically deploy a large number of servers
today. Customer's who have opted for our Software Assurance program,
can purchase a single license for the primary database server, and
use free copies of SQL for backup servers."
Read
The Whole Article
Soup
to Nuts: Tips for Linux, MySQL and more
I stumbled across a fantastic project at Sourceforge this morning
via rootprompt.org. Souptonuts is a repository of tips and techniques
covering numerous topics from the Linux kernel to MySQL and across
the programming and platform spectrum.
The MySQL tips were excellent and very useful for everyday maintenance
and troubleshooting. Extensive example scripts are included and
worth a browse.
Read
The Whole Article
Read this newsletter at:
http://www.sqlpronews.com/2004/0608.html |
|
 |
|
