With so many SQL Saturdays and the PASS Summit on the agenda for October, I'm pretty booked up with speaking engagements this month. There are three separate presentations I'm doing this month – here are the abstracts.
Scalable Application Design with Service Broker
How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.
Maintain SQL Server Performance Baseline with PowerShell
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Automate Your ETL Infrastructure with SSIS and PowerShell
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
Now, here is the schedule for my presentations:
10/3/2015 Pittsburgh SQL Saturday
02:40PM Maintain SQL Server Performance Baseline with PowerShell
10/10/2015 Raleigh SQL Saturday
11:00AM Maintain SQL Server Performance Baseline with PowerShell
01:30PM Scalable Application Design with Service Broker
10/17/2015 Charlotte SQL Saturday
10:15AM Scalable Application Design with Service Broker
10/29/2015 10:45AM Automate Your ETL Infrastructure with SSIS and PowerShell
10/30/2015 08:00AM Scalable Application Design with Service Broker
I look forward to seeing you at one or more of these presentations!