Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.
Creating HTML reports with PowerShell – June 17, 2013
Date: Tuesday, June 11, 2013
Time: 10:00 am – 11:00 am (Mountain Time)
Creating HTML reports with PowerShell
Speaker: Jeff Hicks, PowerShell MVP, author and trainer JDH IT Solutions
Summary: Creating HTML reports on one hand is almost brain-dead easy in PowerShell. But using it with style takes a little more work. Wouldn’t you like to add a little pizzazz to your HTML reports that you create in PowerShell. In this session I’ll offer some tips and tricks for creating great looking, or at least better looking, HTML reports including stylized alternate rows and embedded graphics.
About Jeff: Jeffery Hicks is a Microsoft MVP in Windows PowerShell, Microsoft Certified Trainer and an IT veteran with over 20 years of experience, much of it spent as an IT consultant specializing in Microsoft server technologies with an emphasis in automation and efficiency. He works today as an independent author, trainer and consultant. Jeff writes the popular Prof. PowerShell column for MPCMag.com, is a regular contributor to the Petri IT Knowledgebase, 4SysOps and the Altaro Hyper-V blog, as well as frequent speaker at technology conferences and user groups. If he isn’t writing, Jeff is most likely recording training videos for companies like TrainSignal or hanging out in the forums at PowerShell.org. Jeff’s latest books are Learn PowerShell 3 in a Month of Lunches, Learn PowerShell Toolmaking in a Month of Lunches and PowerShell in Depth: An Administrators Guide. You can keep up with Jeff at his blog http://jdhitsolutions.com/blog , on Twitter at @jeffhicks and on Google Plus (http:/gplus.to/JeffHicks)
BAVC Virtual Chapter Meeting – “Introduction to Mahout for HDInsight”
Professional Development – Online Event
Date: Wednesday, June 12, 2013
Time: 9:00 am – 10:00 am (Mountain Time)
Speakers: Christopher Price, Senior BI Consultant Pragmatic Works
Summary: In this session, we will introduce a Mahout, a machine learning library that has multiple algorithms implemented on top of Hadoop and HDInsight. We will start by introducing the foundational concepts needed to understand clustering, classification and collaborative filtering before demonstrating what it takes to get started with Mahout. In addition to learning how you get Mahout set-up, you will learn what it takes to process and prepare data, how to execute an embarrassing parallel batch recommendation job and subsequently how to integrate the result back into your existing ecosystem.
About Christopher: Christopher Price is a senior business intelligence consultant with Pragmatic Works, based in Tampa, FL. He has a bachelor’s degree in MIS and an MBA, both from the University of South Florida, and previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and data integration, data quality and MDM, SSAS, SharePoint, and Big Data. Chris regularly speaks at SQLSaturday, Code Camp, and other community events. He has authored multiple whitepapers and books and served as technical editor for others.
The BI Guy’s Little Guide to Big Data
PASS Big Data Virtual Chapter – Online Event
Date: Tuesday, July 23, 2013
Time: 1:00 pm – 2:00 pm (Mountain Time)
Overview: You know Pig is more than a farm animal and that Hive is not some ultra-hip bar. You’ve beyond the buzz words and the word count demos. Now¦you’re ready to figure out how it all fits in. In this session we will review common integration scenarios, proven patterns and best practices for integration Big Data solutions into your existing data warehouse and BI architecture. Learn how you too can ride the Big Data wave without reinventing the wheel to both enhance the information you currently deliver while solving problems that were previously unapproachable.
Speaker: Christopher Price
About Chris: Chris Price is a Sr. BI Consultant with Pragmatic Works based out of Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He began his career as a developer working his way into a software architect role before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQL Saturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor for a range of BI topics. You can follow Chris on his blog at http://bidn.com/blogs/cprice1979/ or on Twitter at @BluewaterSQL.
SSIS – Effective Control Flow Execution
Date: Wednesday, July 24, 2013
Time: 2:00 pm – 3:00 pm (Mountain Time)
Summary: Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting help of Foreach Loop container. Foreach loop container provides ability to loop through items of a list. There are 7 types of enumerators for using in this Foreach loop, which provides wide range of lists to be used in loop structure. For example looping through array of items in a variable, or nodes and elements of an XML data, or looping through excel sheets, looping through SQL Server data objects…. In this session audience will learn about all 7 types of enumerators, and real world scenarios of using them in SSIS packages. One of the main benefits of loop structures are helping in creating dynamic task execution, for example dynamic data flow. In this session, there will be samples of creating dynamic data flows with help of Foreach Loop enumerators.
Speaker: Reza Rad: Author, Trainer, Speaker and Senior DW/BI Consultant
About Reza Rad: He has a BSc in Computer engineering; he has more than 10 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for three continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.rad.pasfu.com . He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCTS and MCITP of BI. He is the leader of New Zealand Business Intelligence users group. He is a Technical Speaker in TechEd, SQL Saturdays, SQL users groups, and Conferences. And He is a Microsoft Certified Trainer.