February 2011 - Posts

• Script to create or drop all primary keys now on TechNet Wiki.

  I posted my script to create or drop all primary keys on the TechNet Wiki. You can find it at http://social.technet.microsoft.com/wiki/contents/articles/script-to-create-or-drop-all-primary-keys.aspx . I first published the script here in 2009 and I've Read More... Posted Monday, February 28, 2011 2:03 AM by John Paul Cook | 0 Comments

• New free SQL Azure offer

  Microsoft has a new and better way to get a free Azure account for a month. All you need to do to sign up is provide your Windows Live Id and register at http://bit.ly/CRAzurePass using promotional code DPCE01 . This is a great way to learn about SQL Read More... Posted Monday, February 28, 2011 1:11 AM by John Paul Cook | 1 Comments

• Working with legacy data

  We encounter legacy data as a part of life. Colleges and universities have transcript records dating back decades or even centuries. Real estate property records in the United States go as far back as Spanish and British land grants in the 1500s. Very Read More... Posted Saturday, February 12, 2011 4:55 PM by John Paul Cook | 1 Comments