PROVIDENCE – SQL SATURDAY #694

I am traveling to the North Smithfield to present at SQL Saturday #588 at Bryant University. It will be a good time to meet old friends, make new ones and learn something new. I hope you have time to attend this awesome free event on December 9, 2017. Here are the details behind the two presentations that I gave that day.   First Presentation 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…

Hartford User Group – December 2017

I am enthusiastic about presenting to the Hartford SQL Server User Group on December 4, 2017. Of course, I am looking forward to talking to my friends Todd Chittenden and John Flannery. If you have not figured it out yet, I love to chat to local user groups about any SQL server topic that I am passionate about. The meeting venue is at the following address. Due to the holidays, I will be presenting remotely to fit this talk into my busy schedule. Blum Shaprio 29 South Main Street, Please…

Boston – Code Camp #28 – November 2017

I am excited about the opportunity to present at Code Camp 28 in the surrounding Boston area. 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 18, 2017 at the Microsoft Office, Five Wayside Road, Burlington, MA.   Here are the details behind the first presentation that I gave that day. Topic: Power BI Desktop Designer Abstract: The Power BI Desktop Designer has been adopted as a free reporting tool for many…

Rhode Island – SSUG – November 2017

I am driving thru America’s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on November 1, 2017. Check out the meetup for more details. I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn. Topic: Controlling Chaos with the Resource Governor Abstract: Every database administrator has come across a rogue user that executes unbounded reporting queries against the OLTP database during critical business hours. This issue might show up…

Web Cast – MS SQL TIPS – October 2017

Topic: Common SQL Server development mistakes and how to avoid them. Abstract: There are several ways to write code for SQL Server to accomplish a task, but are you always following best practices and producing the best code possible? In this webcast we will look at ways to improve your SQL Server code and some approaches that can make a big difference in overall performance and maintainability. Some of the things we will look at include: use of cursors, missing indexes, use of temporary tables and a lot more. Join…

Burlington – New England SSUG – September 2017

I want to thank the organizers of the New England SQL Server User Group for asking me to present on this fine night in September. Topic: Running SQL Server on Linux Abstract: SQL Server running on Linux is one of the biggest changes to happen in some time at Microsoft.  The release of the 2017 version of the database engine is about to happen.  As a database administrator, are you ready to support this version of the database in your environment? This talk will focus on key concepts such as…

Albany – SQL Saturday #622

Time to travel to the Cradle of the Union to present at SQL Saturday #622 in Albany, 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!   Here are the details behind the presentation that I gave that day. Topic: Public Preview of SQL on Linux Abstract: There was a lot of excitement at the…

Rhode Island – SSUG – July 2017

I am driving thru America’s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on July 12, 2017. Check out the meetup for more details. I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn. Topic: Investigating Plans with the Query Store Abstract: In the past, you had to execute custom scripts to gather information from either dynamic management views or extended events to tune badly behaving queries. One major…

Rhode Island – SSUG – June 2017

I am driving thru America’s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on June 7, 2017. Check out the meetup for more details. I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn. Here is the gritty details of the 30 minute presentation that I will be covering that night. Topic: Efficient File Management For Performance Abstract: Many accidental database administrators do not know that optimizing file performance…

New York City – SQL Saturday #588

I am traveling to the Big Apple to present at SQL Saturday #588 in New York City. It will be a good time to meet old friends, make new ones and learn something new. I hope you have time to attend this awesome free event on May 20, 2017 at Microsoft Office, 11 Times Square, New York City.   Here are the details behind the presentation that I gave that day. Topic: Public Preview of SQL on Linux Abstract: There was a lot of excitement at the Connect() developer conference…