Developing web applications, there are scenarios and patterns which repeat over and over, day after day, when working with the underlying data. One of these scenarios which I see very often is when there are two or more collections with one-to-many or many-to-many relationships which require filtering or joining on some type of key to ultimately perform a computation that requires the parent and the child in a hierarchy.
In recent years, one of the biggest and most timely movements in web development has been the push towards responsive web design (a.k.a. RWD). And with good reason. For those who are unfamiliar with this concept, it allows your website to be viewed on an almost infinite number of devices and screen sizes, all while allowing you to control the message, design, and user experience that you want to deliver to your customers.
Over the last few years there have been scenarios that as a developer I’ve come across many times and today I thought I’d share some SQL specific scripts that I find myself needing every once in a while and I always have to go hunting for them. This post will consolidate some of the more commonly useful ones that I think will be valuable to other developers as well.
The base Visual Studio installation gives you enough functionality to get by, but I find that the use of a few Extensions really helps VS 2012 shine. Some of my favorites include:
Using SVG’s in web design and development has taken off in the last year or so. For those who don’t know, SVG, or Scalable Vector Graphics, is an image format for vector graphics, much like an Illustrator or EPS file that can be scaled to any size without losing any clarity (as opposed to bitmap pixel based image formats like JPG, GIF, or PNG, which lose their clarity when scaled).
With 2013 behind us it is time to take a moment and look into the magic eight ball to see what the future in web has in store for us.
On November 30, 2013 I watched the Auburn game. Alabama had to win for it to be their game. The game ended on a spectacular 57-yard missed field goal attempt landing in the arms of Chris Davis of Auburn standing 9 yards deep in the end zone.
The lions-share of employees here at Mercury New Media are software developers, or are at heart anyway, and as such embrace our “inner geek” on a daily basis. We are all gamers of one type or another so the notion of game Achievements is second nature.
Think about the last time you met a friend’s family. Was it a welcoming hug or a pleasant handshake? How about a greeting shouted through the house? Were you even invited into the home?