Stay in touch …

FreeDB2

Archives

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 less server resources [...]

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.

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 that Microsoft code is [...]

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.

Where did my Data Studio go?

So, you downloaded the free DB2 Express-C and you have started to play around with it. Maybe you created sample database and started to explore it using DB2 Control Center. If you are a developer, you may find that DB2 Control Center does not quite fit what you think of a a development tool. It is more in tune with what a DBA might want to do. So, you may have taken our advice and downloaded the new IBM Data Studio. After all, it is free so why not! If you have not done this already, go get it from the [...]

Read …