(Sanjit Chakraborty) IBM Informix Innovator-C Edition is free to download and deploy, and provides a strong, reliable, easy-to-administer foundation for your database applications.
Other News
SQL SERVER – PAGELATCH_DT, PAGELATCH_EX, PAGELATCH_KP, PAGELATCH_SH, PAGELATCH_UP – Wait Type – Day 12 of 28
(Pinal Dave) This is another common wait type. However, I still frequently see people getting confused with PAGEIOLATCH_X and PAGELATCH_X wait types. Actually, there is a big difference between the two.
Characteristics of an Architectural DBA
Free Webcast: Using the MMC to Manage and Learn TSQL and Source Code Wednesday, March 8 Want to tune up your SQL Server Management skills. Our very own SQL Server MVP stephen Wynkoop is presenting a Free webcast next Wednesday, March 9th. Learn how to use MMC to generate code, interact with version control, and manage your servers. Click here […]
Characteristics of a Architectural DBA
Find Out What’s New at SSWUG SelecTViews Check out this week’s SelectTViews So much data, so many databases…to the moon! Cloud exit strategies, cloud security considerations, wireless access to data… Jeopardy!(tm) ….and the SSWUG Virtual Conference, Bus. Intelligence Upgrade hesitations and much more. $$SWYNK$$ Featured Article(s) Top Ten Database Blunders (Part 1 of 4) As a PTO (Performance, Tuning, and […]
XML and Voice-Web Applications – What is VXML
(Darla Ferrara) Voice-web applications are becoming more prevalent these days and XML is part of that game. From speech synthesis to automatic speech recognition programs, voice files are becoming big news in Internet design and they work with an XML format known as voiceXML. To understand how voice
3 Common Patterns in XML Processing
(Roger L. Costello) Most XML documents contain lists of elements. For example, this document contains a list of elements:
DynamicModuleUtility
(K. Scott Allen) One of the interesting side-effects of installing ASP.NET MVC 3 is the appearance of Microsoft.Web.Infrastructure in the GAC. Inside the assembly is a DynamicModuleUtility class that will let you do the following:
Secure Web Apps from SQL Injection in ASP.Net
In the first part of this two-part series, you learned how SQL injection works in ASP.NET 3.5 using a MS SQL database. You were also shown, with a real web application which was not secure against SQL injection attacks, how these attacks can be used by the hacker to delete sensitive information from
SQL Precedence UNION and MINUS, Converting to Full Outer Join Syntax
(Charles Hooper) In a recent OTN thread in the SQL forum I found a SQL statement (see the thread for the original SQL statement) that the original poster (OP) wanted to transform into full outer join syntax, but was unsure how to start the transformation.
Basics of Join Factorization
(Hong Su) We continue our series on optimizer transformations with a post that describes the Join Factorization transformation. The Join Factorization transformation was introduced in Oracle 11g Release 2 and applies to UNION ALL queries.