(Henrik Ingo) There has been an increase in the discussion about MySQL replication and how to make it happen faster. I don’t think Marco Tusa’s blog is on Planet MySQL, so let’s highlight it first: A dream on MySQL parallel replication. This is a good account of what it looks like out in the field o
Other News
Examples for creating Oracle functions
(Mika Wendelius) After contributing few articles on Microsoft SQL Server, I thought it would be a good time to do something Oracle specific. This first Oracle article of mine describes some basic tasks but extends to more advanced features.
SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)
(Pinal Dave) This blog post is written in response to the T-SQL Tuesday hosted by Jes Schultz Borland. Earlier today, I was presenting a 45-minute session at the Community College about “The Beginning SQL Server Database”.
Scheduled Processing in Windows
DBTechCon – Spring 2011 You’ve been hearing about this virtual conference for months now. Did you know it’s not just about SQL Server, or databases for that matter? The presenters for this conference are top-notch in their fields covering databases, testing, methodologies, Web Presentation and more. You won’t find a better value for your time or money. Registration to the […]
Highly Declarative Designs
(Roger L. Costello) Issue: What are the characteristics of a highly declarative design?
How to Create a Polygon in SVG
(Darla Ferrara) It sounds remarkably flashy to create a polygon in SVG, but what exactly is a polygon? A polygon is any closed shape that has at least three sides. Put simply, this can be a triangle, a square or something a little odder, such as a five-sided polygon. Once you start adding points to
Semantic Image Search: Next Up For a Major Search Engine?
(Jennifer Zaino) We’ve seen the big three players in the search engine space honing their semantic edge, and we may soon see one of them deploying semantic technology to sharpen image searches, too. nachofoto says it is in discussions with one of the giants (which it declines to name for now) that c
Oracle PL/SQL Subprogram Conditionals and Variables
(W. Jason Gilmore and Bob Bryla) Stored procedures can both accept input parameters and return parameters back to the caller. However, for each parameter, you need to declare the name and the datatype and whether it will be used to pass information into the procedure, pass information back out of th
Handling Errors with ASP.NET MVC
(Steven Smith) Nobody likes to talk about it, but sometimes your web application is going to fail. When it does, you want to make sure your users still get the best possible experience, and ideally that you as the developer get what you need to fix the problem. In this article, you’ll learn how to
Choosing an appropriate benchmark length
(Baron Schwartz) The duration of a benchmark is an important factor that helps determine how meaningful it is. Most systems have some “burstable capacity,” and this can influence the results a lot.