Archives for Month: November 2008 ::
XP, Vista, Win 7: The brewing of a perfect storm
Posted on :: Nov 17
Whenever Microsoft releases a new version of Windows, there’s always some period of uncertainty when customers face the choice of moving to the current release or waiting for the new product. This year, however, that transition period is especially uneasy.
Windows 7 is — by all accounts (except from the Microsoft honchos) — due out later this year and is looking faster, smaller and more stable than any Windows release out there. Windows Vista is here, but not a user favorite (to put it mildly). And eight-year-old Windows XP is still the dominant version of Windows out there.
MySQL Database Backup .MYI and .MYD
Posted on :: Nov 17
This article is about how to restore a backup to MySQL from a .MYI and .MYD file that you may have. Our dedicated host backs up only these files and does not use the mysqldump utility to create a full SQL backup of our database. This is fine, but makes a bit extra work. So let us get started.
Determine Your Version
First we need to determine the version of your server's MySQL database. Mine was 3.23, old I know. I do not know if you can mix and match .MYD files so I just downloaded that and installed it on my local computer. I would suggest doing the same, this way you are messing with copies of the actual database instead of the real thing.SQL Server 2008 RC0 Express on Vista
Posted on :: Nov 17
I wanted to get Express installed on my machine and so I downloaded the RC0 (of Express with Advanced Services) and ran it.
BTW there is is this Akamai download manager behind all of the RC0 downloads which you have to allow to run to get the download to start. If all is well you should have this download client running (and let me know if this is giving you grief):
SQL Server 2005 on Windows Vista
Posted on :: Nov 17
I've seen this issue pop up a few times so I thought I'd share a few quick tips / tricks to getting SQL Server 2005 to work on Vista.
If you see an error saying "Microsoft Internet Information Services (IIS) is either not installed or is disabled.", but you're sure you did in fact install IIS7, you are not alone. There are several required IIS components for SQL Server to install properly on Vista and if you don't have the complete set you will see this error.
Preventing SQL Injection
Posted on :: Nov 17
Most web applications interact with a database, and the data stored therein frequently originates from remote sources. Thus, when creating an SQL statement, you often use input in its construction. A typical SQL injection attack exploits this scenario by attempting to send fragments of valid SQL queries as unexpected values of GET and POST data. This is why an SQL injection vulnerability is often the fault of poor filtering and escaping, and this fact cannot be stressed enough.
I'm going to explains SQL injection by looking at a few example attacks and then introducing some simple and effective safeguards. By applying best practices, you can practically eliminate SQL injection from your list of security concerns.
Preventing SQL Injection in PHP & Coldfusion
10 reasons why SQL Server 2008 could rock
Posted on :: Nov 6
Just like its predecessor, SQL Server 2008 is taking its sweet time to actually ship. However, unlike its predecessor, it won't just be a "worthwhile upgrade". It will kick ass. I've already downloaded the SQL SErver 2008 RC0, and it will indeed kicked ass.
Here are the top 10 reasons why.
MySQL or SQL Server?
Posted on :: Nov 6
Look beyond politics and hype when deciding which to use.
Takeaway: MySQL may be free, but what if money isn't the only determining factor? Find out how these two database heavyweights stack up against each other and how to decide which one to use as your database system.
Two of the most popular back-end data stores Web developers work with today are MySQL and SQL Server. They are fundamentally similar in that both are data storage and retrieval systems. You can use SQL to retrieve data with either because both claim support for ANSI-SQL. Both database systems support primary keys and key indices, so you can also create indices used simply to speed up queries and for constraining input. Further, both provide some form of XML support.
Aside from the obvious difference of price, what distinguishes these two products from each other, and how do you choose between them? Let's take a look at the core differences between these two products, including licensing costs, performance, and security.MySQL :: The Myths of MySQL
Posted on :: Nov 6
I have heard many a shop discuss the old argument of SQL Server or MySQL, and generally the System Admin somewhere always sqashes MySQL as it has always appeared to me that they don't fully understand the capabilities of MySQL versus SQL Server. This is genrally because of outdated information on the Internet, and with the end result often being that antiquated views and opinions are quoted or otherwise recycled without the end users of such information ever knowing that the data either no longer applies or perhaps was never correct to begin with.