This past Tuesday I had the privilege of attending the NJ SQL PASS Group meeting in Wayne, NJ. It's typically held at the Microsoft Store in the Willow brook Mall. In the back, they have a huge screen which lends itself nicely for presentations.
The OVER clause was first introduced to us in SQL 2005. It is often used as a supplement to other functions to provide which rows from a particular query are applied to a function. It is usually presented as part or in addition to an existing result set.
I had the pleasure of attending SQL Saturday #588, in NYC at the Microsoft Building in Times Square, this past weekend. For those that don’t know it’s an entire day of free SQL Server training with presentations from professionals at the top of the industry. Yes, I sai...
Hello all! Welcome to SQLEvo. The intent of this site is to provide an overview of what I do and how I can be useful to organizations. And the Blog portion is to provide meaningful contribution to the SQL Community that has given so much to me!