This week I attended a webinar by Cary Millsap, organized by Red Gate. It was called “Real Developers DO use Tools” and was focussed on, well, tools. At the end of Cary’s talk, James Murtagh showed a demo of their Schema Compare tool. The demo wasn’t flawless, but he recovered nicely 🙂 (note to self: don’t do live demo’s). And… Read more
A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ‘0999’) Have a think, and then check out the answer on nuijten.blogspot.com.
… Read more
The business rule states: Only one entry is allowed per ID and per day and the time should be recorded. The table involved (simplified for the blog post) Wouldn’t it be nice if it was possible to do it like this? This way you still have the complete date information (time is a component of the date column), and only… Read more
