Avatar of Alvin Ramard

by Alvin Ramard

By Invitation Only! Join us for BBQ Fest!

April 15, 2012 in Notices

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!

Number of View :173

No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

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

March 31, 2012 in Meetings

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?


Number of View :238

Tags: , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Mar 15th Meeting – Jim Houchin – Enterprise SQL security and job monitor

March 12, 2012 in Meetings

When: Thursday, Mar 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

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

Due to circumstances beyond our control Charles Watkins will not be available for our March 15th meeting.

Instead, our own Jim Houchin will show us how we can use SQL server to make the task of monitoring SQL server easier.

So join us Thursday, March 15th, and let Jim should you how to make life easier for the DBA.

Abstract:

How can you use the capabilities of SQL server to help you monitor the status of multiple servers without having to monitor each server independantly? Leveraging the powers of SQL server’s Integration Services (SSIS) and Reporting Services (SSRS), you can create an extendable SSIS/SSRS based monitor for all SQL servers in our enterprise. SQL 2008 R2 Central Management server allows you to setup the monitoring once and then use it to monitor all your SQL servers.

Bio:

Jim Houchin has over ten years of experience in software design, development, and implementation, of web and database applications, with a touch of QA. Jim’s focus for the last year has been as a DBA at Yusen Logistics concentrating on SQL administration and maintenance on SQL 2000, 2005 and 2008R2. Jim also has a strong desire to learn new technologies and he is eager to share information.

Jim Houchin is a Vice-President of the Memphis PASS Chapter.

Eventbrite - Memphis PASS Chapter - Jim Houchin - Enterprise SQL security & job monitor


Number of View :240

Tags: , , , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Mar 15th Meeting – Charles Watkins – SQL Server 2012 PowerView

February 23, 2012 in Meetings

When: Thursday, Mar 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

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

Abstract:

Join us on Thursday, Mar 15th, and give a warm welcome to Charles Watkins from New Horizons.

SQL Server 2012 (formally code named Denali) has introduced the new Business Intelligence Semantic Model (BISM) supported by PowerView.

Power View is an interactive data exploration, visualization, and presentation experience that replaces Report Builder 1.0.  It allows for adhoc report creation based on Excel 2010 PowerPivot or the new Sql Server 2012 Analysis Services  (SSAS) tabular models.  PowerView 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. It is an extension of Sql Sever 2012 Reporting Services.

We will be introduced to the setup, and potential use of PowerView.

Bio:

Charles B. Watkins, Sr. has experience in working with business entities public, private and nonprofit.  He has be the primary instructor for Sql Server at New Horizons for the past 13 years and has been an employee of New Horizons Computer Learning Center of Memphis for a total of 16 years.  He is certified in  Sql Server 2000, 2005, 2008 – Windows 2000, 2003, 2008 – Sharepoint 2010 – Windows Vitalization – and Lotus Notes (MCP, MCT, MCSA, MCSE, MCTS, MCITP, CLI, CLP).

He loves anything dealing with computers and the new technology that is surrounding Windows, Sql and Sharepoint.

Register for Memphis PASS Chapter - Charles Watkins - SQL Server 2012 PowerView in Memphis, TN on Eventbrite


Number of View :264

Tags: , , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Feb 9th Meeting – Louis Davidson – What Counts For a DBA?

February 2, 2012 in Meetings

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

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

Join us on Thursday, Feb 9th, and give a warm welcome to Louis Davidson from the Nashville Chapter.

Abstract:
The world of a DBA can be daunting for a person, either as a new or old, because not only do they need to keep up with new and emerging technologies, but also with the code and designs of their coworkers. In this highly participation driven session, we will employ a random topic chooser to pick several of these traits for discussion as a group. Possible topics include past blog topics such as Logic, Curiosity, Failure, Humility, Skill and Passion, as well as any other topics that might be added for that day. So come prepared to participate and voice your opinion about what counts for a DBA.

Bio:
Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. For more information please visit DrSQL.org

Register for Memphis PASS Chapter Meeting - Louis Davidson - What Counts For a DBA? in Memphis, TN on Eventbrite


Number of View :287

Tags: , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

An SSIS Challenge From Brian Knight

January 19, 2012 in Uncategorized

An SSIS Challenge From Brian Knight

Prove your SSIS skills by besting the experts at Pragmatic Works! This Whitepaper is designed to help you map a technical SQL Server Integration Services (SSIS) solution to a business problem. To do this, we give you a business problem to solve with loose requirements. You can then solve it however you wish inside of SSIS as long as you meet the requirements. We provide hints on how to solve the problem and if you need some more help, you can read the high-level step by step instructions. Good luck!

