SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQLServerCentral apologizes and you can win a book

By Press Release,

SQLServerCentral is issuing a public apology to Itzik Ben-Gan.

We ran an article earlier this week that had plagiarized content from Itzik Ben-Gan's book on windowing functions. We removed the article once we were informed and verified this, but we felt the need to issue a public apology for the oversight. This article was written by Kamil Moscicki, who also has a video site with tutorials for sale on T-SQL subjects. We are not linking to the site, and we would warn anyone about purchasing content that is potentially plagiarized and is a violation of copyright law.

To show our support for Mr. Ben-Gan, we have decided to give away 10 copies of the book to a random set of community members. We are shipping the book from Amazon.com, so only those eligible for a paperback (or Kindle) version from the US or UK Amazon stores are eligible.

The rules of the contest are simple:

  1. Post a comment to this article discussion in the forums
  2. Write a T-SQL query that uses an OVER clause.

That's it. I'll give you a week to write some code and post it and I'll select 10 random posters next week and send out the books.

Once again, our apologies, and whether you win or not, an investment in this book would be good for your T-SQL career.

Microsoft SQL Server 2012 HIgh-Performance T-SQL Using Window Functions is another great book from Mr. Ben-Gan and we would encourage you to purchase a copy and read it if you have the need to use the window functions in your SQL Server application. The book takes a comprehensive look at the changes to T-SQL in SQL Server 2012 and gives you numerous examples and ideas for how you can incorporate this code into your own application.

Total article views: 11978 | Views in the last 30 days: 2
Related Articles

Apology for today's article

We'd like to apologize to Gavin Draper who was plagiarized in an article published today.


High-Performance Transact-SQL with Window Functions

Window functions are more intuitive and simpler in many cases than alternative SQL methods.


Apologies and Testing

First, apologies to the Database Daily readers. I'll include one in next week's issue as well, but ...


SQL Server's implementation of Window Functions

Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQ...


SQL Server Window Functions in Action

SQL Server Window Functions were introduced in SQL Server 2005 with a basic set of operators and mas...