Here is another SQL puzzle, based on an old idea. I must confess that my investigations into ‘Fireside Fun’, are motivated by an urge to explore ways of whiling away the time during boring meetings and seminars. It is, I fear, considered rude to plug in the noise-cancelling headphones, lean back in your seat with your eyes … Read more
You will be surprised to learn that, in the nineteenth century, they got on perfectly well without television or computer games. Actually, in the evenings they were accustomed to organise all sorts of entertainments we have since forgotten about, all of which required the art of human interaction. After their evening meal in any affluent household, … Read more
To celebrate the seventh anniversary of Robyn Page's classic workbench, Phil brings it right up to date. What starts as a gentle introduction to the use of dates in SQL Server ends up with some unusual tricks in creating calendars and calculating Mardi Gras. … Read more
Query notification allows your applications to take advantage of caching, safe in the knowledge that the cache will be refreshed whenever any critical data in the underlying database is updated. Find out how it all works...… Read more
How do you keep your skills current? How will you prepare yourself for what you will be doing 5 years from now? In this article, part III of the series, I discuss books and the role they can play in keeping the developer up to date.… Read more
In my last blog entry, ‘Eggy Peggy’, I gave an example of how one might replace into text from an entire table in one SQL command. As well as producing Eggy Peggy language, the technique has a variety of real uses. Just the other day, I had to use the technique for converting a whole … Read more
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.