(Ilan Hazan) I have been asked if there is a way to insert data into two MySQL tables that connected by a foreign key in one MySQL query.
Other News
Quickly deploying Private Clouds for Database workloads
(Rav Ahuja) While the IT industry at large is flocking towards cloud computing (as is evident from triple digit growth in cloud usage) it is a rarity (at least so far) to see Enterprise IT departments touting cloud usage for workloads such as databases. And there are good reasons for it.
Getting to Know SVG
(Darla Ferrara) Scalable vector graphics (SVG) offers a way to draw your own shapes using an XML markup language. SVG works within a vector environment. This means, it uses geometrical primitives to create an image.
Tracking the moving history of averages and other aggregates – Flashback Aggregates in Oracle SQL
(Lucas Jellema) You may have seen we write on Flashback functionality in the Oracle Database. It’s an area that I like – especially since the introduction of the Flashback Data Archive in Oracle 11g. As an application developer, I typically focus on Flashback Query (AS OF) and Flashback Versions que
What’s New in ASP.Net MVC 3 Controllers: Part 2
(Sanket Terdal) The primary goal of the Model-View-Controller (MVC) pattern is to separate as neatly as possible the code that generates the graphical interface displayed to users from the code that manages any user actions.
Configuring Server Startup Parameters in SQL Server Denali
(Ashish Kumar Mehta) While looking through new features and improvements in SQL Server Denali, an improvement I came across was how to configure SQL Server startup options. This is a very useful change which Microsoft has made, thereby making it easier for database administrators to change startup o
No More Injection
No More Injection Really! It’s time to move on to other topics. So today I want to close out on our discussion of application injection with some final reader’s comments. Next time we will be moving on to another topic of interest. One thing I would encourage you to look into if you haven’t heard the term before is Blind […]
Visual Studio 2010 Visual Experience
Visual Studio 2010 Visual Experience Visual Studio 2010 was the first version of Microsoft’s integrated development environment to use Windows Presentation Foundation for its graphical rendering. This allows richer graphics and animations with hardware acceleration but can cause problems.
Punctuation in XPath, part 4: predicates (‘[…]’)
(Evan Lenz) We’ve already seen some examples of predicates, using square brackets ("[…]"), in action. In this article, we’ll look at exactly how they work, using the following sample document:
Directory Sync Tools: Move over little dog, a new DiffDog is moving in
(DaveMcG) Altova DiffDog was originally launched in 2005 as a diff/merge tool with XML-aware functionality to help users identify differences between XML files.