Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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, 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: 11936 | Views in the last 30 days: 3
Related Articles

Apology for today's article

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


Apologies and Testing

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


High-Performance Transact-SQL with Window Functions

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


SQL Server's implementation of Window Functions

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


Good SQL Server article

Good SQL Server article


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones