As long as Web applications are used to provide access to data, SQL Injection will continue to be a threat. SQL Injection is typically used to accomplish one of four objectives: bypass authentication, glean information, inject new or alter existing data, perform a denial of service attack, or gain a
Other News
SQL Server 2005 CLR Integration Part 2: Working with Data
(Shawn Wildermuth) In the first part of this article, we discussed how the CLR integration works in SQL Server 2005. This included writing stored procedures, but we could not do anything interesting in those first examples because we had no access to the data inside the database. In this second a
FIX: A query that involves data that is the numeric data type may return incorrect results in SQL Server 2000 SP3 and in earlier SQL Server 2000 service packs
In Microsoft SQL Server 2000 Service Pack 3 (SP3) and in earlier SQL Server 2000 service packs, a query that involves data that is the numeric data type may return incorrect results when the following conditions are true: • You compare numeric columns or numeric constants that are of different p
Cryptography and .NET Framework – Part 2 (Secret key Encryption)
(Bipin Joshi) In the Part 1 we learnt the basics of Cryptography and related .NET Framework classes. In this article we are going to see how to work with Secret Key Encryption using Triple-DES algorithm.
Unhandled Exceptions and Tracing in the .NET Framework 2.0
(John Robbins) By now, you’ve certainly heard about the big changes coming in Visual Studio 2005, but when it’s time to move your code over it will be the small things that trip you up. In this column, I want to cover two of the many excellent changes that you could easily overlook as you make the m
A Test Drive of the MySQL Migration Suite
(Gregory L. Magnusson) The MySQL Migration Suite facilitates the movement of data from a proprietary database application. This MySQL product suite consists of three tools: MySQL Migration Toolkit, a package capable of reverse engineering Microsoft Access, Microsoft SQL Server, and Oracle data t
DB2 Basics: An introduction to structured data types and typed tables
(Roman Melnyk) A structured data type is a user-defined data type with elements that are not atomic; rather, they are divisible and can be used either separately or as a single unit, as appropriate. This article introduces you to the concept of structured data types and shows you, by way of working
Security Overview (Sample Chapter)
(Anthony Velte and Toby Velte) When we talk about “security” we know what we want, but describing it and making it happen can be different matters altogether. Network security has a natural conflict with network connectivity. The more an autonomous system opens itself up, the more risk it takes
Say What? Part 4
(Roger Miller) Bonnie Baker is taking some time off from her writing duties, which gives me the opportunity to expand on the BIND saga she covered in her “Say What?” series of columns. These three valuable columns appeared in Q4 2003, Q1 2004, and Q2 2004 issues of DB2 Magazine and are still availab
PHP Tutorial – Databases in PHP – MySQL in PHP – Picking a DB
(Vince Barnes) We’re in the process of adding access to a MySQL Database to our HTML page and now we need to pick out the database we want to use and make sure that everything is properly available.