18 May 2012

Microgen DBClarity Developer: Introductions

Got a minute or two to spare and still not quite sure where DBClarity Developer fits in? Watch the brief introduction video posted on our website: http://www.microgen.com/uk-en/products/microgen-dbclarity-developer.

11 May 2012

DBClarity Webinar - Reusing SQL Queries

In my last entry I said that I'd watched Tristan's webinar on reusing a SQL query to create insert and merge statements. I enjoyed the re-usability aspect, so quickly created a video to show the feature, not having the patience to wait for Tristan's webinar to be published! The full webinar is now available; we've edited out the noise in the Q&A section, so it's all good content.  There are few useful questions and answers on pricing and a snippet of news about the great feature coming in the next release.  You can find the video on YouTube:  http://www.youtube.com/watch?v=EbLEmZf79Hc.
If you missed these webinars, we're re-running the series to coincide with a SQL Server Relay, a 5-day event running in various cities and ending in London on the 30th May and we'll be there! Visit the Microgen/DBClarity website to register.

04 May 2012

Learn to Reuse your SQL Queries: Working with Subqueries and Merge

This week we ran a new webinar for DBClarity Developer, focusing on creating SQL queries, first by creating a query and then reusing that query - using DBClarity Developer  - to make things nice and easy.  I go back and forth on this"nice and easy" because I started life writing SQL at the command line, so visual, graphical queries are still relatively new to me.  As I watched the webinar this week, I felt that same twinge of excitement when I show anyone something new.  Over the years I have loved teaching and presenting neat features in products.  I have not been at a conference or event in over a year, but I couldn't wait to show you this piece of code  - hence this little video.  It's all easy stuff, and I'm sure you'll like the "reuse" aspect of the demo.

I'm stealing a bit of Tristan's thunder. He did the webinar and the demo and in the video below, I'm doing an exact rework of his demo.  In the webinar he also talks of the benefits of the product and mentions an exciting new feature in the next release, so you'll have to watch the webinar to get all that news!

If your SQL is a little rusty, perhaps it takes a little while to build up a query or if you're wanting to learn new SQL syntax, then take a look at this demo.

More Information