Maine – SQL Saturday #293

admin

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

admin

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…

Philadelphia – SQL Saturday #294

admin

I traveling to the city of brotherly love to present at SQL Saturday #294 in Malvern, PA. 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 7th 2014 at the Microsoft Building, 45 Liberty Blvd – Suite 210, Malvern, PA 19355. It only costs $10 if you want a lunch. Below are the details for my presentation. Topic: Effective Data Warehouse Storage Patterns Abstract: Many companies start off with a simple data…

Rhode Island – BI User Group – May 2014

admin

I am happy about the opportunity to present at the Rhode Island Business Intelligence User Group on May 12, 2014. I have not been to Bryant University since last year and it will be great to see what is new since I last visited. I look forward to seeing old friends and meeting new ones. I will presenting the following topic. Topic: A brief introduction to Power Tools. Abstract: In recent months, there has been a big push for self service business intelligence tools by Microsoft. The center of this…

Maine – SQL Server User Group – May 2014

admin

I am delighted about the opportunity to present at the Maine SQL Server User Group on May 7, 2014. This group meets at the Tyler Technologies facility in Yarmouth, ME. I have not been to Maine since a white water rafting trip on the Kennebec River with Crab Apple rafting company in July of 2012. Two times in the next month I will be visiting this northeastern most state. Do not forget to drop by the SQL Saturday #293 event in Portland ME on June 28th. I look forward to…

SharePoint Saturday – Boston 2014

admin

I had the pleasure to attend the SharePoint Saturday (SPS) conference on April 12th at the Microsoft Office in Cambridge, Boston MA. I am truly interested and passionate about MS SQL Server developer products (SSDT, SSIS, SSAS, SSRS); However, I do support SharePoint at my day job. This was a great opportunity to learn more about how to configure SQL Server for SharePoint. There were a handful of sessions on MS BI products deployed in a SharePoint environment. Here is a list of sessions that I attended and really liked.…

Boston – SQL Saturday #262

admin

I am really honored to have the opportunity to present at SQL Saturday #262 in Boston. It will be a good time to meet old friends and make new ones. Since, the schedule has not officially been posted, I can not name the headliners that I looking forward to hear presentations from. I will update the post later with this information. I hope you have time to attend this awesome free event on March 29th, 2014! It only costs $10 if you want a lunch. Topic: Effective use of temporary…

Power Query – Part 4

admin

There has been a big push for self service business intelligence tools by Microsoft in recent months. The center of this new universe is Microsoft Excel. I will carry on with talks about Power Query which is a self service ETL add-in for MS Excel. This tool was released in August of 2013. In addition to my blog, the online help is a good place to start learning about this tool. Last time, I demonstrated how the “reduce” section of ribbon has buttons that can refine the number of rows…

Power Query – Part 3

admin

There has been a big push for self service business intelligence tools by Microsoft in recent months. The center of this universe is Microsoft Excel. I will keep on going with talks about Power Query which is a self service ETL add-in for MS Excel. This tool was released in August of 2013. In addition to my blog, the online help is a good place to start learning about this tool. Last time, I demonstrated how the “get external data” and “excel data” ribbon buttons can be used to export…

Power Query – Part 2

admin

In recent months, there has been a big push for self service business intelligence tools by Microsoft. The center of this universe is Microsoft Excel which is a common application used by the data analyst. Today, I will continue talking about Power Query which is a self service ETL tool. This tool was released in August of 2013. In addition to my blog, the online help is a good place to start learning about this tool. Last time, I showed you how to find an online data source, extract the…