Follow me on TwitterLimiting amount of data returned by a database to an application is probably the easiest and the most effective way to improve performance your application. DB2 provides 3 ways of accomplishing this. You can use DB2 SQL FETCH FIRST n ROWS syntax. You can use SQL syntax of another DBMS like MySQL, Oracle or Sybase, or you can do this in a database independent way by using the capabilities provided by the database API you are using in your application code. [...]
|
|||||
|
|
I think that every Database Administrator needs to read the article “Opinion: No more excuses for SQL injection attacks” and send it out to every application developer they know. I hate SPAM as much as the next guy but I think it is justified in this case. I am dead serious. We, the database people of all walks of life (DB2, Oracle, SQL Server …), have been talking about the benefits of using parameters in the queries instead of literal values for years. The main message has been “performance”. Most DBMS will perform much better and will use [...] Cloud based version of Microsoft Office 2010 is supposed to be a free offering. Will Microsoft really set Office free or will it cripple it like it did with SQL Server Express to protect revenue. [...] Arbour Networks knows a thing or two about internet security as their gear is used by most top tier ISPs. They run an interesting internet threat analysis service at http://atlas.arbor.net/. I’ve been watching it for the past couple of weeks. During this time Microsoft SQL Server has consistently been the top attack target. Not only has SQL Server been a consistent target, it has been a target for over 50% of all attacks. SQL Server under attack Now, I don’t want to come across as bashing SQL Server. I am not one of those people who will claim [...] The nice part about Microsoft SQL Server Express is that unlike Oracle XE, you can count on getting updates. There hasn’t been an update to Oracle XE since, well never, and that is despite the fact that it has a gazillion security vulnerabilities that have been addressed in the paid versions of Oracle database. [...] |
|
|||
|
Copyright © 2010 FreeDB2.com - All Rights Reserved |
|||||
