This coming April 16 - 20, the Spring 2016 SQL Intersection conference will be held at the Walt Disney World Swan hotel, and I'll be presenting two sessions this year.
Get Near Realtime ETL with Service Broker
Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this simple and painless. This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
This session is fun in that I walk you through the process of transforming OLTP data into a Kimball-style data warehouse using Service Broker to send the modified data to stored procedures that do the ETL, and the updates happen almost as soon as the source changes are made. Perfect for those environments where you don't want to do reporting from your transactional database, but need up-to-the-minute information.
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.
In this session I'll walk you through a couple of different ways to collect performance counters, both Windows and SQL Server counters, and through a script I've written to gather those and store them in a SQL Server database. I then show you the reports I've written to get the real value out of the performance data.
This conference is a good one, and you can bring the family and send them off to the Magic Kingdom while you learn great things about SQL Server and all the IT technology covered at Dev Intersection. You can even save $50 on the conference by using the discount code WHITE (yeah, it's my last name.)
I hope to see you in Orlando in April!