Rhode Island BI User Group

I am delighted about the opportunity to present at the Rhode Island Business Intelligence User Group on March 20, 2013. I have not been to Bryant University in a long time. It will be great to see what is new since I last visited. I will be posting an updated version of the presentation with TSQL code before the end of the week. Topic: Effective Data Warehouse Storage Patterns Abstract: Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the…

North Haven – SQL Saturday #184

I am totally pumped up about having the opportunity to present at SQL Saturday #184 in North Haven. I will be posting an updated version of the presentation with TSQL code before the end of the weekend. I hope you have time to attend cool event on March 2nd, 2013! Topic: How to audit and prevent unwanted user actions Abstract: Typical corporations are composed of small departments located in different countries and time zones. Adding offshore resources and vendors to the mix make the coordination IT efforts more complicated. While…

Seattle – Pass Summit 2012

I just returned to New England after 4 days in Seattle at Pass Summit 2012. I analogize the conference to going out to eat every hour, some presentations I truly enjoyed; Others did not suit my pallet. Overall, I would rate the event as a total success. Here are some presentations I viewed in chronological order that were definite highlights during my trip.

  In summary, if you can get the chance to go to the Summit 2013 Conference in October at Charlotte NC, please do. You will not…

Nashua – SQL Saturday #146

I am totally pumped up about having the opportunity to present at SQL Saturday #146 in Nashua. I will be posting an updated version of the presentation with TSQL code before the end of the weekend. I hope you have time to attend cool event on October 20th, 2012! 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 query. TSQL provides the developer with several constructs that can store temporary result sets that are passed…

Providence – SQL Saturday #156

I am totally pumped up about having the opportunity to host a SQL Saturday #156 in Providence RI. I have been involved with the local PASS group, SNESSUG for almost four years and the current chapter president for one. I have definitely grown from the experince! I will be centering the keynote speach on the value of professional associations, a recent topic of Buck Woody at Simple Talk. With a product as big as SQL Server (TSQL, SSIS, SSAS, & SSRS), it is great to chat with others doing work…

New York City – SQL Saturday #158

I am totally pumped up about having the opportunity to present at SQL Saturday #158 in New York City. It should be a good time to network with other professionals in the field and learn some new things about the product. I will be posting an updated version of the presentation with TSQL code before the end of the week. I hope you have time to attend cool event on August 4th, 2012! Topic: Full Text Indexing Basics Abstract: Today’s large data fields (LDF) are full of unstructured information stored…