Microsoft Power BI Preview Technical Overview – June 30th

Are you familiar with the Power BI preview but want to drill down on the technical details and capabilities of the service?

Join Sanjay Soni, Technical Product Marketing Manager for Power BI on Tuesday, June 30th at 10AM PT/ 1PM ET to get an overview of Power BI technical details and architecture, including the Power BI Designer, Content Packs, data sources and on-prem connectivity.

For more information, see: Microsoft Power BI Preview Technical Overview

July 2015 – Dan Evans – What’s new with Power BI?

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

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, July 9th, as Dan Evans fills us in on what’s new with Power BI.

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

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

Summary

Power BI for Office 365 today is a cloud service that lets you share, collaborate and access your Excel reports anywhere on any device. With the Power BI Public Preview you can now perform the same deep analytics and rich visualizations using just a web browser. Come see the new experience for yourself and learn how to create interactive dashboards, connect to virtually any data source, enable rich analytics with your applications and power your business with real-time analytics. You can sign up today at https://www.powerbi.com/

Bio

Technology consultant with over 20 years’ experience in applying innovative solutions to business needs. Key focus areas are Business Intelligence, Enterprise Performance Management and Data Strategy. Work heavily in promoting technology across North America through involvement with regional user groups (.NET, PASS) and industry-recognized organizations (TDWI, DAMA).

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/223259083/

June 2015 – Adam Belebczuk – Availability Groups 101: An Introduction

When: Thursday, June 18th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, June 18th, as Adam Belebczuk helps us learn about SQL Server’s AlwaysOn Availability Groups.

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

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

Abstract

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we’ll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.

Bio

Adam Belebczuk is a Consultant, Accidental DBA, and Developer with over 10 years of experience in IT, ranging from customer service to server/network administration to software and database development. Adam holds the MCSE: Data Platform and MCITP DBA 2005/2008 certifications, is a frequent speaker at SQL Server Users Groups and SQL Saturday events, and specializes in SQL development, performance tuning, high availability, & disaster recovery.

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220193017/

May 2015 – See y’all at the BBQ Fest

We will not be having our normal monthly meeting in May. 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, or by clicking here.

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



image002

May 14-15, 2015
By Invitation ONLY!

Presented by:
1E, Aspect, Commvault, Core BTS, HP, Insight, Intel, Jabra, McGladrey, Microsoft, New Horizons, Polycom and Vanick Digital

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 (#R-130-131) at the 2015 Memphis in May – World Championship Barbecue Cooking Contest. Presented by 1E, Aspect, Commvault, Core BTS, HP, Insight, Intel, Jabra, McGladrey, Microsoft, New Horizons, Polycom and Vanick Digital.

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

Dates & Times:

Thursday, May 14 Lunch: 11:30 am – 2:00 pm
Dinner: 4:30 – 7:30 pm
Friday, May 15 Lunch: 11:30 am – 1:30 pm

 

Location:

R130-131 Tent #130 and 131

 

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.

Apr 2015 – DBA to Data Scientist

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

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Apr 9th, as Cherie Sherriff, helps us learn more about the migration from DBA to Data Scientist.

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

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/221087006/


DBA to Data Scientist:

Data Science is one of the technology hot topics and growing career fields. How does the journey start from being a DBA to following a path of data analytics to the point where you become a Data Scientist? What do you need to know and where can you find that information? If you have ever wondered what the difference is, how to get there, what you might need to learn, or even IF you want to go that route, this session will cover the key points to all of these questions and provide you with ample resources to make this journey.

Mar 2015 – A Window into Your Data: Using SQL Window Functions

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

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Mar 12th, as Steve Hughes from Pragmatic Works, helps us learn more about SQL Server’s Window functions.

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

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220657051/


Abstract:
Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.

Bio:
Steve Hughes is an Architect at Pragmatic Works. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored three books and delivered multiple presentations on SQL Server and data architecture over the past six years.

Feb 2015 – Tips and Tricks for Planning a Data Warehouse

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

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Feb 12th, as we take a look at Tips and Tricks for Planning a Data Warehouse.

Do you have a new, or on-going, Data Warehouse project but are not sure how to proceed? Planning the design of a Data Warehouse can be a daunting task and overall these projects have a low success rate. Join us as we see what Brian Knight help us learn tips and tricks for planning the design of a data warehouse as well as walk through the actual implementation of dimensional model.

We’ll be review a recent webinar from Pragmatic Works where Brian Knight covers a number of items to keep in my as you plan, or implement, your data warehouse project.

Do you have any tips and tricks, best practices, or horror stories, you’d like to share with us? Join us and hopefully you’ll learn a few things that can help make your data warehouse project successful.

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

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220131618/

January 2015 – Autogenerate a Dimensional Data Warehouse from Metadata

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

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Most data warehouse design efforts produce a large amount of metadata in the form of handwritten documentation. If done properly, this documentation provides everything the development team requires to build the dimensional data model and load that model with transformed data using the patterns and best practices that were also specified as part of the warehouse design. Unfortunately, the process of translating requirements to T-SQL scripts and SSIS packages requires tremendous effort and creates assets that are expensive to maintain.

Join us this Thursday, Jan 15th, as we take a look at one of the sessions from the 2014 PASS Summit where Scott Currie will show how to use a metadata database to store the requirements information, and then use this metadata to automatically generate EVERYTHING you need for your data warehouse project: documentation, schemas, SSIS packages, deployment scripts, etc. The code for the solution, which is presently in use in production data warehouses in major international companies, will be provided for all attendees to freely use.

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

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

Nov 2014 – Enterprise Information Management using SQL Server 2014

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

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Nov 13th, as we take a look at some of the Enterprise features offered by the latest version of SQL Server.

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

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

Abstract

Enterprise Information Management (EIM) is a growing priority for organizations that want to gain a competitive advantage by basing key business decisions on credible, consistent, data.

Some of the challenges involved in implementing an effective EIM solution include:
• Integrating data from an increasing number of diverse sources and in a growing number of formats into a common platform for decision making
• Empowering information workers who understand the business to manage data governance, while ensuring IT maintain control

SQL Server provides a comprehensive platform for EIM, which makes it possible to:
• Integrate any data from applications and systems across the enterprise
• Make trusted decisions based on cleansed and standardized data
• Empower business users to manage data governance and easily gain insights from data

Come see how to quickly implement your own EIM environment and learn from industry experts around best practices from the field.

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/215104672/