Sept 13th Meeting – Robert Cain – Make SQL Server Pop with PowerShell

When: Thursday, Sept 13th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Sept 13th, as Robert Cain talks to us about how to use PowerShell to make SQL Server pop.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

Abstract:

PowerShell is everywhere, and that includes SQL Server. In this session we’ll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects). Learn how to handle common DBA tasks, such as checking the status of various services, validating backups, and checking for disk usage. You’ll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Come see how to make your SQL Server Pop with PowerShell.

Bio:

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP in SQL Server, MCTS Certified in BI, and works as a Senior Consultant for Pragmatic Works. He is also a technical contributor to Plurasight Training, co-author of Volumes 1 and 2 of “SQL Server MVP Deep Dives”, as well as “Professional SQL Server 2012 Administration”. A popular speaker, Robert has presented at events such as TechEd, SQL Rally, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.

Eventbrite - Memphis PASS - Robert Cain - Make SQL Server Pop with PowerShell

Aug 9th Meeting – Shawn Jackson – Tips and Tricks for Dimensional Modeling

When: Thursday, Aug 9th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Aug 9th, as Shawn Jackson shows us a few tips and tricks about dimensional modeling.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

Abstract:

Dimensional modeling is a set of techniques and concepts used in data warehouse design. It is intended to support end-user queries and is oriented around understandability and performance. Dimensional modeling always uses the concepts of facts (measures) and dimensions (context). Facts are typically (but not always) numerical values that can be aggregated and dimensions are groups of hierarchies and descriptors that define the facts. For example, sales amount is a fact; timestamp, product, register#, store#, etc. are elements of dimensions. Dimensional models are built by business process area, e.g. store sales, inventory, claims, etc.

We will cover the basics of dimensional modeling such as defining dimensions and facts, identifying the grain and star schema versus snowflake schema. We will also cover tips and tricks for dealing with more advanced topics such as roleplaying dimensions, fact-less fact tables and the different modeling techniques for slowly changing dimensions.

Bio:

Shawn Jackson has 16 years of experience working as an application developer for Morgan Keegan (now Raymond James) including 12 years of SQL Server experience. In 2007 he began working on Morgan Keegan’s BI initiative and became Microsoft Certified in SQL Server BI. Shawn has since designed, built and implemented their data warehouse. Shawn holds a BS and MS in Electrical Engineering from the University of Memphis.

Eventbrite - Memphis PASS - Shawn Jackson - Tips and Tricks for Dimensional Modeling

July 12th Meeting – 2011 PASS Summit Presentation

When: Thursday, July 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

This month we will do something a little different. Due to our planned speaker not being available for the meeting, we have decided that for this meeting, we will watch one of the presentations from the 2011 PASS Summit, followed by a discussion of the presentation.

Please review the list of presentation listed at http://mem-pass.org/summits/2011/2011summit.htm

We will choose a presentation at the meeting.

Please register if you plan to attend so we can get enough food for everybody. Hope to see you all there.

Eventbrite - Memphis PASS Chapter July 2012 Meeting

June 14th Meeting – Dan Evans – PowerPivot and Power View for SQL 2012

Abstract:

Microsoft SQL Server PowerPivot for Microsoft Excel (PowerPivot for Excel) is a data analysis tool that delivers unmatched computational power directly within the application that you already know and love—Microsoft Excel. PowerPivot for Excel Help will get you up to speed and enable you to be productive right away.

Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from data models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations.

Come learn the benefits (and challenges) of these tools in the Microsoft Business Intelligence (MS BI) feature set. We’ll walk through some of the key components necessary to implement these tools and share some best practices

Bio:

Dan Evans is the Director and Market Lead for the Americas Business Intelligence Service Line at Avanade, Inc. He benefits from 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel promotes technology for business use through various channels by sponsoring user groups like The Data Warehousing Institute (TDWI) Mid-South Chapter, the Mid-South Data Management Association (DAMA) chapter and is founder and acting president of the Memphis Professional Association of SQL Server (PASS) chapter. Dan holds several MCPs in SQL Server and SharePoint and is Certified Business Intelligence Certification (CBIP) with Mastery in Leadership and Management, Business Analytics, Data Analysis and Design and Data Integration. Daniel is a nationally recognized speaker at TDWI, TechEd and PASS on topics related to SQL Server and SharePoint.


