THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Did You Know? It’s Anniversary Time Again

And it coincides with a new book of mine being published. So I decided I would give away some presents!

Today marks 27 years that I have been working with SQL Server. On this day in 1987 I started working for the Sybase Corporation in Berkeley, California, and SQL Server has consumed by working life, ever since….

I still have quite a few copies of my SQL Server 2012 Internals book, plus all the copies of the new In-Memory OLTP book, so I’ll be giving away a couple of each. (Many more of the In-Memory OLTP book will be given away at the PASS Summit next week.)

 

So what do you have to do?

1. Send an INSERT statement to this email address

2. Include "Happy Anniversary" in the subject line. The mail will be filed as junk if you don't.

3. The body of the email should consist of a single T-SQL INSERT statement (shown below).  For the last column, choose which book you’d prefer. 
    A 1 will indicate the SQL Server 2012 Internals book, and a 2 will indicate the In-Memory OLTP book.

4. Doublecheck the syntax! Make sure you have open and close quotes for all strings, and that the quotes are STRAIGHT quotes, as in the INSERT statement below. If you use Word to add a quote of your own or replace one that's there, it's usually a "smart" quote, which in this case is NOT smart. SQL Server will reject the INSERT if the quotes are not STRAIGHT. I suggest you use SSMS to write the insert.

5. Send the email before 23:59:59, October 30, US Pacific Time.

Here is the INSERT statement. Replace the strings with your specific information, and include it in your email:

INSERT INTO Raffle(emailAddress, firstName, lastName, country, city_region, choice)
               VALUES('Your email address', 'First Name', 'Last Name', 'Country', 'City, State or Region', [1|2] );

Due to postage costs, I’ll only choose one winner from outside the US. I’ll choose 3 from within the US.

Examples:

If my friend John wanted to enter, and wanted the In-Memory OLTP book, his INSERT might look like this:

INSERT INTO Raffle(emailAddress, firstName, lastName, country, city_region, choice)
               VALUES('john@emailserver.com', 'John', 'Cook', 'US', 'Houston, TX', 2 );

 

If my son-in-law in Germany wanted to enter, and he wanted the 2012 Internals book, his INSERT might look like this:

INSERT INTO Raffle(emailAddress, firstName, lastName, country, city_region, choice)
               VALUES('manu@emailserver.com', 'Manuel', 'Meyer', 'Germany', 'Weil der Stadt', 1 );

 

Thank you!

~Kalen

Published Monday, October 27, 2014 12:48 PM by Kalen Delaney

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Marlon Ribunal said:

Insert Statement sent!

October 27, 2014 6:34 PM
 

Bob said:

Hello,

Do you have any plans for releasing an ebook version of the In-Memory OLTP book?

October 28, 2014 3:20 AM
 

Francesco said:

Happy Anniversary @SQLQueen

October 28, 2014 10:22 AM
 

Richard Handloff said:

Fantastic! So glad you've spent so much time in the SQL Server world. It was one of your classes that really opened my eyes to how SQL worked under the hood. My working life hasn't been the same since!

October 28, 2014 10:49 AM
 

Kalen Delaney said:

Hi Bob! The ebook version would be controlled by the publisher, but in the past, almost all RedGate books have been released electronically. Sometimes it is several months after the paper version is available, however.

And thanks for the nice comments, Francesco and Richard!

~Kalen

October 28, 2014 1:23 PM
 

Israr Haq said:

  SET NOCOUNT ON

  PRINT 'Happy Anniversary'

October 28, 2014 2:58 PM
 

Chris Wilson said:

Kalen,

Happy Anniversary and thank you for all the wonderful work you do for the community!

October 29, 2014 1:53 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Favorite Non-technical Sites or Blogs

Privacy Statement