(Melonfire) Transactional support has long been on the wish list of most MySQL developers and, with the release of MySQL 4.0, this wish was finally granted. Not long after MySQL 4.0, PHP 5.x was released with a new MySQL extension, MySQL Improved, which allowed PHP developers to access these new tra
Author: SSWUG Research
Formatting Expressions in Reporting Services
(Wayne Snyder) A user-defined format expression for numbers can have from one to three sections separated by semicolons. If the style argument of the Format function contains one of the Predefined Numeric Formats, only one section is allowed.
BUG: You receive an error message when you run the ‘Log Shipping Alert Job – Restore’ job in SQL Server 2000
When the “Log Shipping Alert Job – Restore” job runs in Microsoft SQL Server 2000, you may receive an error message that resembles the following: Msg 14421, Sev 16: The log shipping destination SecondaryServerName is out of sync by NumberOfMinutes minutes
Drilling Info about Asp.Net Worker Process
(Abey George) ProcessModelInfo class can be used to get the information about ASP.NET engine. This class contains two static methods: GetCurrentProcessInfo() and GetHistory(n). The GetCurrentProcessInfo() returns an instance of the ProcessInfo class, which contains information about the ASP.NET proc
New Authority role in DB2 9 – SECADM
(Chris Eaton) Another new feature of DB2 9 (formerly known as viper) is a new security administrator’s authority. Called SECADM, this new authority pulls together a set of security related privileges. These privileges are not even available to the SYSADM or DBADM users.
Fetching the Last Entered Records in Oracle
(MS Sridhar) There are times that you may need to fetch the last couple of records that you’ve inserted. The exact number can vary. Oracle provides an easy way of retrieving these records.
XML interview questions
This article lists commons xml interview questions with answers.
Simple Optimization for PHP and MySQL
Here is a list of a few very simple tips for optimizing your php/mysql applications. Keep these in mind while developing.
Injection-Safe Inline SQL with LIKE in the WHERE Clause
(Brett Burch) This is something that might be obvious, but I thought I would mention this because it wasn’t obvious to me. As I have mentioned earlier, I prefer stored procedures, but recently found myself in a scenario where I had to use inline SQL. I will avoid the “why” discussion and get to the
Ideas for Improving ASP and ASP.NET Web Application Security – Part 2
(Brett Burridge) Building an error reporting facility into your web applications can be beneficial when improving site security. It also has the added benefit of being able to notify the web developer as soon as bugs arise, enabling problems to be fixed and the web application made more robust. If