Here’s the presentation and the scripts from Dan’s presentation:

MEM-PASS April 2012 – PowerPivot and Power View

Here are a few important links that Dan wanted to add as well:

http://www.microsoft.com/en-us/bi/default.aspx – PowerPivot tab for the download for Office 2010

http://technet.microsoft.com/en-us/library/gg399157.aspx – Introduction to PowerPivot for Excel

http://technet.microsoft.com/en-us/library/hh213579.aspx – Introduction to Power View

http://www.microsoft.com/en-us/download/details.aspx?id=26718 – Samples of PowerPivot Excel spreadsheet and Power View report. The tutorial documents (in zip file) can be found on this page as well.

By Invitation Only! Join us for BBQ Fest!

We will not be having our normal monthly meeting this month. Instead, you’re all invited to come sample some of the best BBQ on earth.

This is by invitation only so don’t forget to click one of the links below for your invitation.

See you there. Don’t forget to bring your appetite. 😉


Smoke Masters Championship BBQ Team


May 17-18, 2011By Invitation ONLY!

Presented by:

Microsoft, BT, New Horizons, HP, SoftChoice, Citrix, Quest, Polycom, Avanade, and Aspect

Register now to reserve your space!

Questions?
Contact Aimee Howell @ 901.375.1533 or email @ ahowell@nhmemphis.com.

As a valued customer, we have your tent waiting…
Please join us in the Smoke Masters Championship BBQ Team Tent (#H-135) at the 2012 Memphis in May – World Championship Barbecue Cooking Contest. Presented by Microsoft, BT, New Horizons Computer Learning Center, HP, SoftChoice, Citrix, Quest, Polycom, Avanade, and Aspect.

 

This event is by INVITATION ONLY, so we encourage you to reserve your seat today.

Dates & Times

Thursday, May 17 Lunch: 11:30 am – 2:00 pm
Dinner: 4:30 – 7:00 pm
Friday, May 18 Lunch: 11:30 am – 2:00 pm

Location

H135 – Whole Hog Section – Tent #135

General Information

Admission to Memphis In May is FREE from 11:00 AM to 1:00 PM. Single Day Tickets are $8 (after 1:00 PM) – Children 6 and under are Free.Admission to the Smoke Masters tent is free to invited guests. Great prizes will be raffled both days at Noon and 7:00 pm!

Apr 12th Meeting – Dan Evans – What’s New With BI in SQL Server 2012?

When: Thursday, Apr 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, April 12th, as Dan Evans talks to us about what SQL 2012 has new for BI.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

Abstract:

With the recent launch announcement SQL Server 2012, Microsoft has focused on providing enterprise-ready Business Intelligence platform to support all of an organizations data needs. A new edition of SQL Server – the BI Edition – focuses entirely upon delivering these solutions with the optimal assembly of assets necessary for deployments.

In his presentation, Dan will talk to us about:

  • Understanding more about the components included in SQL Server 2012 BI Edition and comparisons between editions
  • Identifying highlights of major changes since 2008 R2
  • Seeing BI in action with Management Studio, Visual Studio, Reporting Services, Analysis Services and PowerPivot/PowerView
  • Capturing necessary resources to get started with SQL Server 2012

Bio:

Dan Evans is the Director and Market Lead for the Americas Business Intelligence Service Line at Avanade, Inc. He benefits from 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel promotes technology for business use through various channels by sponsoring user groups like The Data Warehousing Institute (TDWI) Mid-South Chapter, the Mid-South Data Management Association (DAMA) chapter and is founder and acting president of the Memphis Professional Association of SQL Server (PASS) chapter. Dan holds several MCPs in SQL Server and SharePoint and is Certified Business Intelligence Certification (CBIP) with Mastery in Leadership and Management, Business Analytics, Data Analysis and Design and Data Integration. Daniel is a nationally recognized speaker at TDWI, TechEd and PASS on topics related to SQL Server and SharePoint.

 

Eventbrite - Memphis PASS Chapter - Dan Evans - What's New With BI in SQL Server 2012?