January 2011
25 posts
PL/SQL Best Practices →
As the discipline of software development evolves, software products grow in size and the code grows in complexity, the need for a set of guidelines and standards becomes increasingly evident. In this article I will enumerate some of the industry best practices that the experts have proposed and emphasized, in the context of PL/SQL programming.
Comparison of different SQL implementations →
The following tables compare how different DBMS products handle various SQL (and related) features. If possible, the tables also state how the implementations should do things, according to the SQL standard.
Triggers and Stored Procedures →
This chapter describes the differences between Microsoft SQL Server or Sybase Adaptive Server and Oracle
What is wrong with Cursors? →
SQL Server developers consider Cursors a bad practise , except under some circumstances. They believe that Cursors do not use the SQL engine optimally since it is a procedural construct and defeats the Set based concept of RDBMS. However, Oracle developers do not seem to recommend against Cursors. Oracle’s DML statements themselves are implicit cursors. Why this difference in approach ?...
HUGE: You'll FINALLY Be Able To Use Your iPhone 5... →
Apple is planning to add near-field communications (NFC) chips to its next generation iPhone and iPad, allowing you to use them to pay for stuff just by waving your device in front of a receptor
How to select the first/least/max row per group in... →
Here are some common SQL problems, all of which have related solutions: how do I find the most recent log entry for each program?
How Facebook Ships Code →
I’m fascinated by the way Facebook operates. It’s a very unique environment, not easily replicated (nor would their system work for all companies, even if they tried). These are notes gathered from talking with many friends at Facebook about how the company develops and releases software.
Implementing Google's "Did you mean" Feature In... →
Search engine users often misspell search terms for a variety of reasons varying from keyboard problems (a key not working), to unfamiliar international names (for example Sigmund Freud), changing one letter accidentally (Sinpsons), or adding one more letter (Frusciaante). Google’s search engine includes a feature now familiar to many web users - “Did you mean” - which provides...
Fundamental Attribution Error:... →
For example, if Alice saw Bob trip over a rock and fall, Alice might consider Bob to be clumsy or careless (dispositional). If Alice later tripped over the same rock herself, she would be more likely to blame the placement of the rock (situational).
“The concept of a big bang data migration is a simple one. Build the migration...”
– The data migration go-live strategy - what is it and why does it matter?
Event based Decoupling in PL/SQL – your first... →
What is extremely fancy and powerful – and not nearly used enough – is the architectural pattern that AQ allows us to introduce. Queues are a key concept for achieving decoupling. Decoupling itself is like the holy grail of architects – because it allows agility and reuse. Through a Queue, a publisher (or discoverer) of events can make them available to consumers that may or may not exist and that...
Design Patterns in PL/SQL – Implementing the... →
Next in my series on Design Patterns and their implementation in PL/SQL – also see previous articles on Dependency Injection of Values, Dependency Injection of Interfaces and the Template Pattern – is a discussion of the Observer Pattern. We will see a fairly elegant implementation of this pattern that provides for a very loosely (runtime) coupled architecture where packages can advise procedures...
Spotify imponerar utomlands →
Efter Stieg Larsson, Robyn och den starka svenska ekonomin — lägg till Spotify på listan över vad som imponerar utomlands.
How to Design a Good API and Why it Matters →
Should I work for Free? →
Using EXEC - Dynamic Search Conditions in T-SQL →
As I’ve already mentioned, EXEC() is an inferior solution to sp_executesql and the CLR. The reason for this is that since EXEC() does not take parameters, you have to build a query string with parameter values interpolated. This precludes query plans from being reused. It also makes the programming more difficult. Nevertheless, there are three situations where you need to use EXEC() or at...
Things Real People Don't Say About Advertising →
Beslutsstöd snart i var mans ficka →
Trenden går mot att operativt beslutsstöd, avsett att användas i den dagliga verksamheten, allt oftare används i mobilerna. Några exempel är löpande säljstöd, logistikinformation och analyser för att följa upp snabbt föränderliga nyckeltal.
Antivirusföretag + Facebookgrupper= exempel på... →
Jag följer vad Antivirusföretagen gör på Facebook och det finns ett företag som sticker ut, AVG. Deras Facebookgrupp har nästan 200000 medlemmar och vi kan lära oss en hel del om hur man gör för att lyckaspå Facebook genom att studera hur AVG gör.
Facebook - Introducing Deals →
We launched Places to let you share where you are with your friends and see who’s nearby. Now with Deals, you also can see what offers are nearby and share those deals with your friends.
Facebook Deals →
Facebook Deals, som ännu inte släppts i Sverige, är en naturlig påbyggnad av Facebook Places och ger företagare och marknadsförare chansen att bygga lojalitet och relation till sina kunder genom att skapa belöningar och erbjudanden direkt på sin Facebook-sida.
12 of the Year's Best Ideas in Interface Design →
Above, we’ve collected some of the year’s cleverest, clearest, and most creative UIs. Enjoy!
Designing INSTEAD OF Triggers →
The primary advantage of INSTEAD OF triggers is that they enable views that would not be updatable to support updates.
Få saker gjorda med GTD-metoden →
Går du ständigt runt med ett gnagande samvete och tänker på allt du borde ha fixat? Med GTD får du inte bara struktur på jobbet, utan på hela livet.