New York City – SQL Saturday #380

I am taking a road trip to the big apple to present at SQL Saturday #380 in New York City, NY. It will be a good time to meet old friends, make new ones and learn something new. I am really glad that my friend Denise decided to go on the road trip with me. It is really boring driving 175 miles twice on the same day by yourself! I will be talking in the afternoon on the following topic. Topic: Basic Database Design Abstract: You just found out that…

Rochester – SQL Saturday #383

Time to travel to the Flour City to present at SQL Saturday #383 in Rochester, NY. It will be a good time to meet old friends, make new ones and learn something new. I am really glad that my friend Matt decided to go on the road trip with me. It is really boring driving 350+ miles by yourself! I will be talking in both the morning and afternoon sessions on the following topics in order. Morning Topic: Azure SQL Database – Software As A Service Abstract: Are you tired…

Boston – SQL Saturday #364

A little road trip to bean town is planned this weekend. I am really honored to have the opportunity to present at SQL Saturday #364 in Boston. It will be a good time to meet old friends and make new ones. This year’s event has an all star line up of MVP’s who are talking at this free event on April 18th, 2015. If that is not enough excitement, the 119th Boston Marathon is gearing up for Monday’s race and the Red Sox are playing the Orioles until Monday. I…

Don’t pass over synonyms

I am finally back in the writing saddle again with a spree of tidbits for the month of April 2015. These articles will focus on learning a simple TSQL command or technique. Today, I want to talk about how synonyms can be used to preserve backward compatibility objects while allowing for schema redesign in existing databases. The CREATE SYNONYM and DROP SYNONYM key words were added to the TSQL language in the 2005 version. The main purpose of the construct is to provide a simple name to reference a database…

Boston – Code Camp #23

I am excited about the opportunity to present at Code Camp 23 in Boston. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on March 21st, 2015 at the Microsoft New England Research & Development (NERD) building, One Memorial Drive, Cambridge, MA. Below are the details for my presentation. Topic: Azure SQL Database – Software As A Service Abstract: Are you tired of installing, configuring and patching Microsoft SQL Server? Azure SQL database maybe…

Hartford – SQL Server User Group

    I am enthusiastic about presenting to the Hartford SQL Server User Group on February 10, 2015. The meeting venue has changed since the last time I visited to the following: Market Grille Restaurant www.marketgrillct.com 110 Buckland Hills Drive Manchester , CT 06032 Of course, I am looking forward to seeing my friends John Flannery and Dennis Perlot. However, I love to chat to local user groups about any SQL server topic that I am passionate about. Here is the details of the presentation that I will be covering…

Boston – Code Camp #22

I am thrilled about the opportunity to present at Code Camp 22 in Boston. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on November 22 nd, 2014 at the Microsoft New England Research & Development (NERD) building, One Memorial Drive, Cambridge, MA. Below are the details for my presentation. Topic: Effective use of temporary tables Abstract: Every developer eventually comes against business logic that can’t be handled with a single simple or complex…

Albany – SQL Saturday #302

I am hitting the highway to visit the Cradle of the Union. I am delighted to have the opportunity to present at SQL Saturday #302 in Albany, NY at the same time. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on July 26th, 2014! It only costs $10 if you want a lunch. Below are the details for my morning presentation. Topic: Basic Database Programming Abstract: You just found out that a client…

Maine – SQL Saturday #293

I am presenting at SQL Saturday #293 in Portland,ME. It will be a good time to meet old friends and make new ones. My friend Steve Simon will be making the road trip with me. I hope you have time to attend this awesome free event on June 28th 2014 at the USM Wishcamper Center, 34-44 Bedford Street, Portland, ME 04104. It only costs $10 if you want a lunch. Below are the details for my presentation. Topic: Basic Database Programming Abstract: You just found out that a client needs…

Boston – Code Camp #21

I am excited about the opportunity to present at Code Camp 21 in Boston. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on June 21 st 2014 at the Microsoft New England Research & Development (NERD) building, One Memorial Drive, Cambridge, MA. Below are the details for my presentation. Topic: Basic Database Programming Abstract: You just found out that a client needs a SQL database to be designed from scratch. However, you existing…