Stay in touch …

FreeDB2

Archives

Top 3 ways to return TOP 10 rows by an SQL query

Limiting 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. [...]

Read …

The Article every DBA should forward to SQL developers

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 [...]

Read …

Microsoft announce free Office 2010 … kinda

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. [...]

Read …

Microsoft SQL Server under attack

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 [...]

Read …

Microsoft SQL Server 2005 Express Edition SP3 out on Microsoft Update

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. [...]

Read …