Download the Challenge Now!

Knight's 24 Hour Trainer

What you’ll learn:

  • Learn how to use the Pivot transformation
  • Learn more about using expressions
  • Learn more about the Lookup transformation
  • Learn more about the Derived Column tranformation
  • Learn more about the Conditional Split transformation

Download the Challenge Now!

Number of View :337

Tags: No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Jan 12th Meeting – Dan Evans – Knight’s 24-hour Business Intelligence Trainer – Section VI – SharePoint

January 2, 2012 in Meetings

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

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

Join us on Thursday, Jan 12th, as Dan Evans walks us through Section VI of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer and shows us how Microsoft SharePoint fits in the BI environment.

Abstract:
This month we will be wrapping up the review of the 24-Hours of BI with the final section on SharePoint BI. Come learn the main concepts of SharePoint as they relate to your BI efforts. See how to deploy SSRS reports and create Dashboards in PerformancePoint. You can view how Excel services can help your BI efforts and maybe even see some neat things with PowerPivot. We’ll also highlight some basic security and administration features within SharePoint so you can maximize your investment in Microsoft technologies.

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.

Register for Knight's 24-hour Business Intelligence Trainer - Section VI - SharePoint in Memphis, TN on Eventbrite


Number of View :280

Tags: , , , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Dec 15th Meeting – Douglas Johnston – SQL Server Denali (SQL Server 2012)

November 27, 2011 in Meetings

When: Thursday, Dec 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

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

Abstract:
This month, Douglas Johnston introduces the new version of SQL Server, codename Denali.  From T-SQL additions to the new Integration Services designer, from Master Data Services to the new Visual Studio project types, he will walk through a real-world example of each.  As Douglas is also currently implementing all of these for a client, he will also demonstrate the pitfalls and bugs of the pre-release software.  If you are considering upgrading to SQL Server 2012, this session will give you great information on what the benefits and the risks are.

Bio:
Douglas Johnston is a Group Manager in the Business Intelligence & Collaboration Service Line of Avanade. With 10 years of experience with SQL Server and business intelligence tools, in industries as diverse as healthcare, financial services, defense and energy utilities, he has become one of the leading contributors to the Avanade BI community. He advises on, and develops projects with, aspects of database development, performance tuning, architecture, warehouse design and management, high availability, ETL and reporting systems. He is also a founding member of the peer-nominated Avanade Expert Network and holds several Microsoft certifications.

Before becoming a database ninja, Douglas developed with VB6, Perl, Oracle, Business Objects and J2EE, as well as some other really terrible technologies. He has particularly desiccated sense of humor to go with the British accent, owns a kilt, and likes monkeys.

Register for Memphis PASS Chapter Meeting - Douglas Johnston – SQL Server Denali in Memphis, TN on Eventbrite


Number of View :325

Tags: , , , No Comments »

Avatar of Jim Houchin

by Jim Houchin

SQL Server 2012 RC0

November 17, 2011 in Notices

MS SQL 2012 RC0

MS SQL 2012 RC0

Just letting everyone know it appears SQL Server 2012 RC0 is out! Hope you guys enjoy it as much as I do!

http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

 


Number of View :228

No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Nov 10th Meeting – Dan Evans – 24-hour Business Intelligence Trainer – Section 3 – SSAS

November 6, 2011 in Meetings

When: Thursday, Nov 10th
Pizza at 5:30 PM
Meeting at 6:00 PM

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

Join us on Thursday, Nov 10, as Dan Evans walks us through Section III of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer as we look at SQL Server Analysis Services (SSAS) in the BI environment.

Abstract:
For this month’s meetinng, we’ll be going over Section III of the Knight’s Microsoft Business Intelligence 24-Hour Trainer about SQL Server Analysis Services (SSAS).   We’ll show the major components of SSAS including Data Sources, Dimensions and basic MDX expressions.  You’ll see how these points are aplied using the SSAS project and the Cube Wizard.  Come learn what SSAS is an what it can do for your Business Intelligence (BI) projects!

Bio:
Dan Evans benefits from almost 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 is an MCP and is a TDWI Certified Business Intelligence Professional (CBIP) with Mastery in Leadership and Manager, Business Analytics, Data Analysis and Design and Data Integration.


Number of View :243

Tags: , , , No Comments »

Switch to our mobile site