Yup, it’s that time again. Time for you to get your SQL shoes on and head on out to CBusPASS, your Columbus source for SQL Server related information. Apart from MSDN… and the library… and the internet.
When: Thursday, May 14th, 6:30PM – 8:30PM
Where: Battelle For Kids, Suite 500, 1160 Dublin Rd, Columbus, OH 43215
IMPORTANT NOTE: Battelle For Kids has moved to Suite 500, which is on the opposite end of the building from where it used to be.
Food and drinks will be provided.
If you have problems locating the venue, you can hit me up on twitter or via telephone/text at 614.515.0727
Using Cloud-Based BI to Interpret Perfmon & Profiler Results
After learning how to use Perfmon and Profiler to gather performance statistics about your SQL Server, it still takes a lot of time to interpret those results and figure out what’s going on. Microsoft’s SQL Server Data Mining team has built a free cloud-based data mining tool for Excel that can help slice and dice mountains of data and help you make sense of it all.
Even if you’re not ready for BI in the cloud, you can use this same type of tool in combination with a local SQL Server Analysis Services instance. Wait! Don’t freak out – it’s much easier than you think, and you never have to leave the comforting environment of Excel. Even if this doesn’t sound like fun to you, you might want to learn about it because mid-level managers in your company might want to use this technique to analyze sales or customer data.
Attendees will learn how to install & configure data mining in Excel, how to analyze Perfmon data to break the server’s load into categories, and how to use BI to write a performance report about your SQL Server.
Brent Ozar
Brent is a SQL Server Domain Expert with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor.
Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He’s currently writing SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, Justin Langford and Cindy Gross. He’s Editor-in-Chief at SQLServerPedia.com, where he also records video podcasts.
If you can’t attend in person, you can join us using LiveMeeting:
Audio Information – Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
1. Copy this address and paste it into your web browser:
https://www.livemeeting.com/cc/usergroups/join
2. Copy and paste the required information:
Meeting ID: NM86HK
Entry Code: 5\-b6|jkH
Location: https://www.livemeeting.com/cc/usergroups
