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…

Baltimore – SQL Saturday #615

I am traveling to the Crab Cake Capital to present at SQL Saturday #615 near Baltimore, MA. It will be a good time to meet old friends, make new ones and learn something new. I am really glad that my daughter decided to go on the road trip with me. It is really boring driving 400 miles by yourself! I hope you have time to attend this awesome free event on May 06, 2017 at Loyola University, 8890 McGaw Road, Columbia, Maryland.   Here are the details behind the presentation…

New England MS Developers – VS 2017 Launch

I want to thank the New England Microsoft Developers user group allowing me to talk about the data platform components of Visual Studio during this launch event. I truly enjoyed giving the talk to such a large group of users. Topic: Visual Studio 2017 – Data Tools Abstract: SQL Server Data Tools is a modern development tool that leverages the Visual Studio 2015 graphical interface.  One can use this tool to build SQL Server relational databases, craft Integration Services packages, design Analysis Services data models, and deploy Reporting Services reports.…